View: GMF_MATERIAL_EFFECTIVITIES_VW1

Product:	GMF - Process Manufacturing Financials
Description:	This is a helper view for Item substitution for costing.
Implementation/DBA Data:	APPS.GMF_MATERIAL_EFFECTIVITIES_VW1

View Text

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
, RANK() OVER (PARTITION BY FORMULA_ID
, LINE_TYPE
, LINE_NO ORDER BY ORIGINAL_ITEM_FLAG
, PREFERENCE) RK
FROM GMD_MATERIAL_EFFECTIVITIES_VW
WHERE 1 = 1

Columns