Payment Reason table in Oracle Fusion

Hi Friends, we are going to discuss about the Payment Reason table in Oracle Fusion. We will try to find the table in oracle fusion which do store the payment reason. We will also share the sql query which will help to extract the payment reason details including other supplier banking informations in oracle fusion. Supplier Payment related stuff usually stores in the 'IBY' tables. These tables help to store the supplier banking details as well the payment reason table in oracle fusion. Please find below the more detail about Payment Reason table in Oracle Fusion.

Payment Reason table in Oracle Fusion

Important Table to store the Payment Reason details in Oracle Fusion

1. IBY_EXTERNAL_PAYEES_ALL 

select payment_reason_code from IBY_EXTERNAL_PAYEES_ALL

WHERE PAYMENT_REASON_CODE is not null

SQL Query to extract the Payment Reason detail with Other Supplier Banking Information in Oracle Fusion

select VENDOR_NAME, IEPA.payment_reason_code, 

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 POZ_SUPPLIERS_V APS,IBY_EXTERNAL_PAYEES_ALL IEPA,IBY_PMT_INSTR_USES_ALL IPIUA,IBY_EXT_BANK_ACCOUNTS IEBA
,ce_banks_v cbv, ce_bank_BRANCHES_V CBBV, POZ_SUPPLIER_SITES_V ass
where 1=1
AND APS.VENDOR_ID=ASS.VENDOR_ID
AND ASS.PRC_BU_ID='8977775390'
AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
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(+)

Payment Reason table in Oracle Fusion