VIEW: APPS.GMF_MATERIAL_EFFECTIVITIES_VW1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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