[Home] [Help]
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
Name |
RECIPE_ID |
ROUTINGSTEP_ID |
FORMULALINE_ID |
ROUTINGSTEP_NO |
ITEM_NO |
DESCRIPTION |
QTY |
DETAIL_UOM |
LINE_TYPE |
LINE_NO |