VIEW: APPS.CE_CP_DISC_IDA_V

Source

View Text - Preformatted

SELECT WSL.worksheet_header_id, HEAD.bank_account_id, WSL.worksheet_line_id, WSL.description, LINE.line_number, decode(LINE.trx_type, 'DEBIT', -LINE.amount, 'MISC_DEBIT', -LINE.amount, LINE.amount) FROM CE_INTRA_STMT_HEADERS HEAD, CE_INTRA_STMT_LINES LINE, CE_CP_WORKSHEET_LINES WSL WHERE HEAD.statement_header_id = LINE.statement_header_id AND to_date(HEAD.statement_date,'YYYY/MM/DD') = to_date(nvl(LINE.effective_date, HEAD.statement_date),'YYYY/MM/DD') AND HEAD.statement_date = ( SELECT max(HEAD2.statement_date) FROM CE_INTRA_STMT_HEADERS HEAD2 WHERE HEAD.bank_account_id = HEAD2.bank_account_id AND to_date(HEAD2.statement_date,'YYYY/MM/DD') = to_date(sysdate,'YYYY/MM/DD')) AND WSL.source_type = 'IDA' AND WSL.include_flag = 'Y' AND (WSL.trx_type = 'ALL' OR LINE.trx_type = WSL.trx_type)

View Text - HTML Formatted

SELECT WSL.WORKSHEET_HEADER_ID
, HEAD.BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, LINE.LINE_NUMBER
, DECODE(LINE.TRX_TYPE
, 'DEBIT'
, -LINE.AMOUNT
, 'MISC_DEBIT'
, -LINE.AMOUNT
, LINE.AMOUNT)
FROM CE_INTRA_STMT_HEADERS HEAD
, CE_INTRA_STMT_LINES LINE
, CE_CP_WORKSHEET_LINES WSL
WHERE HEAD.STATEMENT_HEADER_ID = LINE.STATEMENT_HEADER_ID
AND TO_DATE(HEAD.STATEMENT_DATE
, 'YYYY/MM/DD') = TO_DATE(NVL(LINE.EFFECTIVE_DATE
, HEAD.STATEMENT_DATE)
, 'YYYY/MM/DD')
AND HEAD.STATEMENT_DATE = ( SELECT MAX(HEAD2.STATEMENT_DATE)
FROM CE_INTRA_STMT_HEADERS HEAD2
WHERE HEAD.BANK_ACCOUNT_ID = HEAD2.BANK_ACCOUNT_ID
AND TO_DATE(HEAD2.STATEMENT_DATE
, 'YYYY/MM/DD') = TO_DATE(SYSDATE
, 'YYYY/MM/DD'))
AND WSL.SOURCE_TYPE = 'IDA'
AND WSL.INCLUDE_FLAG = 'Y'
AND (WSL.TRX_TYPE = 'ALL' OR LINE.TRX_TYPE = WSL.TRX_TYPE)