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

VIEW: APPS.GMF_MATERIAL_EFFECTIVITIES_VW1

Object Details
Object Name: GMF_MATERIAL_EFFECTIVITIES_VW1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.GMF_MATERIAL_EFFECTIVITIES_VW1
Subobject Name:
Status: VALID

View Type

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


This is a helper view for Item substitution for costing.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORMULA_ID NUMBER (10)
Surrogate key for the formula;version.
FORMULALINE_ID NUMBER (10)
Surrogate key for the formula line.
LINE_TYPE NUMBER (5)
1=product; -1=ingredient; 2=byprod.
LINE_NO NUMBER (5)
List order on screen within a line_type.
ITEM_ID NUMBER (15)
Inventory item id
QTY NUMBER

Item qty produced or consumed.
ITEM_UM VARCHAR2 (3)
Inventory item uom
SCALE_TYPE NUMBER (5)
0=fixed, no scaling; 1=proportional scaling.
SCRAP_FACTOR NUMBER

Scrap factor decimal used to calculate required qty.
PHANTOM_TYPE NUMBER (5)
Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom.
COST_ALLOC NUMBER

If product, fractional cost absorption.
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.)
SCALE_MULTIPLE NUMBER

The multiples of the batch uom used for scaling in multiples. ( 0 = Scaling does not scale by multiples, > 0 = Scale by multiples, value must be a whole number, < 0 = Invalid value)
SCALE_ROUNDING_VARIANCE NUMBER

Percentage +/- of the variance of scale multiple allowed when scaling; default is zero.
ROUNDING_DIRECTION NUMBER (5)
Applied to ingredients for either rounding up or down the scaled quantity value
ORIGINAL_ITEM_FLAG NUMBER

Original Item Flag
LINE_ITEM_ID NUMBER

Formula Line item identifier
LINE_ITEM_UOM VARCHAR2 (3)
Formula Line Item UOM
LINE_ITEM_QTY NUMBER

Formula Line Item qty
LINE_ITEM_PRIMARY_UOM VARCHAR2 (3)
Formula Line Item primary qty
SUB_ORIGINAL_QTY NUMBER

Substitute Item original qty
SUB_REPLACE_QTY NUMBER

Substitute Item replacement qty
START_DATE DATE

Start Date of the substitution
END_DATE DATE

End Date of the substitution
RK NUMBER

Rank
Query Text

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


SELECT FORMULA_ID
,      FORMULALINE_ID
,      LINE_TYPE
,      LINE_NO
,      ITEM_ID
,      QTY
,      ITEM_UM
,      SCALE_TYPE
,      SCRAP_FACTOR
,      PHANTOM_TYPE
,      COST_ALLOC
,      CONTRIBUTE_YIELD_IND
,      SCALE_MULTIPLE
,      SCALE_ROUNDING_VARIANCE
,      ROUNDING_DIRECTION
,      ORIGINAL_ITEM_FLAG
,      LINE_ITEM_ID
,      LINE_ITEM_UOM
,      LINE_ITEM_QTY
,      LINE_ITEM_PRIMARY_UOM
,      SUB_ORIGINAL_QTY
,      SUB_REPLACE_QTY
,      START_DATE
,      END_DATE
,      RK
FROM APPS.GMF_MATERIAL_EFFECTIVITIES_VW1;

Dependencies

[top of page]

APPS.GMF_MATERIAL_EFFECTIVITIES_VW1 references the following:

SchemaAPPS
ViewGMD_MATERIAL_EFFECTIVITIES_VW

APPS.GMF_MATERIAL_EFFECTIVITIES_VW1 is not referenced by any database object