View: CE_CP_DISC_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View
Implementation/DBA Data:	APPS.CE_CP_DISC_V

View Text

SELECT HEAD.WORKSHEET_HEADER_ID
, HEAD.BANK_ACCOUNT_ID
, HEAD.WORKSHEET_LINE_ID
, DATA.BALANCE
, HEAD.SOURCE_DESCRIPTION
, HEAD.SOURCE_TYPE
, HEAD.TRX_DESCRIPTION
, DATA.DETAIL FROM (SELECT WBA.WORKSHEET_HEADER_ID
, WBA.BANK_ACCOUNT_ID
, SRC.SOURCE_TYPE
, SRC.WORKSHEET_LINE_ID
, SRC.SOURCE_DESCRIPTION
, SRC.TRX_DESCRIPTION FROM CE_CP_WS_BA_DISC_V WBA
, (SELECT WSH.WORKSHEET_HEADER_ID
, LK.LOOKUP_CODE SOURCE_TYPE
, LK.MEANING SOURCE_DESCRIPTION
, NULL TRX_DESCRIPTION
, -1 WORKSHEET_LINE_ID FROM CE_CP_WORKSHEET_HEADERS WSH
, CE_LOOKUPS LK
WHERE LK.LOOKUP_TYPE = 'POSITION_SRC_TYPE' AND LK.LOOKUP_CODE IN ('OPEN'
, 'PRIOR'
, 'NET'
, 'CLOSE'
, 'TARGET'
, 'SURPLUS') UNION ALL SELECT WSL.WORKSHEET_HEADER_ID
, DECODE(WSL.SOURCE_TYPE
, 'IDA'
, 'IDA'
, 'TRX') SOURCE_TYPE
, DECODE(WSL.SOURCE_TYPE
, 'IDA'
, LK2.MEANING
, LK.MEANING) SOURCE_DESCRIPTION
, WSL.DESCRIPTION SOURCE_DETAIL
, WSL.WORKSHEET_LINE_ID FROM CE_CP_WORKSHEET_LINES WSL
, CE_LOOKUPS LK
, CE_LOOKUPS LK2 WHERE WSL.SOURCE_TYPE IN ('APP'
, 'ARR'
, 'PAY'
, 'XTI'
, 'XTO'
, 'UDI'
, 'UDO'
, 'IDA'
, 'CEI'
, 'CEO') AND WSL.INCLUDE_FLAG = 'Y' AND LK.LOOKUP_TYPE = 'POSITION_SRC_TYPE' AND LK.LOOKUP_CODE = 'TRX' AND LK2.LOOKUP_TYPE = 'POSITION_SRC_TYPE' AND LK2.LOOKUP_CODE = 'IDA') SRC WHERE WBA.WORKSHEET_HEADER_ID = SRC.WORKSHEET_HEADER_ID) HEAD
, (SELECT OPEN.WORKSHEET_HEADER_ID
, OPEN.BANK_ACCOUNT_ID
, -1 WORKSHEET_LINE_ID
, OPEN.BALANCE
, 'OPEN' SOURCE_TYPE
, NULL SOURCE_DETAIL
, NULL DETAIL FROM CE_CP_DISC_OPEN_V OPEN UNION ALL SELECT PD.WORKSHEET_HEADER_ID
, PD.BANK_ACCOUNT_ID
, -1 WORKSHEET_LINE_ID
, PD.BALANCE
, 'PRIOR' SOURCE_TYPE
, NULL SOURCE_DETAIL
, NULL DETAIL FROM CE_CP_DISC_PRIOR_V PD UNION ALL SELECT TRX.WORKSHEET_HEADER_ID
, TRX.BANK_ACCOUNT_ID
, TRX.WORKSHEET_LINE_ID
, TRX.BALANCE
, DECODE(TRX.TRX_TYPE
, 'IDA'
, 'IDA'
, 'TRX') SOURCE_TYPE
, TRX.TRX_DESCRIPTION SOURCE_DETAIL
, TRX.DETAIL FROM CE_CP_DISC_TRX_V TRX UNION ALL SELECT NET.WORKSHEET_HEADER_ID
, NET.BANK_ACCOUNT_ID
, -1 WORKSHEET_LINE_ID
, NET.BALANCE
, 'NET' SOURCE_TYPE
, NULL SOURCE_DETAIL
, NULL DETAIL FROM CE_CP_DISC_NET_V NET UNION ALL SELECT CLOSE.WORKSHEET_HEADER_ID
, CLOSE.BANK_ACCOUNT_ID
, -1 WORKSHEET_LINE_ID
, CLOSE.BALANCE
, 'CLOSE' SOURCE_TYPE
, NULL SOURCE_DETAIL
, NULL DETAIL FROM CE_CP_DISC_CLOSE_V CLOSE UNION ALL SELECT WSH.WORKSHEET_HEADER_ID
, TARGET.BANK_ACCOUNT_ID
, -1 WORKSHEET_LINE_ID
, TARGET.TARGET_BALANCE
, 'TARGET' SOURCE_TYPE
, NULL SOURCE_DETAIL
, NULL DETAIL FROM CE_CP_WORKSHEET_HEADERS WSH
, CE_CP_DISC_TARGET_V TARGET UNION ALL SELECT SURPLUS.WORKSHEET_HEADER_ID
, SURPLUS.BANK_ACCOUNT_ID
, -1 WORKSHEET_LINE_ID
, SURPLUS.BALANCE
, 'SURPLUS' SOURCE_TYPE
, NULL SOURCE_DETAIL
, NULL DETAIL FROM CE_CP_DISC_SURPLUS_V SURPLUS) DATA WHERE HEAD.WORKSHEET_HEADER_ID = DATA.WORKSHEET_HEADER_ID(+) AND HEAD.BANK_ACCOUNT_ID = DATA.BANK_ACCOUNT_ID(+) AND HEAD.SOURCE_TYPE = DATA.SOURCE_TYPE(+) AND HEAD.WORKSHEET_LINE_ID = DATA.WORKSHEET_LINE_ID(+)

Columns