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 |
||
Know-Oracle 
One thought