Oracle Account Payables – Vendor Definition – Overview


Use the Supplier window to maintain supplier info. If a supplier is also a customer, then enter the cust account number. For a supplier’s supplier , u can enter the primary supplier info here.

Maintain Vendors

Use the Supplier window to maintain supplier info. If a supplier is also a customer, then enter the cust account number. For a supplier’s supplier , u can enter the primary supplier info here.

Enter supplier type. If vendor is an employee too then enter the employee name.Enter various control parameters like invoice match option, invoice limit and hold info.


Enter payment info like payment terms, currency, payment method etc..Enter Bank account info same way as maintained for customers.Enter Invoice calculation level, tax code and rounding rule etc.Enter Tax reporting attributes like Income tax reporting applicability to state and/or federal govt., reporting name and site etc.
Enter default ship to and bill to location for this supplier. While entering PO, such values may be defaulted from these purchasing attributes.Enter the receiving parameters like receipt routing, match approval method, enforce ship to location, early and late days receipt allowed etc.

Vendor Sites

Enter the supplier site information like site name, address, city, state, country and postal code etc. Click the Check box showing the site use of this supplier site. Enter the site contact points like phone, fax, email etc.
Enter the supplier site  contact persons and their contact points.Enter the supplier site  accounting info. Enter the supplier-site control info, payment info and bank A/c info as described for supplier info. Enter invoice calculation and tax info for the site as defined for supplier.

Enter default ship to and bill to locationand other purchasing options for this supplier site.

Vendor Architecture


Query to find supplier & site info :
select
pov.vendor_id,
pov.vendor_name supplier,
pov.vendor_type_lookup_code,
sl.location_code shipto_location,
bl.location_code billto_location,
pov.customer_num,
pov.ship_via_lookup_code,
pov.fob_lookup_code,
rt.name terms,
pov.set_of_books_id,
pov.credit_status_lookup_code,
pov.credit_limit
from ra_terms rt,
hr_locations bl,
hr_locations sl,
po_vendors pov
where pov.vendor_name like ‘Abb%’
and   pov.ship_to_location_id=sl.location_id(+)
and   pov.bill_to_location_id=bl.location_id(+)
and   pov.terms_id=rt.term_id(+)
order by 1
/
select
pov.vendor_name Supplier,
povs.vendor_site_id,
povs.vendor_site_code Site,
povs.address_line1 A1ddress,
povs.address_line2 A2ddress,
povs.address_line3 A3ddress,
povs.city||’, ‘||
povs.state||’ ‘||
povs.zip A4ddress,
povs.ship_to_location_id,
povs.bill_to_location_id,
povs.ship_via_lookup_code,
povs.freight_terms_lookup_code,
povs.fob_lookup_code
from po_vendors pov,
po_vendor_sites povs
where pov.vendor_id=601
and   pov.vendor_id=povs.vendor_id
order by 1
/
Query to find Supplier contacts :
select
vc.vendor_contact_id,
vc.vendor_site_id,
vc.first_name,
vc.middle_name,
vc.last_name,
vc.prefix,
vc.title,
vc.mail_stop,
vc.area_code,
vc.phone,
vc.department,
vc.email_address,
vc.url,
vc.alt_area_code,
vc.alt_phone,
vc.fax_area_code,
vc.inactive_date,
vc.fax
from po_vendor_contacts vc
where vc.vendor_site_id=4556
order by 1
/

Vendor APIs

Procedure : AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR
Argument Name
————————————————————-
P_VENDOR_NAME
P_VENDOR_TYPE_LOOKUP_CODE
P_TAXPAYER_ID
P_TAX_REGISTRATION_ID
P_WOMEN_OWNED_FLAG
P_SMALL_BUSINESS_FLAG
P_MINORITY_GROUP_LOOKUP_CODE
P_SUPPLIER_NUMBER
X_VENDOR_ID
X_STATUS
X_EXCEPTION_MSG
P_SOURCE
P_WHAT_TO_IMPORT
P_COMMIT_SIZE
Type                          In/Out
———————–          ————–
VARCHAR2                IN
VARCHAR2                IN
VARCHAR2                IN
VARCHAR2                IN
VARCHAR2                IN
VARCHAR2                IN
VARCHAR2                IN
VARCHAR2                IN
NUMBER                    OUT
VARCHAR2                OUT
VARCHAR2                OUT
VARCHAR2                IN
VARCHAR2                IN
NUMBER                    IN
Procedure=> AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_SITE
P_VENDOR_SITE_CODE            VARCHAR2                IN
P_VENDOR_ID                                 NUMBER                  IN
P_ORG_ID                                          VARCHAR2                IN
P_ADDRESS_LINE1                     VARCHAR2                IN
P_ADDRESS_LINE2                     VARCHAR2                IN
P_ADDRESS_LINE3                     VARCHAR2                IN
P_ADDRESS_LINE4                     VARCHAR2                IN
P_CITY                                                VARCHAR2                IN
P_STATE                                            VARCHAR2                IN
P_ZIP                                                  VARCHAR2                IN
P_PROVINCE                                  VARCHAR2                IN
P_COUNTY                                     VARCHAR2                IN
P_COUNTRY                                    VARCHAR2                IN
P_AREA_CODE                             VARCHAR2                IN
P_PHONE                                         VARCHAR2                IN
P_FAX_AREA_CODE                   VARCHAR2                IN
P_FAX                                                   VARCHAR2                IN
P_EMAIL_ADDRESS                     VARCHAR2                IN
P_PURCHASING_SITE_FLAG   VARCHAR2                IN     DEFAULT
P_PAY_SITE_FLAG                        VARCHAR2                IN     DEFAULT
P_RFQ_ONLY_SITE_FLAG         VARCHAR2                IN     DEFAULT
X_VENDOR_SITE_ID                      NUMBER                  OUT
X_STATUS                                          VARCHAR2                OUT
X_EXCEPTION_MSG                     VARCHAR2                OUT
P_SOURCE                                        VARCHAR2                IN     DEFAULT
P_WHAT_TO_IMPORT                  VARCHAR2                IN     DEFAULT
P_COMMIT_SIZE                             NUMBER                  IN     DEFAULT
P_HOLD_UNVALIDATED_INV_FLAG    VARCHAR2                IN     DEFAULT
P_HOLD_ALL_PAYMENTS_FLAG           VARCHAR2                IN     DEFAULT
P_DUNS_NUMBER                                            VARCHAR2                IN     DEFAULT
Procedure=> AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_CONTACT
P_VENDOR_SITE_ID             NUMBER                  IN     DEFAULT
P_FIRST_NAME                   VARCHAR2                IN     DEFAULT
P_LAST_NAME                    VARCHAR2                IN     DEFAULT
P_MIDDLE_NAME                VARCHAR2                IN     DEFAULT
P_PREFIX                            VARCHAR2                IN     DEFAULT
P_TITLE                              VARCHAR2                IN     DEFAULT
P_MAIL_STOP                     VARCHAR2                IN     DEFAULT
P_AREA_CODE                    VARCHAR2                IN     DEFAULT
P_PHONE                             VARCHAR2                IN     DEFAULT
P_ALT_AREA_CODE                VARCHAR2                IN     DEFAULT
P_ALT_PHONE                         VARCHAR2                IN     DEFAULT
P_FAX_AREA_CODE                VARCHAR2                IN     DEFAULT
P_FAX                                     VARCHAR2                IN     DEFAULT
P_EMAIL_ADDRESS                VARCHAR2                IN     DEFAULT
P_URL                                      VARCHAR2                IN     DEFAULT
X_VENDOR_CONTACT_ID        NUMBER                  OUT
X_STATUS                               VARCHAR2                OUT
X_EXCEPTION_MSG                VARCHAR2                OUT
P_SOURCE                               VARCHAR2                IN     DEFAULT
P_WHAT_TO_IMPORT             VARCHAR2                IN     DEFAULT
P_COMMIT_SIZE                      NUMBER                  IN     DEFAULT
Advertisements

One thought on “Oracle Account Payables – Vendor Definition – Overview

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s