View: IBY_FNDCPT_PAYER_ASSGN_INSTR_V

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

View Text

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
, C.MASKED_CC_NUMBER
, C.CC_NUMBER_HASH1
, C.CC_NUMBER_HASH2
, C.EXPIRYDATE
, C.CARD_ISSUER_CODE
, I.CARD_ISSUER_NAME
, I.CARD_ISSUER_ACCEPTED_FLAG
, C.PURCHASECARD_SUBTYPE
, NVL(C.CHNAME
, HZCC.PARTY_NAME)
, C.ADDRESSID
, C.FINAME
, C.SINGLE_USE_FLAG
, C.INFORMATION_ONLY_FLAG
, B.BANK_ACCOUNT_NUMBER
, B.BANK_NAME
, B.BANK_NUMBER
, B.BANK_BRANCH_NAME
, B.BRANCH_NUMBER
, NULL
, NVL(C.DESCRIPTION
, B.DESCRIPTION)
, U.LAST_UPDATE_DATE
, U.CREATED_BY
, U.CREATION_DATE
, U.LAST_UPDATED_BY
, U.LAST_UPDATE_DATE
, U.LAST_UPDATE_LOGIN
, U.OBJECT_VERSION_NUMBER
FROM IBY_CREDITCARD C
, IBY_CREDITCARD_ISSUERS_VL I
, IBY_EXTERNAL_PAYERS_ALL P
, IBY_EXT_BANK_ACCOUNTS_V B
, IBY_PMT_INSTR_USES_ALL U
, HZ_PARTIES HZCC
WHERE (U.EXT_PMT_PARTY_ID = P.EXT_PAYER_ID)
AND (DECODE(U.INSTRUMENT_TYPE
, 'CREDITCARD'
, U.INSTRUMENT_ID
, 'DEBITCARD'
, U.INSTRUMENT_ID
, NULL) = C.INSTRID(+))
AND (DECODE(U.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, U.INSTRUMENT_ID
, NULL) = B.BANK_ACCOUNT_ID(+))
AND (C.CARD_ISSUER_CODE = I.CARD_ISSUER_CODE(+))
AND (C.CARD_OWNER_ID = HZCC.PARTY_ID(+))
AND (NVL(C.INACTIVE_DATE
, SYSDATE+10) > SYSDATE)

Columns