VIEW: APPS.IBY_FNDCPT_PAYER_ASSGN_BA_V

Source

View Text - Preformatted

SELECT u.rowid, u.instrument_payment_use_id, u.ext_pmt_party_id, p.payment_function, p.party_id, p.org_type, p.org_id, p.cust_account_id, p.acct_site_use_id, u.instrument_type, u.instrument_id, u.order_of_preference, b.currency_code, b.masked_bank_account_num, BR.bank_name, BR.bank_number, b.bank_account_num_hash1, b.bank_account_num_hash2, BR.bank_branch_name, BR.branch_number, NULL, b.description, u.last_update_date, u.start_date, u.end_date, u.created_by, u.creation_date, u.last_updated_by, u.last_update_date, u.last_update_login, u.object_version_number, NVL(b.encrypted, 'N') FROM IBY_EXTERNAL_PAYERS_ALL P, IBY_EXT_BANK_ACCOUNTS B, CE_BANK_BRANCHES_V BR, IBY_PMT_INSTR_USES_ALL U WHERE (u.ext_pmt_party_id = p.ext_payer_id) AND u.instrument_id = b.ext_bank_account_id AND b.bank_id = br.bank_party_id (+) AND b.branch_id = br.branch_party_id (+) AND u.payment_flow = 'FUNDS_CAPTURE' AND u.instrument_type = 'BANKACCOUNT'

View Text - HTML Formatted

SELECT U.ROWID
, U.INSTRUMENT_PAYMENT_USE_ID
, U.EXT_PMT_PARTY_ID
, P.PAYMENT_FUNCTION
, P.PARTY_ID
, P.ORG_TYPE
, P.ORG_ID
, P.CUST_ACCOUNT_ID
, P.ACCT_SITE_USE_ID
, U.INSTRUMENT_TYPE
, U.INSTRUMENT_ID
, U.ORDER_OF_PREFERENCE
, B.CURRENCY_CODE
, B.MASKED_BANK_ACCOUNT_NUM
, BR.BANK_NAME
, BR.BANK_NUMBER
, B.BANK_ACCOUNT_NUM_HASH1
, B.BANK_ACCOUNT_NUM_HASH2
, BR.BANK_BRANCH_NAME
, BR.BRANCH_NUMBER
, NULL
, B.DESCRIPTION
, U.LAST_UPDATE_DATE
, U.START_DATE
, U.END_DATE
, U.CREATED_BY
, U.CREATION_DATE
, U.LAST_UPDATED_BY
, U.LAST_UPDATE_DATE
, U.LAST_UPDATE_LOGIN
, U.OBJECT_VERSION_NUMBER
, NVL(B.ENCRYPTED
, 'N')
FROM IBY_EXTERNAL_PAYERS_ALL P
, IBY_EXT_BANK_ACCOUNTS B
, CE_BANK_BRANCHES_V BR
, IBY_PMT_INSTR_USES_ALL U
WHERE (U.EXT_PMT_PARTY_ID = P.EXT_PAYER_ID)
AND U.INSTRUMENT_ID = B.EXT_BANK_ACCOUNT_ID
AND B.BANK_ID = BR.BANK_PARTY_ID (+)
AND B.BRANCH_ID = BR.BRANCH_PARTY_ID (+)
AND U.PAYMENT_FLOW = 'FUNDS_CAPTURE'
AND U.INSTRUMENT_TYPE = 'BANKACCOUNT'