Supplier tables in oracle apps r12.supplier master tables in oracle r12

Supplier tables in oracle apps r12.supplier master tables in oracle r12

In this post , I am sharing the Suppliers table which stores Supplier Information in the Oracle apps r12. Here below you will find the suppliers Table with Detail Information

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.

To get the Supplier Banking Information in Oracle Apps r12 ,you can refer these below tables.

select VENDOR_NAME,vendor_site_code,IEBA.BANK_ACCOUNT_NUM,IEBA.IBAN,IEBA.BANK_ACCOUNT_NAME,cbv.BANK_NAME,cbv.ADDRESS_LINE1 BANK_ADDRESS_1,CBV.COUNTRY BANK_COUNTRY,
CBV.CITY BANK_CITY,
CBBV.BANK_BRANCH_NAME,CBBV.ADDRESS_LINE1 BRANCH_ADDRESS_1,
CBBV.CITY BRANCH_CITY,CBBV.COUNTRY BRANCH_COUNTRY,CBBV.BRANCH_NUMBER,CBBV.EFT_SWIFT_CODE BIC ,FOREIGN_PAYMENT_USE_FLAG  from apps.AP_SUPPLIERS APS,apps.AP_SUPPLIER_SITES_ALL ass,apps.IBY_EXTERNAL_PAYEES_ALL IEPA,
apps.IBY_PMT_INSTR_USES_ALL IPIUA,APPS.IBY_EXT_BANK_ACCOUNTS IEBA
,apps.ce_banks_v cbv, apps.ce_bank_BRANCHES_V CBBV
where aps.VENDOR_ID=ass.VENDOR_ID
and ass.ORG_ID=:P_ORG_ID
AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
and nvl(iepa.PARTY_SITE_ID,supplier_SITE_ID)=nvl(ass.PARTY_SITE_ID,VENDOR_SITE_ID)
--and  iepa.PARTY_SITE_ID IS not NULL
AND IPIUA.EXT_PMT_PARTY_ID(+)=IEPA.EXT_PAYEE_ID
AND IEBA.EXT_BANK_ACCOUNT_ID(+)=IPIUA.INSTRUMENT_ID
AND IEBA.BANK_ID=cbv.BANK_PARTY_ID(+)
AND IEBA.BRANCH_ID=CBBV.BRANCH_PARTY_ID(+)
group by VENDOR_NAME,vendor_site_code, IEBA.BANK_ACCOUNT_NUM,IEBA.IBAN,IEBA.BANK_ACCOUNT_NAME,cbv.BANK_NAME,cbv.ADDRESS_LINE1,CBV.COUNTRY,
CBV.CITY ,
CBBV.BANK_BRANCH_NAME,CBBV.ADDRESS_LINE1 ,CBBV.CITY ,CBBV.COUNTRY ,CBBV.BRANCH_NUMBER,CBBV.EFT_SWIFT_CODE  ,FOREIGN_PAYMENT_USE_FLAG,
IEBA.ATTRIBUTE2,IEBA.ATTRIBUTE3,IEBA.ATTRIBUTE8,IEBA.ATTRIBUTE9,IEBA.ATTRIBUTE10