Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | GMD Routing Master View |
Implementation/DBA Data: | APPS.PMITS_ROUTING_MASTER_V |
SELECT RV.ROUTING_ID
, RV.ROUTING_NO
, RV.ROUTING_VERS
, RV.ROUTING_CLASS
, RV.ROUTING_QTY
, RV.ROUTING_STATUS
, RV.ROUTING_DESC
, RV.ITEM_UM
, RV.DELETE_MARK
, RV.TEXT_CODE
, LKP.MEANING AS INACTIVE_IND
, RV.EFFECTIVE_START_DATE
, RV.EFFECTIVE_END_DATE
, RV.OWNER_ID
, RV.PROJECT_ID
, RV.PROCESS_LOSS
, FU.USER_NAME AS OWNER
, FU.DESCRIPTION
, RV.OWNER_ORGN_CODE
, RC.ROUTING_CLASS_DESC
, GS.MEANING AS STATUS
FROM GMD_ROUTINGS_VL RV
, FND_USER FU
, FM_ROUT_CLS RC
, SY_ORGN_MST OM
, GMD_STATUS GS
, GEM_LOOKUPS LKP
WHERE RV.OWNER_ID = FU.USER_ID
AND RV.OWNER_ORGN_CODE = OM.ORGN_CODE
AND RV.ROUTING_CLASS = RC.ROUTING_CLASS(+)
AND RV.ROUTING_STATUS = GS.STATUS_CODE
AND LKP.LOOKUP_TYPE = 'GME_YES_NO'
AND LKP.LOOKUP_CODE = RV.INACTIVE_IND
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(RV.OWNER_ORGN_CODE)