View: CE_CP_DISC_IDA_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View for Intra-day Activities
Implementation/DBA Data:	APPS.CE_CP_DISC_IDA_V

View Text

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)

Columns