View: PMITS_ROUTING_DETAIL_V

Product:	PMI - Process Manufacturing Intelligence
Description:	GMD Routing Detail View
Implementation/DBA Data:	APPS.PMITS_ROUTING_DETAIL_V

View Text

SELECT RD.ROUTING_ID
, RD.ROUTINGSTEP_ID
, RD.ROUTINGSTEP_NO
, RD.OPRN_ID
, RD.STEP_QTY
, LKP.MEANING AS STEPRELEASE_TYPE
, RD.TEXT_CODE
FROM FM_ROUT_DTL RD
, GEM_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE = 'STEPRELEASE_TYPE'
AND LKP.LOOKUP_CODE = RD.STEPRELEASE_TYPE

Columns