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_COM_CC_MAPPINGS

Object Details

Object Name:	FII_COM_CC_MAPPINGS
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_COM_CC_MAPPINGS
Subobject Name:
Status:	VALID

Contains associations between cost center manager and line of business dimension

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_COM_CC_MAPPINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPANY_COST_CENTER_ORG_ID
FII_COM_CC_MAPPINGS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPANY_ID COST_CENTER_ID
FII_COM_CC_MAPPINGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_CENTER_ID COMPANY_ID
FII_COM_CC_MAPPINGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_MANAGER_ID
FII_COM_CC_MAPPINGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_LOB_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		Company Cost Center Organization Identifier
COST_CENTER_ID	NUMBER	(15)	Yes	Cost Center Identifier
COMPANY_ID	NUMBER	(15)	Yes	Company Identifier
MANAGER_ID	NUMBER	(15)		Cost Center Manager Identifier
LOB_ID	NUMBER	(15)		Line Of Business Identifier
VALID_MGR_FLAG	VARCHAR2	(1)		Flag to indicate a valid manager (MANAGER_ID > 0)
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PARENT_MANAGER_ID	NUMBER	(15)		Parent Manager Identifier
PARENT_LOB_ID	NUMBER	(15)		Parent Line of Business Identifier

Query Text

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


SELECT COMPANY_COST_CENTER_ORG_ID
,      COST_CENTER_ID
,      COMPANY_ID
,      MANAGER_ID
,      LOB_ID
,      VALID_MGR_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PARENT_MANAGER_ID
,      PARENT_LOB_ID
FROM FII.FII_COM_CC_MAPPINGS;

Dependencies

[top of page]

FII.FII_COM_CC_MAPPINGS does not reference any database object

FII.FII_COM_CC_MAPPINGS is referenced by following:

APPS: ENI_DBI_GL_BASE_MV; FII_AR_REV_SUM_MV; FII_COM_CC_MAPPINGS; FII_GL_BASE_MV