VIEW: APPS.GMD_ERES_MATERIALS_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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