[Home] [Help]
View: CE_CP_OPEN_BAL_V
Product: | CE - Cash Management |
Description: | This view shows the opening balances for bank accounts |
Implementation/DBA Data: |
APPS.CE_CP_OPEN_BAL_V
|
View Text
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
, NVL(BAL.AVAILABLE_BALANCE
, BAL.LEDGER_BALANCE)
, NVL(BAL.VALUE_DATED_BALANCE
, BAL.LEDGER_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'
Columns
Name |
BANK_ACCOUNT_ID |
CURRENCY_CODE |
STATEMENT_DATE |
NEXT_STMT_DATE |
LEDGER_BALANCE |
CASHFLOW_BALANCE |
INT_CALC_BALANCE |
ONE_DAY_FLOAT |
TWO_DAY_FLOAT |