supplier address table oracle r12

supplier address table oracle r12

 

In oracle apps , supplier Address information stores in the AP_SUPPLIER_SITES_ALL table. This table stores the complete information about supplier address. If you want to find the Supplier Communication information then you need to go to AP_SUPPLIER_CONTACT. If you have supplier name then to find the address of the supplier first you need to get the vendor id. Vendor id you will be get in the AP_SUPPLIERS table and then you can go to the AP_SUPPLIER_SITES_ALL table to get the supplier address in oracle apps.

supplier address table oracle r12


AP_SUPPLIERS

This table store Supplier Header Information's in Oracle apps r12.

AP_SUPPLIER_SITES_ALL

This Table stores Supplier sites Information in the Oracle apps R12.

AP_SUPPLIER_CONTACT

This Table store the Supplier Communications information in Oracle apps R12.

PO_VENDORS

This is the View in the Oracle apps which stores Suppliers Information.