VIEW: APPS.CEFV_BANK_STATEMENT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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