[Home] [Help]
View: FM_ROUT_MTL_VW1
Product: | GMD - Process Manufacturing Product Development |
Description: | Backward compatibility view so existing GME code can continue looking at the FM_ROUT_MTL table rather than at GMD_RECIPE_STEP_MATERIALS. |
Implementation/DBA Data: |
APPS.FM_ROUT_MTL_VW1
|
View Text
SELECT FRD.ROUTING_ID
, GRSM.FORMULALINE_ID
, FMD.FORMULA_ID
, FRD.ROUTINGSTEP_NO
, GRSM.TEXT_CODE
, GRSM.LAST_UPDATED_BY
, GRSM.CREATED_BY
, GRSM.LAST_UPDATE_DATE
, GRSM.CREATION_DATE
, GRSM.LAST_UPDATE_LOGIN
, GRSM.RECIPE_ID
FROM GMD_RECIPE_STEP_MATERIALS GRSM
, FM_ROUT_DTL FRD
, FM_MATL_DTL FMD
WHERE GRSM.ROUTINGSTEP_ID=FRD.ROUTINGSTEP_ID
AND GRSM.FORMULALINE_ID=FMD.FORMULALINE_ID
Columns
Name |
ROUTING_ID |
FORMULALINE_ID |
FORMULA_ID |
ROUTINGSTEP_NO |
TEXT_CODE |
LAST_UPDATED_BY |
CREATED_BY |
LAST_UPDATE_DATE |
CREATION_DATE |
LAST_UPDATE_LOGIN |
RECIPE_ID |