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


VIEW: APPS.GME_MATERIAL_DETAILS_V

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

View Type

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


A supplementary view based on table gme_material_details.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

To identify the organization (Plant or Lab)
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.
INVENTORY_ITEM_ID NUMBER

Identified to Item
LINE_NO NUMBER (5) Yes Sequential line number for each line type in a batch or FPO
LINE_TYPE NUMBER (5) Yes -1 = Ingredient1 = Product; The product on Line 1 is the primary product.2 = Byproduct
LINE_TYPE_MEANING VARCHAR2 (80) Yes meaning resolved using lookup table for line_type
PLAN_QTY NUMBER
Yes The quantity that this line was planned to produce or consume, in the batch UOM (item_um column).
WIP_PLAN_QTY NUMBER

This quantity is used in place of PLAN_QTY, if the batch status is WIP or above.
ACTUAL_QTY NUMBER
Yes Sum (trans_qty) of completed transactions for line, in the batch UOM.
SUBINVENTORY VARCHAR2 (10)
Yield/Supply Subinventory
LOCATOR_ID NUMBER

Identifier to Yield,/Supply locator
REVISION VARCHAR2 (3)
Item Revision
BACKORDERED_QTY NUMBER

Qty used by view/api for cross docking
MATERIAL_REQUIREMENT_DATE DATE

Requirement/Yield Date of the material
MATERIAL_REQUIREMENT_DATE_DT VARCHAR2 (4000)
Requirement/Yield Date of the material in user display format
DTL_UM VARCHAR2 (3)
Detail UOM for the quantities
ITEM_NO VARCHAR2 (40)
Item Number
ITEM_DESC VARCHAR2 (240)
Item Description
PHANTOM_ID NUMBER (10)
For phantoms. FK of the phantom batch which produces the ingredient
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
ROUNDING_DIRECTION NUMBER (5)
Whether to round up to round down to the nearest SCALE_MULTIPLE0 = UP 1 = DOWN 3 = EITHER
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.
PHANTOM_LINE_ID NUMBER

Identifier to the Phantom Ingredient Line/Phantom Product Line
LOCATOR CHAR (1)
Locator resolved using Locator ID
PHANTOM_BATCH_NO VARCHAR2 (32)
Phantom Batch Number
TEXT_CODE NUMBER (10)
Text Code
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
RELEASE_TYPE_MEANING VARCHAR2 (80) Yes Release Type resolved using lookup type
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.
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_YIELD_IND_MEANING VARCHAR2 (80)
resolved to its meanin using lookup
CONTRIBUTE_STEP_QTY_MEANING VARCHAR2 (80)
resolved to its meanin using lookup
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
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
BY_PRODUCT_TYPE_MEANING VARCHAR2 (80)
resolved to its meanin using lookup
DISPENSE_IND_MEANING VARCHAR2 (80)
resolved to its meanin using lookup
DISPENSE_IND VARCHAR2 (1)
If material has to be dispensed
Query Text

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


SELECT ORGANIZATION_ID
,      MATERIAL_DETAIL_ID
,      BATCH_ID
,      FORMULALINE_ID
,      INVENTORY_ITEM_ID
,      LINE_NO
,      LINE_TYPE
,      LINE_TYPE_MEANING
,      PLAN_QTY
,      WIP_PLAN_QTY
,      ACTUAL_QTY
,      SUBINVENTORY
,      LOCATOR_ID
,      REVISION
,      BACKORDERED_QTY
,      MATERIAL_REQUIREMENT_DATE
,      MATERIAL_REQUIREMENT_DATE_DT
,      DTL_UM
,      ITEM_NO
,      ITEM_DESC
,      PHANTOM_ID
,      SCRAP_FACTOR
,      SCALE_TYPE
,      ROUNDING_DIRECTION
,      SCALE_ROUNDING_VARIANCE
,      SCALE_MULTIPLE
,      PHANTOM_LINE_ID
,      LOCATOR
,      PHANTOM_BATCH_NO
,      TEXT_CODE
,      RELEASE_TYPE
,      RELEASE_TYPE_MEANING
,      PHANTOM_TYPE
,      COST_ALLOC
,      CONTRIBUTE_YIELD_IND
,      CONTRIBUTE_YIELD_IND_MEANING
,      CONTRIBUTE_STEP_QTY_MEANING
,      CONTRIBUTE_STEP_QTY_IND
,      ORIGINAL_QTY
,      BY_PRODUCT_TYPE
,      BY_PRODUCT_TYPE_MEANING
,      DISPENSE_IND_MEANING
,      DISPENSE_IND
FROM APPS.GME_MATERIAL_DETAILS_V;

Dependencies

[top of page]

APPS.GME_MATERIAL_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageFND_TIMEZONES - show dependent code
ViewGEM_LOOKUPS
SynonymGME_BATCH_HEADER
SynonymGME_MATERIAL_DETAILS
ViewMTL_ITEM_LOCATIONS_KFV
ViewMTL_SYSTEM_ITEMS_VL

APPS.GME_MATERIAL_DETAILS_V is not referenced by any database object