View: GMD_ERES_MATERIALS_VW

Product:	GMD - Process Manufacturing Product Development
Description:	View of recipe material association
Implementation/DBA Data:	APPS.GMD_ERES_MATERIALS_VW

View Text

SELECT B.RECIPE_ID
, B.ROUTINGSTEP_ID
, B.FORMULALINE_ID
, C.ROUTINGSTEP_NO
, D.CONCATENATED_SEGMENTS
, D.DESCRIPTION
, E.QTY
, E.DETAIL_UOM
, E.LINE_TYPE
, E.LINE_NO
FROM GMD_RECIPE_STEP_MATERIALS B
, FM_ROUT_DTL C
, MTL_SYSTEM_ITEMS_KFV D
, FM_MATL_DTL E
WHERE B.ROUTINGSTEP_ID = C.ROUTINGSTEP_ID
AND B.FORMULALINE_ID = E.FORMULALINE_ID
AND D.INVENTORY_ITEM_ID = E.INVENTORY_ITEM_ID
AND D.ORGANIZATION_ID = E.ORGANIZATION_ID

Columns