View: CEFV_BANK_STATEMENT_LINES

Product:	CE - Cash Management
Description:	Business View
Implementation/DBA Data:	APPS.CEFV_BANK_STATEMENT_LINES

View Text

SELECT SL.STATEMENT_LINE_ID
, SL.LINE_NUMBER
, SL.TRX_DATE
, L1.MEANING
, TC.TRX_CODE
, SL.AMOUNT
, L2.MEANING
, SL.EFFECTIVE_DATE
, SL.BANK_TRX_NUMBER
, SL.TRX_TEXT
, SL.CUSTOMER_TEXT
, SL.BANK_ACCOUNT_TEXT
, SL.INVOICE_TEXT
, SL.CURRENCY_CODE
, DC.USER_CONVERSION_TYPE
, SL.EXCHANGE_RATE
, SL.EXCHANGE_RATE_DATE
, SL.ORIGINAL_AMOUNT
, SL.CHARGES_AMOUNT
, SH.STATEMENT_NUMBER
, SH.STATEMENT_DATE
, SL.STATEMENT_HEADER_ID
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
FROM CE_STATEMENT_LINES SL
, CE_LOOKUPS L1
, CE_TRANSACTION_CODES TC
, CE_LOOKUPS L2
, GL_DAILY_CONVERSION_TYPES DC
, CE_STATEMENT_HEADERS SH
WHERE L1.LOOKUP_TYPE = 'BANK_TRX_TYPE'
AND L1.LOOKUP_CODE = SL.TRX_TYPE
AND TC.TRANSACTION_CODE_ID (+) = SL.TRX_CODE_ID
AND L2.LOOKUP_TYPE = 'STATEMENT_LINE_STATUS'
AND L2.LOOKUP_CODE = SL.STATUS
AND DC.CONVERSION_TYPE (+) = SL.EXCHANGE_RATE_TYPE
AND SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID WITH READ ONLY

Columns