View: PMITS_OPERATION_MASTER_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	GMD Operation Master View
Implementation/DBA Data:	APPS.PMITS_OPERATION_MASTER_V

View Text

SELECT OPV.OPRN_ID
, OPV.OPRN_NO
, OPV.OPRN_VERS
, OPV.PROCESS_QTY_UM
, OPV.OPRN_CLASS
, OPV.POC_CTL_CLASS
, OPV.INACTIVE_IND
, OPV.DELETE_MARK
, OPV.TEXT_CODE
, OPV.EFFECTIVE_START_DATE
, OPV.EFFECTIVE_END_DATE
, OPV.OPERATION_STATUS
, OPV.OWNER_ORGN_CODE
, OPV.OPRN_DESC
, OGM.ORGN_NAME
, OC.OPRN_CLASS_DESC
, GS.MEANING AS STATUS
FROM GMD_OPERATIONS_VL OPV
, SY_UOMS_MST UM
, SY_ORGN_MST OGM
, FM_OPRN_CLS OC
, GMD_STATUS GS
WHERE OPV.OWNER_ORGN_CODE = OGM.ORGN_CODE
AND OPV.PROCESS_QTY_UM = UM.UM_CODE
AND OPV.OPRN_CLASS = OC.OPRN_CLASS(+)
AND OPV.OPERATION_STATUS = GS.STATUS_CODE
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(OGM.ORGN_CODE)

Columns