VIEW: APPS.CE_CP_DISC_CLOSE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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