ce_bank_accounts and iby_ext_bank_accounts
In this post , We will be discuss about ce_bank_accounts and iby_ext_bank_accounts. These are the two tables which helps to store the Banking infromations in oracle apps r12. ce_bank_accounts and iby_ext_bank_accounts both stores the banking informations but for different entities.We do use ce_bank_accounts and iby_ext_bank_accounts tables to extract the banking informations in oracle apps r12. Here below is the detail about ce_bank_accounts and iby_ext_bank_accounts in oracle apps r12.
Two levels of Supplier Bank Detail in Oracle Apps
2 Types of Banking Tables in Oracle Apps
1.ce_bank_accounts.
2.iby_ext_bank_accounts.
1. ce_bank_accounts :- This table help to store the Internal Banking informations in oracle apps. Internal Bank means , those banks which organization do uses for payments to its suppliers. These banks are organization internal banks in oracle apps.
2. iby_ext_bank_accounts :- This table help to store the External banking informations. External Banking In formations means those banks which belongs to our suppliers in oracle apps. This tables stores the Supplier Banking informations.
SQL Query Using ce_bank_accounts and iby_ext_bank_accounts to extract Banking informations in oracle apps
select 'Suppplier Site' "Banking_Info" VENDOR_NAME,IEBA.BANK_ACCOUNT_NUM,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.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, apps.AP_SUPPLIER_SITES_ALL ass
where 1=1
AND APS.VENDOR_ID=ASS.VENDOR_ID
AND ASS.ORG_ID=:P_ORG_ID
AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
AND IEPA.PARTY_SITE_ID IS NULL
AND IEPA.SUPPLIER_SITE_ID IS 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(+)
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.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, apps.AP_SUPPLIER_SITES_ALL ass
where 1=1
AND APS.VENDOR_ID=ASS.VENDOR_ID
AND ASS.ORG_ID=:P_ORG_ID
AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
AND IEPA.PARTY_SITE_ID IS NULL
AND IEPA.SUPPLIER_SITE_ID IS 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(+)
ce_bank_accounts and iby_ext_bank_accounts
0 comments:
Post a Comment