View: IBY_FNDCPT_PAYER_ALL_INSTRS_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_FNDCPT_PAYER_ALL_INSTRS_V

View Text

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
, 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_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)

Columns