IBY_FNDCPT_PAYER_ALL_INSTRS

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
PARTY_ID INSTRUMENT_TYPE INSTRUMENT_ID CURRENCY_CODE CARD_NUMBER CC_NUMBER_HASH1 CC_NUMBER_HASH2 CARD_EXPIRYDATE CARD_ISSUER_CODE CARD_ISSUER_NAME PURCHASECARD_SUBTYPE CARD_HOLDER_NAME CARD_BILLING_ADDRESS_ID CARD_FI_NAME CARD_SINGLE_USE_FLAG ACCOUNT_NUMBER BANK_ACCT_NUM_HASH1 BANK_ACCT_NUM_HASH2 BANK_NAME BANK_NUMBER BRANCH_NAME BRANCH_NUMBER BIC_NUMBER DESCRIPTION

Name

PARTY_ID

INSTRUMENT_TYPE

INSTRUMENT_ID

CURRENCY_CODE

CARD_NUMBER

CC_NUMBER_HASH1

CC_NUMBER_HASH2

CARD_EXPIRYDATE

CARD_ISSUER_CODE

CARD_ISSUER_NAME

PURCHASECARD_SUBTYPE

CARD_HOLDER_NAME

CARD_BILLING_ADDRESS_ID

CARD_FI_NAME

CARD_SINGLE_USE_FLAG

ACCOUNT_NUMBER

BANK_ACCT_NUM_HASH1

BANK_ACCT_NUM_HASH2

BANK_NAME

BANK_NUMBER

BRANCH_NAME

BRANCH_NUMBER

BIC_NUMBER

DESCRIPTION

Query

SQL_Statement
SELECT c.card_owner_id, 'CREDITCARD', c.instrid, NULL, c.masked_cc_number, c.cc_number_hash1, c.cc_number_hash2, c.expirydate, c.card_issuer_code, i.card_issuer_name, c.purchasecard_subtype, 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, 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)

SQL_Statement

SELECT c.card_owner_id, 'CREDITCARD', c.instrid, NULL, c.masked_cc_number, c.cc_number_hash1, c.cc_number_hash2, c.expirydate, c.card_issuer_code, i.card_issuer_name, c.purchasecard_subtype, 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, 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)