View: CE_XLA_EXT_HEADERS_V

Product:	CE - Cash Management
Description:
Implementation/DBA Data:	APPS.CE_XLA_EXT_HEADERS_V

View Text

SELECT AH.EVENT_ID
, CF.CASHFLOW_ID
, ROWIDTOCHAR(AH.ROWID)
, 'CE_TRANS'
, AH.EVENT_TYPE
, AH.ACCOUNTING_DATE
, AH.STATUS_CODE
, AH.REVERSAL_INDICATOR_FLAG
, 'CE_TRANS'
, AH.REVERSAL_FIRST_DIST_ID
, AH.REVERSAL_SECOND_DIST_NUM
, GL.NAME
, LECF.NAME
, BACF.BANK_ACCOUNT_NUM
, DECODE(CF.CASHFLOW_DIRECTION
, 'DEBIT'
, 'PAYMENT'
, 'CREDIT'
, 'RECEIPT'
, CF.CASHFLOW_DIRECTION)
, CF.CASHFLOW_CURRENCY_CODE
, CF.CASHFLOW_DATE
, CF.CASHFLOW_AMOUNT
, DECODE(CF.CASHFLOW_CURRENCY_CODE
, BACF.CURRENCY_CODE
, CF.CASHFLOW_AMOUNT
, CF.BASE_AMOUNT)
, SUBSTR(CF.DESCRIPTION
, 1
, 240)
, CF.REFERENCE_TEXT
, DECODE(CEP_STANDARD.GET_CONVERSION_RATE(CF.CASHFLOW_LEDGER_ID
, CF.CASHFLOW_CURRENCY_CODE
, DECODE(CF.SOURCE_TRXN_TYPE
, 'STMT'
, DECODE(SYS.BSC_EXCHANGE_DATE_TYPE
, 'CFD'
, CF.CASHFLOW_DATE
, 'BSG'
, SH.GL_DATE
, 'CLD'
, AH.CLEARED_DATE
, 'BSD'
, SH.STATEMENT_DATE
, 'CFE'
, CF.CASHFLOW_EXCHANGE_DATE)
, 'BAT'
, DECODE(SYS.BAT_EXCHANGE_DATE_TYPE
, 'CFD'
, CF.CASHFLOW_DATE
, 'AVD'
, CF.ACTUAL_VALUE_DATE
, 'CLD'
, AH.CLEARED_DATE
, 'BSD'
, SH.STATEMENT_DATE
, 'BSG'
, SH.GL_DATE
, 'SLD'
, SL.TRX_DATE
, 'TRX'
, TRX.TRANSACTION_DATE)
, CF.CASHFLOW_EXCHANGE_DATE)
, SYS.CASHFLOW_EXCHANGE_RATE_TYPE)
, 0
, TO_NUMBER(NULL))
, DECODE(CF.SOURCE_TRXN_TYPE
, 'STMT'
, DECODE(SYS.BSC_EXCHANGE_DATE_TYPE
, 'CFD'
, CF.CASHFLOW_DATE
, 'BSG'
, SH.GL_DATE
, 'CLD'
, AH.CLEARED_DATE
, 'BSD'
, SH.STATEMENT_DATE
, 'CFE'
, CF.CASHFLOW_EXCHANGE_DATE)
, 'BAT'
, DECODE(SYS.BAT_EXCHANGE_DATE_TYPE
, 'CFD'
, CF.CASHFLOW_DATE
, 'AVD'
, CF.ACTUAL_VALUE_DATE
, 'CLD'
, AH.CLEARED_DATE
, 'BSD'
, SH.STATEMENT_DATE
, 'BSG'
, SH.GL_DATE
, 'SLD'
, SL.TRX_DATE
, 'TRX'
, TRX.TRANSACTION_DATE)
, CF.CASHFLOW_EXCHANGE_DATE)
, DECODE(CF.CASHFLOW_CURRENCY_CODE
, GL.CURRENCY_CODE
, NULL
, SYS.CASHFLOW_EXCHANGE_RATE_TYPE)
, CF.TRXN_REFERENCE_NUMBER
, CF.BANK_TRXN_NUMBER
, CF.SOURCE_TRXN_TYPE
, TSTC.TRANSACTION_SUB_TYPE_NAME
, CF.ACTUAL_VALUE_DATE
, LECP.NAME
, BACP.BANK_ACCOUNT_NUM
, CF.OFFSET_CCID
, CF.CASHFLOW_STATUS_CODE
, AH.CLEARED_DATE
, AH.CLEARED_AMOUNT
, DECODE(BACF.CURRENCY_CODE
, GL.CURRENCY_CODE
, TO_NUMBER(NULL)
, AH.CLEARED_EXCHANGE_RATE)
, AH.CLEARED_EXCHANGE_DATE
, DECODE(BACF.CURRENCY_CODE
, GL.CURRENCY_CODE
, TO_CHAR(NULL)
, AH.CLEARED_EXCHANGE_RATE_TYPE)
, DECODE(AH.CLEARING_CHARGES_AMOUNT
, 0
, TO_NUMBER(NULL)
, AH.CLEARING_CHARGES_AMOUNT)
, DECODE(BACF.RECON_CE_FOREIGN_DIFF_HANDLING
, /*SYS.FOREIGN_DIFFERENCE_HANDLING*/ 'F'
, TO_NUMBER(NULL)
, DECODE(AH.CLEARING_ERROR_AMOUNT
, 0
, TO_NUMBER(NULL)
, AH.CLEARING_ERROR_AMOUNT))
, DECODE(BACF.RECON_CE_FOREIGN_DIFF_HANDLING
, /*SYS.FOREIGN_DIFFERENCE_HANDLING*/ 'F'
, DECODE(AH.CLEARING_ERROR_AMOUNT
, 0
, TO_NUMBER(NULL)
, AH.CLEARING_ERROR_AMOUNT)
, TO_NUMBER(NULL) )
, LECF.LEGAL_ENTITY_IDENTIFIER
, LECF.REGISTRATION_NUMBER
, LECF.ADDRESS_LINE_1
, LECF.ADDRESS_LINE_2
, LECF.ADDRESS_LINE_3
, LECF.TOWN_OR_CITY
, LECF.POSTAL_CODE
, LECF.COUNTRY
, BBCF.BANK_NAME
, BBCF.BANK_NAME_ALT
, BBCF.SHORT_BANK_NAME
, BBCF.BANK_NUMBER
, BBCF.BANK_BRANCH_NAME
, BBCF.BANK_BRANCH_NAME_ALT
, BBCF.BRANCH_NUMBER
, BBCF.ADDRESS_LINE1
, BBCF.ADDRESS_LINE2
, BBCF.ADDRESS_LINE3
, BBCF.ADDRESS_LINE4
, BBCF.CITY
, BBCF.STATE
, BBCF.PROVINCE
, BBCF.ZIP
, BBCF.COUNTRY
, BBCF.DESCRIPTION
, BBCF.EFT_SWIFT_CODE
, BBCP.BANK_NAME
, BBCP.BANK_NUMBER
, BBCP.BANK_BRANCH_NAME
, BBCP.BRANCH_NUMBER
, BACF.BANK_ACCOUNT_NAME
, BACF.CURRENCY_CODE
, BACF.DESCRIPTION
, BACF.ATTRIBUTE_CATEGORY
, BACF.ATTRIBUTE1
, BACF.ATTRIBUTE2
, BACF.ATTRIBUTE3
, BACF.ATTRIBUTE4
, BACF.ATTRIBUTE5
, BACF.ATTRIBUTE6
, BACF.ATTRIBUTE7
, BACF.ATTRIBUTE8
, BACF.ATTRIBUTE9
, BACF.ATTRIBUTE10
, BACF.ATTRIBUTE11
, BACF.ATTRIBUTE12
, BACF.ATTRIBUTE13
, BACF.ATTRIBUTE14
, BACF.ATTRIBUTE15
, BACF.ASSET_CODE_COMBINATION_ID
, BACF.CASH_CLEARING_CCID
, BACF.BANK_CHARGES_CCID
, BACF.BANK_ERRORS_CCID
, BACF.FX_CHARGE_CCID
, BACF.GAIN_CODE_COMBINATION_ID
, BACF.LOSS_CODE_COMBINATION_ID
, BACF.BANK_ACCOUNT_NAME_ALT
, BACF.IBAN_NUMBER
, BACF.SHORT_ACCOUNT_NAME
, BACF.MULTI_CURRENCY_ALLOWED_FLAG
, BACF.ACCOUNT_HOLDER_NAME_ALT
, BACF.ACCOUNT_HOLDER_NAME
, BACP.BANK_ACCOUNT_NAME
, BACP.CURRENCY_CODE
, BACP.IBAN_NUMBER
, SH.STATEMENT_NUMBER
, SH.STATEMENT_DATE
, SH.DOC_SEQUENCE_ID
, SH.DOC_SEQUENCE_VALUE
, SH.GL_DATE
, TRX.TRANSACTION_DATE
, TRX.SETTLE_BY_SYSTEM_FLAG
, TRX.TRXN_STATUS_CODE
, TRX.ATTRIBUTE_CATEGORY
, TRX.ATTRIBUTE1
, TRX.ATTRIBUTE2
, TRX.ATTRIBUTE3
, TRX.ATTRIBUTE4
, TRX.ATTRIBUTE5
, TRX.ATTRIBUTE6
, TRX.ATTRIBUTE7
, TRX.ATTRIBUTE8
, TRX.ATTRIBUTE9
, TRX.ATTRIBUTE10
, TRX.ATTRIBUTE11
, TRX.ATTRIBUTE12
, TRX.ATTRIBUTE13
, TRX.ATTRIBUTE14
, TRX.ATTRIBUTE15
, AH.CLEARED_EXCHANGE_RATE
, AH.CLEARED_EXCHANGE_RATE_TYPE
FROM CE_CASHFLOWS CF
, CE_CASHFLOW_ACCT_H AH
, XLE_FIRSTPARTY_INFORMATION_V LECF
, XLE_FIRSTPARTY_INFORMATION_V LECP
, XLE_FIRSTPARTY_INFORMATION_V LESRC
, XLE_FIRSTPARTY_INFORMATION_V LEDES
, CE_BANK_ACCOUNTS BACF
, CE_BANK_ACCOUNTS BACP
, CE_BANK_BRANCHES_V BBCF
, CE_BANK_BRANCHES_V BBCP
, CE_STATEMENT_LINES SL
, CE_STATEMENT_HEADERS SH
, GL_LEDGERS GL
, CE_TRXNS_SUBTYPE_CODES TSTC
, CE_PAYMENT_TRANSACTIONS TRX
, HZ_PARTY_SITES PS
, CE_SYSTEM_PARAMETERS SYS
WHERE CF.CASHFLOW_ID = AH.CASHFLOW_ID
AND CF.CASHFLOW_BANK_ACCOUNT_ID = BACF.BANK_ACCOUNT_ID
AND BACF.BANK_BRANCH_ID = BBCF.BRANCH_PARTY_ID
AND CF.CASHFLOW_LEGAL_ENTITY_ID = LECF.LEGAL_ENTITY_ID
AND CF.CASHFLOW_LEDGER_ID = GL.LEDGER_ID
AND BACP.BANK_ACCOUNT_ID(+) = CF.COUNTERPARTY_BANK_ACCOUNT_ID
AND BACP.BANK_BRANCH_ID = BBCP.BRANCH_PARTY_ID(+)
AND TSTC.TRXN_SUBTYPE_CODE_ID(+) = CF.SOURCE_TRXN_SUBTYPE_CODE_ID
AND CF.COUNTERPARTY_PARTY_ID = LECP.PARTY_ID(+)
AND SL.STATEMENT_LINE_ID(+) = CF.STATEMENT_LINE_ID
AND SL.STATEMENT_HEADER_ID = SH.STATEMENT_HEADER_ID(+)
AND TRX.TRXN_REFERENCE_NUMBER(+) = CF.TRXN_REFERENCE_NUMBER
AND TRX.SOURCE_PARTY_ID = LESRC.PARTY_ID(+)
AND TRX.DESTINATION_PARTY_ID = LEDES.PARTY_ID(+)
AND TRX.DESTINATION_PARTY_SITE_ID = PS.PARTY_SITE_ID(+)
AND SYS.LEGAL_ENTITY_ID = CF.CASHFLOW_LEGAL_ENTITY_ID

Columns