View: CE_CP_DISC_SURPLUS_V

Product:	CE - Cash Management
Description:	No Longer Used
Implementation/DBA Data:	APPS.CE_CP_DISC_SURPLUS_V

View Text

SELECT CLOSE.WORKSHEET_HEADER_ID
, CLOSE.BANK_ACCOUNT_ID
, NVL(CLOSE.BALANCE
, 0) - NVL(TARGET.TARGET_BALANCE
, 0) FROM CE_CP_DISC_CLOSE_V CLOSE
, CE_CP_DISC_TARGET_V TARGET
WHERE CLOSE.BANK_ACCOUNT_ID = TARGET.BANK_ACCOUNT_ID(+)

Columns