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
Subobject Name:
Status: VALID


Layer Cost Details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_LAYER_COST_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAYER_ID
ColumnCOST_TYPE_ID
ColumnCOST_CMPNTCLS_ID
ColumnCOST_ANALYSIS_CODE
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.
COST_ANALYSIS_CODE VARCHAR2 (4) Yes Cost analysis code.
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.
Query Text

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


SELECT LAYER_ID
,      COST_MTHD_CODE
,      COST_LEVEL
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      CMPNT_COST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      POST_TO_SUBLEDGER
,      COST_TYPE_ID
,      PERIOD_ID
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:

SchemaAPPS
SynonymGMF_LAYER_COST_DETAILS