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: FEM.FEM_COST_OBJ_HIER_QTY

Object Details

Object Name:	FEM_COST_OBJ_HIER_QTY
Object Type:	TABLE
Owner:	FEM
FND Design Data:	FEM.FEM_COST_OBJ_HIER_QTY
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_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_COST_OBJ_HIER_QTY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_ID DATASET_CODE CAL_PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RELATIONSHIP_ID	NUMBER		Yes	Unique identifier for a parent-child relationship between Cost Objects
DATASET_CODE	NUMBER		Yes	Dataset for the consumption quantity
CAL_PERIOD_ID	NUMBER		Yes	Foreign key to the Calendar Period dimension
CHILD_QTY	NUMBER		Yes	Indicates thenecessary child quantities with respect to the parent quantity
PARENT_QTY	NUMBER		Yes	Indicates the parent quantity to use when calculating the consumption quantity
YIELD_PERCENTAGE	NUMBER		Yes	Yield percentage
CREATION_DATE	DATE		Yes	Identifies the date on which the row was created
CREATED_BY	NUMBER	(15)	Yes	Identifies the user that created the row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Identifies the user that last modified the row
LAST_UPDATE_DATE	DATE		Yes	Identifies the date on which the row was last modified
LAST_UPDATE_LOGIN	NUMBER	(15)		Identifies the login user that last modified the row
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number for stale data detection

Query Text

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


SELECT RELATIONSHIP_ID
,      DATASET_CODE
,      CAL_PERIOD_ID
,      CHILD_QTY
,      PARENT_QTY
,      YIELD_PERCENTAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM FEM.FEM_COST_OBJ_HIER_QTY;

Dependencies

[top of page]

FEM.FEM_COST_OBJ_HIER_QTY does not reference any database object

FEM.FEM_COST_OBJ_HIER_QTY is referenced by following:

APPS: FEM_COST_OBJ_HIER_QTY