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: GME.GME_MATERIAL_DETAILS

Object Details

Object Name:	GME_MATERIAL_DETAILS
Object Type:	TABLE
Owner:	GME
FND Design Data:	GME.GME_MATERIAL_DETAILS
Subobject Name:
Status:	VALID

New quantity columns; for scaling a WIP batch. Actual quantities must match on the PM & POC sides. If a WIP batch is scaled the actual quantity is not updated on the PM side; therefore the value needs to be tracked elsewhere.
Batch or FPO material details. This table contains data on the products, ingredients, and by products of an FPO or batch, including the planned and actual quantity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GME_MATERIAL_DETAILS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MATERIAL_DETAIL_ID
GME_MATERIAL_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID LINE_NO LINE_TYPE
GME_MATERIAL_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID LINE_TYPE BATCH_ID
GME_MATERIAL_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHANTOM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MATERIAL_DETAIL_ID	NUMBER	(10)	Yes	Unique identifier for a batch or FPO line.
BATCH_ID	NUMBER	(10)	Yes	Batch Identifier FK to the GME_BATCH_HEADER table
FORMULALINE_ID	NUMBER	(10)		FK to the formula line on which the batch line was based, if any.
LINE_NO	NUMBER	(5)	Yes	Sequential line number for each line type in a batch or FPO
ITEM_ID	NUMBER	(10)		Obsolete in R12. New column is inventory_item_id
LINE_TYPE	NUMBER	(5)	Yes	-1 = Ingredient1 = Product; The product on Line 1 is the primary product.2 = Byproduct
PLAN_QTY	NUMBER		Yes	The quantity that this line was planned to produce or consume, in the batch UOM (item_um column).
ITEM_UM	VARCHAR2	(4)		Obsolete in R12. New column is dtl_um
ITEM_UM2	VARCHAR2	(4)		Secondary UOM of item.
ACTUAL_QTY	NUMBER		Yes	Sum (trans_qty) of completed transactions for line, in the batch UOM.
RELEASE_TYPE	NUMBER	(5)	Yes	Consumption (or yeild) type. Profile option determines the default value, the profile defaults to Automatic.0 = Automatic (completion)1 = Manual (completion)2 = Incremental 3 = Automatic by Step
SCRAP_FACTOR	NUMBER		Yes	Scrap factor decimal used to a trans_qty that allows for scrap
SCALE_TYPE	NUMBER	(5)	Yes	0 = Non-scalable 1 = Scalable.2 = Scale by increment
PHANTOM_TYPE	NUMBER	(5)	Yes	Phantom indicator. 0 = not a phantom, 1 = automatic phantom replacement, 2 = manual phantom.
COST_ALLOC	NUMBER			For products, fraction of cost allocated to this product.
ALLOC_IND	NUMBER	(5)		This column is not used anymore.
COST	NUMBER			Not currently used.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
PHANTOM_ID	NUMBER	(10)		For phantoms. FK of the phantom batch which produces the ingredient.
ROUNDING_DIRECTION	NUMBER	(5)		Whether to round up to round down to the nearest SCALE_MULTIPLE0 = UP 1 = DOWN 3 = EITHER
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield Category
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
SCALE_ROUNDING_VARIANCE	NUMBER			Percentage + / - of the variance of scaled quantity allowed when scaling; default is zero.
SCALE_MULTIPLE	NUMBER			The multiples of the batch uom ( scale_uom ) for scaling.
CONTRIBUTE_YIELD_IND	VARCHAR2	(1)		Indicator to specify if the item ( product or ingredient ) contributes to yield. If item is defined as a packaging item, then the item cannot contribute to yield, therefore, the value is N, for No.Y = The item contributes to yield, Default.N = No, the item does not contributes to yield.
CONTRIBUTE_STEP_QTY_IND	VARCHAR2	(1)		Indicator to specify if the item contributes to step quantity. If item is defined as a packaging item, then the item cannot contribute to the step quantity, therefore, the value is N, for No.Y = The item contributes to step quantity, Default value.N = No, the item does not contributes to step quantity.
WIP_PLAN_QTY	NUMBER			This quantity is used in place of PLAN_QTY, if the batch status is WIP or above.
ORIGINAL_QTY	NUMBER			The recipe quantity scaled for the batch. Planned quantity prior to any changes, value cannot be updated.
BY_PRODUCT_TYPE	VARCHAR2	(1)		This column is used to show whether the by-product is a sample type or other types.
BACKORDERED_QTY	NUMBER			Qty used by view/api for cross docking
DISPENSE_IND	VARCHAR2	(1)		If material has to be dispensed
DTL_UM	VARCHAR2	(3)		Detail UOM for the quantities (old column = ITEM_UM)
INVENTORY_ITEM_ID	NUMBER			Identified to Item
LOCATOR_ID	NUMBER			Identifier to Yield,/Supply locator
MATERIAL_REQUIREMENT_DATE	DATE			Requirement/Yield Date of the material
MOVE_ORDER_LINE_ID	NUMBER			Identifier to the move order line of Invisible move order.
ORGANIZATION_ID	NUMBER			To identify the organization (Plant or Lab)
ORIGINAL_PRIMARY_QTY	NUMBER			ORIGINAL_QTY in Item's primary UOM
PHANTOM_LINE_ID	NUMBER			Identifier to the Phantom Ingredient Line/Phantom Product Line
REVISION	VARCHAR2	(3)		Item Revision
SUBINVENTORY	VARCHAR2	(10)		Yield/Supply Subinventory

Query Text

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


SELECT MATERIAL_DETAIL_ID
,      BATCH_ID
,      FORMULALINE_ID
,      LINE_NO
,      ITEM_ID
,      LINE_TYPE
,      PLAN_QTY
,      ITEM_UM
,      ITEM_UM2
,      ACTUAL_QTY
,      RELEASE_TYPE
,      SCRAP_FACTOR
,      SCALE_TYPE
,      PHANTOM_TYPE
,      COST_ALLOC
,      ALLOC_IND
,      COST
,      TEXT_CODE
,      PHANTOM_ID
,      ROUNDING_DIRECTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      LAST_UPDATE_LOGIN
,      SCALE_ROUNDING_VARIANCE
,      SCALE_MULTIPLE
,      CONTRIBUTE_YIELD_IND
,      CONTRIBUTE_STEP_QTY_IND
,      WIP_PLAN_QTY
,      ORIGINAL_QTY
,      BY_PRODUCT_TYPE
,      BACKORDERED_QTY
,      DISPENSE_IND
,      DTL_UM
,      INVENTORY_ITEM_ID
,      LOCATOR_ID
,      MATERIAL_REQUIREMENT_DATE
,      MOVE_ORDER_LINE_ID
,      ORGANIZATION_ID
,      ORIGINAL_PRIMARY_QTY
,      PHANTOM_LINE_ID
,      REVISION
,      SUBINVENTORY
FROM GME.GME_MATERIAL_DETAILS;

Dependencies

[top of page]

GME.GME_MATERIAL_DETAILS does not reference any database object

GME.GME_MATERIAL_DETAILS is referenced by following:

APPS: GME_MATERIAL_DETAILS; JAI_OPM_GMD_ARIUD_T1