[Home] [Help]
View: CE_CP_SUB_OPEN_BAL_V
Product: | CE - Cash Management |
Description: | Opening balances for Treasury subsidiary bank accounts |
Implementation/DBA Data: |
APPS.CE_CP_SUB_OPEN_BAL_V
|
View Text
SELECT BA.ACCOUNT_OWNER_ORG_ID
, BA.BANK_ACCOUNT_NUM
, BA.CURRENCY_CODE
, BB.BALANCE_DATE
, LAG(BB.BALANCE_DATE
, 1
, SYSDATE+10000) OVER (PARTITION BY BA.BANK_ACCOUNT_NUM ORDER BY BB.BALANCE_DATE DESC)
, NVL(BB.LEDGER_BALANCE
, 0)
, NVL(BB.AVAILABLE_BALANCE
, 0)
, NVL(BB.VALUE_DATED_BALANCE
, 0)
, NVL(BB.ONE_DAY_FLOAT
, 0)
, NVL(BB.TWO_DAY_FLOAT
, 0) FROM CE_BANK_ACCOUNTS BA
, CE_BANK_ACCT_BALANCES BB
WHERE BA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY'
AND BB.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
Columns
Name |
LEGAL_ENTITY_ID |
ACCOUNT_NUMBER |
CURRENCY_CODE |
STATEMENT_DATE |
NEXT_STMT_DATE |
LEDGER_BALANCE |
CASHFLOW_BALANCE |
INT_CALC_BALANCE |
ONE_DAY_FLOAT |
TWO_DAY_FLOAT |