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

TABLE: CE.CE_CE_CASHPOOL_SUB_ACCTS

Object Details
Object Name: CE_CE_CASHPOOL_SUB_ACCTS
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_CE_CASHPOOL_SUB_ACCTS
Subobject Name:
Status: VALID


This table is a backup of the ce_cashpool_sub_accts table before the bank_account_id foreign key upgrade.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CASHPOOL_SUB_ACCT_ID NUMBER (15) Yes Uniquely identifies the cashpool
CONC_ACCOUNT_ID NUMBER (15)
Concentration bank account identifier
INV_CONC_ACCOUNT_ID NUMBER (15)
Investment concentration bank account identifier
FUND_CONC_ACCOUNT_ID NUMBER (15)
Funding concentration bank account identifier
ACCOUNT_ID NUMBER (15)
Bank account identifier or child cash pool identifier
TYPE VARCHAR2 (10)
Type of sub account (ACCT: Bank Account, POOL: Cash Pool, CONC: Normal concentration account, INV: Investment concentration account, FUND: Funding concentration account, NEST: Bank Account from a nested cash pool)
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object version number
Query Text

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


SELECT CASHPOOL_SUB_ACCT_ID
,      CONC_ACCOUNT_ID
,      INV_CONC_ACCOUNT_ID
,      FUND_CONC_ACCOUNT_ID
,      ACCOUNT_ID
,      TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM CE.CE_CE_CASHPOOL_SUB_ACCTS;

Dependencies

[top of page]

CE.CE_CE_CASHPOOL_SUB_ACCTS does not reference any database object

CE.CE_CE_CASHPOOL_SUB_ACCTS is referenced by following:

SchemaAPPS
SynonymCE_CE_CASHPOOL_SUB_ACCTS