VIEW: APPS.CE_CP_DISC_OPEN_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')