Query to get supplier details in oracle apps

Query to get supplier details in oracle apps

Here below , you can find the Supplier Master SQL query to fetch the Supplier Details in Oracle apps r12. This is the complete supplier query which provided supplier header , supplier site and its banking information in oracle apps r12.

select VENDOR_NAME,vendor_site_code,ass.*,
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