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(+)
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(+)
|
|
|