DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CE_CP_OPEN_BAL_V

Object Details
Object Name: CE_CP_OPEN_BAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_CP_OPEN_BAL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_ACCOUNT_ID NUMBER (15)
Bank account identifier
CURRENCY_CODE VARCHAR2 (15)
Bank account currency
STATEMENT_DATE DATE

Bank statement date
NEXT_STMT_DATE DATE

Next bank statement date
LEDGER_BALANCE NUMBER

Bank statement ledger balance
CASHFLOW_BALANCE NUMBER

Bank statement cashflow balance
INT_CALC_BALANCE NUMBER

Bank statement interest calculated balance
ONE_DAY_FLOAT NUMBER

Bank statement one-day float balance
TWO_DAY_FLOAT NUMBER

Bank statement two-day float balance
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BANK_ACCOUNT_ID
,      CURRENCY_CODE
,      STATEMENT_DATE
,      NEXT_STMT_DATE
,      LEDGER_BALANCE
,      CASHFLOW_BALANCE
,      INT_CALC_BALANCE
,      ONE_DAY_FLOAT
,      TWO_DAY_FLOAT
FROM APPS.CE_CP_OPEN_BAL_V;

Dependencies

[top of page]

APPS.CE_CP_OPEN_BAL_V references the following:

SchemaAPPS
SynonymCE_BANK_ACCOUNTS
ViewCE_BANK_ACCTS_GT_V
SynonymCE_BANK_ACCT_BALANCES
APPS.CE_CP_OPEN_BAL_V is referenced by following:

SchemaAPPS
ViewCE_CP_DISC_OPEN_V
ViewCE_CP_DISC_OVERDUE_V
ViewCE_CP_DISC_PRIOR_V
Package BodyCE_CP_PRIORDAY - show dependent code
Package BodyCE_CSH_FCST_POP - show dependent code