DBA Data[Home] [Help] [Dependency Information]

TABLE: GMF.GMF_RESOURCE_LAYERS

Object Details
Object Name: GMF_RESOURCE_LAYERS
Object Type: TABLE
Owner: GMF
Subobject Name:
Status: VALID


Consumption Resource Layers


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_RESOURCE_LAYERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAYER_ID
GMF_RESOURCE_LAYERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOC_TRANS_ID
Columns
Name Datatype Length Mandatory Comments
LAYER_ID NUMBER
Yes Surrogate uniquely identifying the resource layer.
POC_TRANS_ID NUMBER
Yes Trans_id of the resource transaction for which this layer is created.
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 in document UOM.
DELETE_MARK NUMBER (5) Yes If the resource 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
Query Text

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


SELECT LAYER_ID
,      POC_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
FROM GMF.GMF_RESOURCE_LAYERS;

Dependencies

[top of page]

GMF.GMF_RESOURCE_LAYERS does not reference any database object

GMF.GMF_RESOURCE_LAYERS is referenced by following:

SchemaAPPS
SynonymGMF_RESOURCE_LAYERS