AP_SUPPLIERS _INT holds Supplier information that is loaded by the user for import.
The columns in the table map to the corresponding columns in the PO_VENDORS table.
Payables uses this information to create a new Supplier record when the Supplier Open Interface Import program is submitted.
, Suppliers: New R12 tables -> Old 11i Tables AP_SUPPLIERS – replaces PO_VENDORS AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SIT.
RTF Template- PageBreak Insert definite space in RTF template Use below syntax in Tag to insert space before or after in your template.
, 13/08/2013 The supplier name, legal identifiers of the supplier will be stored in TCA and a reference to the party created in TCA will be stored in AP_SUPPLIERS.
PARTY_ID, to link the party record in TCA.
AP_SUPPLIER_SITES_ALL: This table replaces the old PO_VENDOR_SITES_ALL table.
It stores information about your supplier site level attributes.
, 1] ap_suppliers _int This is the Open interface table for Supplier used to store Supplier header information.
The columns mapped to corresponding AP_SUPPLIERS table.
, 20/12/2017 In this case we have the view AP_SUPPLIERS _AV25 created for vendor_name.
Verify it using the query SELECT * FROM ap_suppliers _av25: Similarly, Query for the audit views of the table AP_SUPPLIER_SITES_ALL We are nothing to do with these audit tables and columns.
, ACCOUNT PAYABLES Un Changed = 224 New Tables = 73 Deleted = 12 11i TABLES.
, PO_VENDORS #> AP_SUPPLIERS.
po_vendors table is replaced with table ap_suppliers in R12.
po_vendors is also present in R12 but as a view in apps schema on ap_suppliers table.
There is no need to do any changes if the proper synonym is present pointing to po_vendors view.
, R12 Table Changes Suppliers: New R12 tables -> Old 11i Tables AP_SUPPLIERS – replaces PO_VENDORS AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SIT.
RTF Template- PageBreak, Table AP_SUPPLIERS SELECT vendor_id, vendor_name,segment1,enabled_flag FROM ap_suppliers WHERE party_id = 301934 Alongside HZ_PARTIES, this is another master table that replaces the PO_VENDORS table of 11i.
Instead of expanding the design of HZ_PARTIES, oracle decided to hold the supplier specific attributes in AP_SUPPLIERS [fair enough ! ].
, When migrating from 11i to Release 12, Payables does not store any address related information for an Employee.
Even for the supplier sites HOME, OFFICE and PROVISIONAL, the address specified in the Human Resource Application is directly referred, through Employee ID from HR tables.