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 InformationAP_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