VIEW: APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V

Source

View Text - Preformatted

SELECT c.card_owner_id, 'CREDITCARD', c.instrid, NULL, c.masked_cc_number, c.cc_number_hash1, c.cc_number_hash2, c.expirydate, '**/**', NVL(c.expired_flag, 'N'), c.card_issuer_code, i.card_issuer_name, c.purchasecard_subtype, c.chname, lpad('*', LENGTH(c.chname), '*'), c.addressid, c.finame, c.single_use_flag, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, c.description FROM iby_creditcard c, iby_creditcard_issuers_vl i WHERE(c.card_issuer_code = i.card_issuer_code) UNION SELECT o.account_owner_party_id, 'BANKACCOUNT', b.bank_account_id, b.currency_code, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b.bank_account_number, b.bank_acct_num_hash1, b.bank_acct_num_hash2, b.bank_name, b.bank_number, b.bank_branch_name, b.branch_number, NULL, b.description FROM iby_account_owners o, iby_ext_bank_accounts_v b WHERE(o.ext_bank_account_id(+) = b.bank_account_id)

View Text - HTML Formatted

SELECT C.CARD_OWNER_ID
, 'CREDITCARD'
, C.INSTRID
, NULL
, C.MASKED_CC_NUMBER
, C.CC_NUMBER_HASH1
, C.CC_NUMBER_HASH2
, C.EXPIRYDATE
, '**/**'
, NVL(C.EXPIRED_FLAG
, 'N')
, C.CARD_ISSUER_CODE
, I.CARD_ISSUER_NAME
, C.PURCHASECARD_SUBTYPE
, C.CHNAME
, LPAD('*'
, LENGTH(C.CHNAME)
, '*')
, C.ADDRESSID
, C.FINAME
, C.SINGLE_USE_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, C.DESCRIPTION
FROM IBY_CREDITCARD C
, IBY_CREDITCARD_ISSUERS_VL I WHERE(C.CARD_ISSUER_CODE = I.CARD_ISSUER_CODE) UNION SELECT O.ACCOUNT_OWNER_PARTY_ID
, 'BANKACCOUNT'
, B.BANK_ACCOUNT_ID
, B.CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, B.BANK_ACCOUNT_NUMBER
, B.BANK_ACCT_NUM_HASH1
, B.BANK_ACCT_NUM_HASH2
, B.BANK_NAME
, B.BANK_NUMBER
, B.BANK_BRANCH_NAME
, B.BRANCH_NUMBER
, NULL
, B.DESCRIPTION
FROM IBY_ACCOUNT_OWNERS O
, IBY_EXT_BANK_ACCOUNTS_V B WHERE(O.EXT_BANK_ACCOUNT_ID(+) = B.BANK_ACCOUNT_ID)