View: CE_CP_DISC_CLOSE_V

Product:	CE - Cash Management
Description:	No longer Used
Implementation/DBA Data:	APPS.CE_CP_DISC_CLOSE_V

View Text

SELECT OPEN.WORKSHEET_HEADER_ID
, OPEN.BANK_ACCOUNT_ID
, NVL(OPEN.BALANCE
, 0) + NVL(PD.BALANCE
, 0) + NVL(NET.BALANCE
, 0) FROM CE_CP_DISC_OPEN_V OPEN
, CE_CP_DISC_PRIOR_V PD
, CE_CP_DISC_NET_V NET
WHERE OPEN.WORKSHEET_HEADER_ID = PD.WORKSHEET_HEADER_ID(+) AND OPEN.BANK_ACCOUNT_ID = PD.BANK_ACCOUNT_ID(+) AND OPEN.WORKSHEET_HEADER_ID = NET.WORKSHEET_HEADER_ID(+) AND OPEN.BANK_ACCOUNT_ID = NET.BANK_ACCOUNT_ID(+)

Columns