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_INCOMING_MATERIAL_LAYERS

Object Details

Object Name:	GMF_INCOMING_MATERIAL_LAYERS
Object Type:	TABLE
Owner:	GMF
Subobject Name:
Status:	VALID

Layer data for consumption transactions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMF_INCOMING_MATERIAL_LAYR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LAYER_ID
GMF_INCOMING_MATERIAL_LAYR_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAYER_DATE
GMF_INCOMING_MATERIAL_LAYR_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MMT_TRANSACTION_ID LOT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_ID	NUMBER		Yes	Surrogate uniquely identifying the incoming layer.
TRANS_ID	NUMBER			Obsolete. Replaced with mmt_transaction_id and lot_number columns.
LAYER_DOC_QTY	NUMBER		Yes	Layer quantity in document UOM.
LAYER_DOC_UM	VARCHAR2	(4)	Yes	Document UOM
LAYER_DATE	DATE			Since the pseudo (or adjustment layers) do not point to an inventory transactions, this indicates the transaction date for the layer. For regular product yields this indicates yield date.
PSEUDO_LAYER_ID	NUMBER			pseudo layer identifying for the incoming layer for ingradient consumption after last product yield.
FINAL_COST_IND	NUMBER	(5)	Yes	Indicates if the cost for this layer has been frozen.
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
GL_POSTED_IND	NUMBER			Obsolete. Replaced with Accounted_flag and actual_posting_date columns.
MMT_TRANSACTION_ID	NUMBER			Trans_id of the product yield transactions for which this layer is created. If the mmt_transaction_id is NULL, then this is a pseudo (or adjustment) layer created to correct under or over consumption by a product.
MMT_ORGANIZATION_ID	NUMBER			organization_id of the product yield transactions for which this layer is created.
LOT_NUMBER	VARCHAR2	(80)		Lot into which product is yielded.
ACCOUNTED_FLAG	VARCHAR2	(1)		Accounted Flag. N - Not Accounted, D - Draft Accounted and NULL - Final Accounted. When final accounted, actual_posting_date will have posting date.
ACTUAL_POSTING_DATE	DATE			Date on which this transaction is final accounted.

Query Text

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


SELECT LAYER_ID
,      TRANS_ID
,      LAYER_DOC_QTY
,      LAYER_DOC_UM
,      LAYER_DATE
,      PSEUDO_LAYER_ID
,      FINAL_COST_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GL_POSTED_IND
,      MMT_TRANSACTION_ID
,      MMT_ORGANIZATION_ID
,      LOT_NUMBER
,      ACCOUNTED_FLAG
,      ACTUAL_POSTING_DATE
FROM GMF.GMF_INCOMING_MATERIAL_LAYERS;

Dependencies

[top of page]

GMF.GMF_INCOMING_MATERIAL_LAYERS does not reference any database object

GMF.GMF_INCOMING_MATERIAL_LAYERS is referenced by following:

APPS: GMF_INCOMING_MATERIAL_LAYERS