VIEW: APPS.CE_CP_OPEN_BAL_V

Source

View Text - Preformatted

SELECT BAL.bank_account_id, CBA.currency_code, BAL.balance_date, lag(BAL.balance_date, 1, sysdate+10000) over (PARTITION BY BAL.bank_account_id ORDER BY BAL.balance_date desc), BAL.ledger_balance, BAL.available_balance, BAL.value_dated_balance, BAL.one_day_float, BAL.two_day_float FROM CE_BANK_ACCT_BALANCES BAL, CE_BANK_ACCTS_GT_V CBA WHERE BAL.bank_account_id = CBA.bank_account_id UNION SELECT BAL.bank_account_id, CBA.currency_code, BAL.balance_date, lag(BAL.balance_date, 1, sysdate+10000) over (PARTITION BY BAL.bank_account_id ORDER BY BAL.balance_date desc), BAL.ledger_balance, BAL.available_balance, BAL.value_dated_balance, BAL.one_day_float, BAL.two_day_float FROM CE_BANK_ACCT_BALANCES BAL, CE_BANK_ACCOUNTS CBA WHERE BAL.bank_account_id = CBA.bank_account_id and CBA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY'

View Text - HTML Formatted

SELECT BAL.BANK_ACCOUNT_ID
, CBA.CURRENCY_CODE
, BAL.BALANCE_DATE
, LAG(BAL.BALANCE_DATE
, 1
, SYSDATE+10000) OVER (PARTITION BY BAL.BANK_ACCOUNT_ID ORDER BY BAL.BALANCE_DATE DESC)
, BAL.LEDGER_BALANCE
, BAL.AVAILABLE_BALANCE
, BAL.VALUE_DATED_BALANCE
, BAL.ONE_DAY_FLOAT
, BAL.TWO_DAY_FLOAT
FROM CE_BANK_ACCT_BALANCES BAL
, CE_BANK_ACCTS_GT_V CBA
WHERE BAL.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID UNION SELECT BAL.BANK_ACCOUNT_ID
, CBA.CURRENCY_CODE
, BAL.BALANCE_DATE
, LAG(BAL.BALANCE_DATE
, 1
, SYSDATE+10000) OVER (PARTITION BY BAL.BANK_ACCOUNT_ID ORDER BY BAL.BALANCE_DATE DESC)
, BAL.LEDGER_BALANCE
, BAL.AVAILABLE_BALANCE
, BAL.VALUE_DATED_BALANCE
, BAL.ONE_DAY_FLOAT
, BAL.TWO_DAY_FLOAT
FROM CE_BANK_ACCT_BALANCES BAL
, CE_BANK_ACCOUNTS CBA
WHERE BAL.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
AND CBA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY'