CE_FUNDING_CARD_ACCOUNTS_V

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

Columns

Name

PAYMENT_INSTRUMENT_ID PAYMENT_INSTRUMENT_ALIAS PAYMENT_NETWORK_CODE INSTRUMENT_TYPE_CODE CURRENCY_CODE LEGAL_ENTITY_ID ASSET_CCID CLEARING_CCID RECONCILIATION_DIFFERENCE_CCID BANK_ID BRANCH_ID MULTI_CURRENCY_ALLOWED_FLAG LEDGER_CURRENCY_CODE PMT_TO_BANK_EXCHG_RATE_TYPE BANK_TO_LEDGER_EXCHG_RATE_TYPE START_DATE END_DATE MAX_PAYMENT_LIMIT MIN_PAYMENT_LIMIT NETWORK_INSTRUMENT_IDENTIFIER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT CPI.PAYMENT_INSTRUMENT_ID, CPI.PAYMENT_INSTRUMENT_ALIAS, CPI.PAYMENT_NETWORK_CODE, CPI.INSTRUMENT_TYPE_CODE, CPI.CURRENCY_CODE, CPI.LEGAL_ENTITY_ID, CPI.ASSET_CCID, CPI.CLEARING_CCID, CPI.RECONCILIATION_DIFFERENCE_CCID, CPI.BANK_ID, CPI.BRANCH_ID, CPI.MULTI_CURRENCY_ALLOWED_FLAG, CPI.LEDGER_CURRENCY_CODE, CPI.PMT_TO_BANK_EXCHG_RATE_TYPE, CPI.BANK_TO_LEDGER_EXCHG_RATE_TYPE, CPI.START_DATE, CPI.END_DATE, CPI.MAX_PAYMENT_LIMIT, CPI.MIN_PAYMENT_LIMIT, CPI.NETWORK_INSTRUMENT_IDENTIFIER, CPI.ATTRIBUTE_CATEGORY, CPI.ATTRIBUTE1, CPI.ATTRIBUTE2, CPI.ATTRIBUTE3, CPI.ATTRIBUTE4, CPI.ATTRIBUTE5, CPI.ATTRIBUTE_NUMBER1, CPI.ATTRIBUTE_NUMBER2, CPI.ATTRIBUTE_NUMBER3, CPI.ATTRIBUTE_NUMBER4, CPI.ATTRIBUTE_NUMBER5, CPI.ATTRIBUTE_DATE1, CPI.ATTRIBUTE_DATE2, CPI.ATTRIBUTE_DATE3, CPI.ATTRIBUTE_DATE4, CPI.ATTRIBUTE_DATE5, CPI.CREATION_DATE, CPI.CREATED_BY, CPI.LAST_UPDATED_BY, CPI.LAST_UPDATE_DATE, CPI.LAST_UPDATE_LOGIN, CPI.OBJECT_VERSION_NUMBER FROM CE_PAYMENT_INSTRUMENTS CPI WHERE INSTRUMENT_TYPE_CODE='ORA_FUNDING_CARD_ACCOUNT'