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_OUTGOING_MATERIAL_LAYERS

Object Details

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

Layer data for the batch yield transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMF_OUTGOING_MATERIAL_LAYR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LAYER_ID
GMF_OUTGOING_MATERIAL_LAYR_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	MMT_TRANSACTION_ID LOT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_ID	NUMBER		Yes	Surrogate uniquely identifying the outgoing 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
REMAINING_IB_DOC_QTY	NUMBER		Yes	Indicates how much of the transaction quantity is remaining and can be used in VIB consumption while creating a VIB row for a product layer. This quantity is stored in the document UOM (material line UOM)
DELETE_MARK	NUMBER	(5)	Yes	If the outgoing layers are completely reversed out and never used in the VIB details, they are mark for delete to avoid use in future VIB details.
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
MMT_TRANSACTION_ID	NUMBER			Trans_id of the ingredient or by-product transaction for which this layer is created.
MMT_ORGANIZATION_ID	NUMBER			Inventory organization identifier
LOT_NUMBER	VARCHAR2	(80)		Lot from which ingredient or by-product is consumed.

Query Text

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


SELECT LAYER_ID
,      TRANS_ID
,      LAYER_DOC_QTY
,      LAYER_DOC_UM
,      REMAINING_IB_DOC_QTY
,      DELETE_MARK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MMT_TRANSACTION_ID
,      MMT_ORGANIZATION_ID
,      LOT_NUMBER
FROM GMF.GMF_OUTGOING_MATERIAL_LAYERS;

Dependencies

[top of page]

GMF.GMF_OUTGOING_MATERIAL_LAYERS does not reference any database object

GMF.GMF_OUTGOING_MATERIAL_LAYERS is referenced by following:

APPS: GMF_OUTGOING_MATERIAL_LAYERS