View: PMITS_OPERATION_RESOURCES_V

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

View Text

SELECT ORS.RESOURCES
, RM.RESOURCE_DESC
, RM.RESOURCE_CLASS
, ORS.OPRN_LINE_ID
, ORS.PROCESS_UOM AS RSRC_UOM
, ORS.PROCESS_QTY
, OV.PROCESS_QTY_UM AS PROCESS_UOM
, ORS.RESOURCE_USAGE
, ORS.USAGE_UM
, ORS.RESOURCE_COUNT
, ORS.PRIM_RSRC_IND
, RSRC_LKP.MEANING
, ORS.SCALE_TYPE
, SCAL_LKP.MEANING
, ORS.COST_CMPNTCLS_ID
, CM.COST_CMPNTCLS_CODE
, CM.COST_CMPNTCLS_DESC
, ORS.COST_ANALYSIS_CODE
, AM.COST_ANALYSIS_DESC
, ORS.OFFSET_INTERVAL
, ORS.DELETE_MARK
, ORS.TEXT_CODE
, ORS.MIN_CAPACITY
, ORS.MAX_CAPACITY
, ORS.CAPACITY_UOM
, ORS.PROCESS_PARAMETER_1
, ORS.PROCESS_PARAMETER_2
, ORS.PROCESS_PARAMETER_3
, ORS.PROCESS_PARAMETER_4
, ORS.PROCESS_PARAMETER_5
FROM GMD_OPERATION_RESOURCES ORS
, GMD_OPERATION_ACTIVITIES OA
, GMD_OPERATIONS_VL OV
, CR_RSRC_MST RM
, CM_CMPT_MST CM
, CM_ALYS_MST AM
, GEM_LOOKUPS RSRC_LKP
, GEM_LOOKUPS SCAL_LKP
WHERE ORS.RESOURCES = RM.RESOURCES
AND ORS.OPRN_LINE_ID = OA.OPRN_LINE_ID
AND OA.OPRN_ID = OV.OPRN_ID
AND ORS.COST_CMPNTCLS_ID = CM. COST_CMPNTCLS_ID
AND ORS.COST_ANALYSIS_CODE = AM. COST_ANALYSIS_CODE
AND RSRC_LKP.LOOKUP_CODE = ORS.PRIM_RSRC_IND
AND RSRC_LKP.LOOKUP_TYPE = 'GMD_PRIM_RSRC_IND'
AND SCAL_LKP.LOOKUP_CODE = ORS.SCALE_TYPE
AND SCAL_LKP.LOOKUP_TYPE = 'GMD_RESOURCE_SCALE_TYPE'
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(OV.OWNER_ORGN_CODE)

Columns