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

VIEW: APPS.GME_MATERIAL_DETAILS_V1

Object Details
Object Name: GME_MATERIAL_DETAILS_V1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGME.GME_MATERIAL_DETAILS_V1
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is created for the backward compatibility. 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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (10) Yes Batch Identifier FK to the GME_BATCH_HEADER table.
LINE_ID NUMBER (10) Yes Unique identifier for a batch or FPO line.
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)
FK to the item that is a product, ingredient, or byproduct.
LINE_TYPE NUMBER (5) Yes -1 = Ingredient 1 = 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).
PLAN_QTY2 VARCHAR2 (0)
Not used any more. Can be derived by doing conversion of PLAN_QTY from ITEM_UM to ITEM_UM2.
ITEM_UM VARCHAR2 (4)
UOM in which planned and actual qty is entered on the batch.
ITEM_UM2 VARCHAR2 (4)
Secondary UOM of item.
ACTUAL_QTY NUMBER
Yes Sum (trans_qty) of completed transactions for line, in the batch UOM.
ACTUAL_QTY2 VARCHAR2 (0)
Not used any more. Can be derived by doing conversion of ACTUAL_QTY from ITEM_UM to ITEM_UM2.
RELEASE_TYPE NUMBER (5) Yes Release (or certification) type. Profile option determines the default value, the profile defaults to Automatic. 0 = Automatic release (certification) 1 = Manual release (certification) 2 = Incremental release 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)
Allocation indicator. 0 = Not fully allocated, 1 = Fully allocated.
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.
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
IN_USE VARCHAR2 (0)
This is field is not used.
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT BATCH_ID
,      LINE_ID
,      FORMULALINE_ID
,      LINE_NO
,      ITEM_ID
,      LINE_TYPE
,      PLAN_QTY
,      PLAN_QTY2
,      ITEM_UM
,      ITEM_UM2
,      ACTUAL_QTY
,      ACTUAL_QTY2
,      RELEASE_TYPE
,      SCRAP_FACTOR
,      SCALE_TYPE
,      PHANTOM_TYPE
,      COST_ALLOC
,      ALLOC_IND
,      COST
,      TEXT_CODE
,      PHANTOM_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      IN_USE
,      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
FROM APPS.GME_MATERIAL_DETAILS_V1;

Dependencies

[top of page]

APPS.GME_MATERIAL_DETAILS_V1 references the following:

SchemaAPPS
SynonymGME_MATERIAL_DETAILS
APPS.GME_MATERIAL_DETAILS_V1 is referenced by following:

SchemaAPPS
SynonymPM_MATL_DTL