[Home] [Help]
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
Name |
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 |