eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_GL_CCID_DIMENSIONS

Object Details

Object Name:	FII_GL_CCID_DIMENSIONS
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_GL_CCID_DIMENSIONS
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.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_GL_CCID_DIMENSIONS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	CODE_COMBINATION_ID
FII_GL_CCID_DIMENSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COMPANY_ID COST_CENTER_ID NATURAL_ACCOUNT_ID CHART_OF_ACCOUNTS_ID USER_DIM1_ID USER_DIM2_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Key flexfield combination defining column
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		Company cost center organization ID
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CATEGORY_ID	NUMBER	(15)		Product category identifier
COMPANY_ID	NUMBER	(15)		Company Identifier
COST_CENTER_ID	NUMBER	(15)		Cost Center Identifier
NATURAL_ACCOUNT_ID	NUMBER	(15)		Natural Account Identifier
PRODUCT_ID	NUMBER	(15)		Product Identifier
PROD_CATEGORY_ID	NUMBER	(15)		Product Category identifier
USER_DIM1_ID	NUMBER	(15)		User Dimension 1 Identifier
USER_DIM2_ID	NUMBER	(15)		User Defined Dimension 2 Identifier

Query Text

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


SELECT CODE_COMBINATION_ID
,      CHART_OF_ACCOUNTS_ID
,      COMPANY_COST_CENTER_ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      NATURAL_ACCOUNT_ID
,      PRODUCT_ID
,      PROD_CATEGORY_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
FROM FII.FII_GL_CCID_DIMENSIONS;