View: CE_CP_DISC_OPEN_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View for Opening Balances
Implementation/DBA Data:	APPS.CE_CP_DISC_OPEN_V

View Text

SELECT WBA.WORKSHEET_HEADER_ID
, WBA.BANK_ACCOUNT_ID
, DECODE(WBA.BALANCE_TYPE
, 'I'
, NVL(OPEN.INT_CALC_BALANCE
, 0)
, 'C'
, NVL(OPEN.CASHFLOW_BALANCE
, 0)
, NVL(OPEN.LEDGER_BALANCE
, 0)) + DECODE(WBA.FLOAT_TYPE
, 'ADD1'
, NVL(OPEN.ONE_DAY_FLOAT
, 0)
, 'ADD2'
, NVL(OPEN.TWO_DAY_FLOAT
, 0)
, 'SUB1'
, NVL(-OPEN.TWO_DAY_FLOAT
, 0)
, 'SUB2'
, NVL(-OPEN.TWO_DAY_FLOAT
, 0)
, 0) FROM CE_CP_WS_BA_DISC_V WBA
, CE_CP_OPEN_BAL_V OPEN
WHERE WBA.BANK_ACCOUNT_ID = OPEN.BANK_ACCOUNT_ID(+) AND OPEN.STATEMENT_DATE(+) < TO_DATE(SYSDATE
, 'YYYY/MM/DD') AND OPEN.NEXT_STMT_DATE(+) >= TO_DATE(SYSDATE
, 'YYYY/MM/DD')

Columns