[Home] [Help]
View: PMITS_ROUTING_DETAIL_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
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
Name |
ROUTING_ID |
ROUTINGSTEP_ID |
ROUTINGSTEP_NO |
OPRN_ID |
STEP_QTY |
STEPRELEASE_TYPE |
TEXT_CODE |