View: GMD_MATERIAL_EFFECTIVITIES_VW

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.GMD_MATERIAL_EFFECTIVITIES_VW

View Text

SELECT FORMULALINE_ID
, FORMULA_ID
, LINE_TYPE
, LINE_NO
, INVENTORY_ITEM_ID
, QTY
, DETAIL_UOM
, RELEASE_TYPE
, SCRAP_FACTOR
, SCALE_TYPE
, COST_ALLOC
, PHANTOM_TYPE
, REWORK_TYPE
, TEXT_CODE
, CONTRIBUTE_STEP_QTY_IND
, CONTRIBUTE_YIELD_IND
, SCALE_MULTIPLE
, SCALE_ROUNDING_VARIANCE
, ROUNDING_DIRECTION
, BY_PRODUCT_TYPE
, BUFFER_IND
, NULL START_DATE
, INGREDIENT_END_DATE END_DATE
, 1 ORIGINAL_ITEM_FLAG
, NULL PREFERENCE
, NULL SUB_ORIGINAL_QTY
, NULL SUB_REPLACE_QTY
, NULL REPLACEMENT_UOM
, NULL LINE_ITEM_ID
, NULL LINE_ITEM_UOM
, NULL LINE_ITEM_PRIMARY_UOM
, NULL LINE_ITEM_QTY
, NULL SUBSTITUTION_ITEM_UOM
, ORGANIZATION_ID
FROM FM_MATL_DTL
WHERE 1 = 1 UNION ALL SELECT D.FORMULALINE_ID
, D.FORMULA_ID
, D.LINE_TYPE
, D.LINE_NO
, S.INVENTORY_ITEM_ID ITEM_ID
, NULL QTY
, S.DETAIL_UOM ITEM_UM
, D.RELEASE_TYPE
, D.SCRAP_FACTOR
, D.SCALE_TYPE
, D.COST_ALLOC
, D.PHANTOM_TYPE
, D.REWORK_TYPE
, D.TEXT_CODE
, D.CONTRIBUTE_STEP_QTY_IND
, D.CONTRIBUTE_YIELD_IND
, D.SCALE_MULTIPLE
, D.SCALE_ROUNDING_VARIANCE
, D.ROUNDING_DIRECTION
, D.BY_PRODUCT_TYPE
, D.BUFFER_IND
, H.START_DATE START_DATE
, H.END_DATE END_DATE
, 0 ORIGINAL_ITEM_FLAG
, H.PREFERENCE
, H.ORIGINAL_QTY SUB_ORIGINAL_QTY
, S.UNIT_QTY SUB_REPLACE_QTY
, DECODE(H.REPLACEMENT_UOM_TYPE
, 1
, D.DETAIL_UOM
, S.DETAIL_UOM) REPLACEMENT_UOM
, H.ORIGINAL_INVENTORY_ITEM_ID LINE_ITEM_ID
, D.DETAIL_UOM LINE_ITEM_UOM
, H.ORIGINAL_UOM LINE_ITEM_PRIMARY_UOM
, D.QTY LINE_ITEM_QTY
, S.DETAIL_UOM SUBSTITUTION_ITEM_UOM
, ORGANIZATION_ID
FROM FM_MATL_DTL D
, GMD_ITEM_SUBSTITUTION_HDR_B H
, GMD_ITEM_SUBSTITUTION_DTL S
, GMD_FORMULA_SUBSTITUTION F
WHERE D.FORMULA_ID = F.FORMULA_ID
AND D.LINE_TYPE = - 1
AND D.INGREDIENT_END_DATE IS NOT NULL
AND F.ASSOCIATED_FLAG = 'Y'
AND (H.SUBSTITUTION_STATUS >= 700
AND H.SUBSTITUTION_STATUS < 799)
AND F.SUBSTITUTION_ID = H.SUBSTITUTION_ID
AND S.SUBSTITUTION_ID = H.SUBSTITUTION_ID
AND H.ORIGINAL_INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID

Columns