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: GMF.GMF_LAYER_COST_DETAILS

Object Details

Object Name:	GMF_LAYER_COST_DETAILS
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GMF_LAYER_COST_DETAILS
Subobject Name:
Status:	VALID

Layer Cost Details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMF_LAYER_COST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAYER_ID COST_TYPE_ID COST_CMPNTCLS_ID COST_ANALYSIS_CODE#1

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_ID	NUMBER		Yes	Layer_id of the product referring to layer in gmf_incoming_material_layers.
COST_MTHD_CODE	VARCHAR2	(4)		Obsolete. Replaced with cost_type_id column.
COST_LEVEL	NUMBER			Cost source. 0=Cost Directly associate to the product, 1= Costs via Ingredients.
COST_CMPNTCLS_ID	NUMBER		Yes	Cost component class.
CMPNT_COST	NUMBER			Component cost.
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
POST_TO_SUBLEDGER	NUMBER			Indicates whether this product layer should be posted to subledger or not. 1 = Post to Subledger, 0 = Do not post to subledger.
COST_TYPE_ID	NUMBER			Cost type of the batch cost.
PERIOD_ID	NUMBER			Cost Period.
COST_ANALYSIS_CODE#1	VARCHAR2	(32)	Yes	COST ANALYSIS CODE #1

Query Text

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


SELECT LAYER_ID
,      COST_MTHD_CODE
,      COST_LEVEL
,      COST_CMPNTCLS_ID
,      CMPNT_COST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      POST_TO_SUBLEDGER
,      COST_TYPE_ID
,      PERIOD_ID
,      COST_ANALYSIS_CODE#1
FROM GMF.GMF_LAYER_COST_DETAILS;

Dependencies

[top of page]

GMF.GMF_LAYER_COST_DETAILS does not reference any database object

GMF.GMF_LAYER_COST_DETAILS is referenced by following:

GMF: GMF_LAYER_COST_DETAILS#