Fusion AP invoice ERROR Report (AP_INTERFACE_REJECTIONS )

------header---

 select air.Reject_lookup_code, rejection_message,aii.*

from 

AP_INTERFACE_REJECTIONS  air,

AP_INVOICES_INTERFACE  aii

where air.PARENT_ID  = aii.INVOICE_ID 

and air.PARENT_TABLE = 'AP_INVOICES_INTERFACE'

and air.created_by =fnd_global.user_name 

and air.LOAD_REQUEST_ID IN (:P_LOAD_REQUEST_ID)

--------------

----Lines 

select air.Reject_lookup_code, rejection_message,aii.*

from 

AP_INTERFACE_REJECTIONS  air,

AP_INVOICE_LINES_INTERFACE  aii

where air.PARENT_ID  = aii.INVOICE_LINE_ID 

and air.PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE'

and air.created_by =fnd_global.user_name 

and air.LOAD_REQUEST_ID IN (:P_LOAD_REQUEST_ID)

Fusion Internal Bank Account Query (ce_bank_accounts)

SELECT

    hou.name                "OPERATING UNIT",

    cbbv.bank_name,

    cbbv.bank_branch_name,

    cba.bank_account_name,

    hp.party_name           "LEGAL ENTITY",

    cbau.ar_use_enable_flag "RECEIVABLES_ACCOUNT_USE",

    cbau.ap_use_enable_flag "PAYABLES_ACCOUNT_USE",

    cba.bank_account_num    "ACCOUNT_NUMBER",

    cba.bank_account_type   "ACCOUNT TYPE",

    cba.iban_number,

    cba.currency_code,

    cba.multi_currency_allowed_flag,

    cba.description

FROM

    ce_bank_accounts      cba,

    ce_bank_acct_uses_all cbau,

    ce_gl_accounts_ccid   cgac,

    ce_bank_branches_v    cbbv,

    hr_operating_units    hou,

    hz_parties            hp

WHERE

        cbbv.bank_party_id = cba.bank_id

    AND cbbv.branch_party_id = cba.bank_branch_id

    AND cba.bank_account_id = cbau.bank_account_id

    AND cgac.bank_acct_use_id = cbau.bank_acct_use_id

    AND cbau.org_id = hou.organization_id

    AND hp.party_id = cba.account_owner_party_id

    AND cba.bank_account_num IN ( :p_bank_account_num )   ----Parameters

https://docs.oracle.com/en/cloud/saas/financials/24b/oedmf/cebankaccounts-4387.html