Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | Availability and planned usage of Process Manufacturing resources |
Implementation/DBA Data: | APPS.PMIFV_RESOURCE_PLAN_V |
SELECT RMASTER.RESOURCES
, /*REGULAR ATTRIBUTES */ RMASTER.RESOURCE_DESC
, RMASTER.STD_USAGE_UM
, RMASTER.RESOURCE_CLASS
, RMASTER.COST_CMPNTCLS_ID
, /*ID */ RESCOMPCLASS.COST_CMPNTCLS_CODE
, RESCOMPCLASS.COST_CMPNTCLS_DESC
, RDETAIL.ORGN_CODE
, RDETAIL.GROUP_RESOURCE
, /* RESOLVED FOREIGN KEYS */ RDETAIL.ASSIGNED_QTY
, RDETAIL.DAILY_AVAIL_USE
, RDETAIL.USAGE_UM
, RDETAIL.NOMINAL_COST
, RDETAIL.INACTIVE_IND
, RDETAIL.IDEAL_CAPACITY
, RDETAIL.MIN_CAPACITY
, RDETAIL.MAX_CAPACITY
, RDETAIL.CAPACITY_UOM
, OPDETAIL.BATCH_ID
, BTCHSTEP.BATCHSTEP_NO
, OPACTV.ACTIVITY
, FMACTVMST.ACTIVITY_DESC
, OPDETAIL.BATCHSTEP_ID
, OPACTV.OPRN_LINE_ID
, OPDETAIL.COST_ANALYSIS_CODE
, OPDETAIL.COST_CMPNTCLS_ID
, OPCOMPCLASS.COST_CMPNTCLS_CODE
, OPCOMPCLASS.COST_CMPNTCLS_DESC
, OPDETAIL.PRIM_RSRC_IND
, OPDETAIL.SCALE_TYPE
, OPDETAIL.PLAN_RSRC_COUNT
, OPDETAIL.ACTUAL_RSRC_COUNT
, OPDETAIL.PLAN_RSRC_QTY
, OPDETAIL.ACTUAL_RSRC_QTY
, OPDETAIL.PLAN_RSRC_USAGE
, OPDETAIL.ACTUAL_RSRC_USAGE
, OPDETAIL.USAGE_UOM
, NULL
, OPDETAIL.OFFSET_INTERVAL
, OPDETAIL.PLAN_START_DATE
, OPDETAIL.ACTUAL_START_DATE
, OPDETAIL.PLAN_CMPLT_DATE
, OPDETAIL.ACTUAL_CMPLT_DATE
, RMASTER.CREATED_BY
, /*WHO COLUMNS */ RMASTER.CREATION_DATE
, RMASTER.LAST_UPDATE_DATE
, RMASTER.LAST_UPDATED_BY
FROM CR_RSRC_MST RMASTER
, CR_RSRC_DTL RDETAIL
, GME_BATCH_STEP_RESOURCES OPDETAIL
, GME_BATCH_STEP_ACTIVITIES OPACTV
, GME_BATCH_STEPS BTCHSTEP
, CM_CMPT_MST RESCOMPCLASS
, CM_CMPT_MST OPCOMPCLASS
, FM_ACTV_MST FMACTVMST
WHERE RMASTER.RESOURCES = RDETAIL.RESOURCES(+)
AND RMASTER.RESOURCES = OPDETAIL.RESOURCES(+)
AND RMASTER.COST_CMPNTCLS_ID = RESCOMPCLASS.COST_CMPNTCLS_ID
AND OPDETAIL.COST_CMPNTCLS_ID = OPCOMPCLASS.COST_CMPNTCLS_ID(+)
AND OPACTV.ACTIVITY = FMACTVMST.ACTIVITY(+)
AND OPACTV.BATCHSTEP_ACTIVITY_ID = OPDETAIL.BATCHSTEP_ACTIVITY_ID
AND OPACTV.BATCHSTEP_ID = BTCHSTEP.BATCHSTEP_ID
AND (TO_CHAR(OPDETAIL.ACTUAL_CMPLT_DATE
, 'DD-MON-YYYY') = GMA_CORE_PKG.GET_DATE_CONSTANT('SY$ZERODATE') OR OPDETAIL.PLAN_CMPLT_DATE >= SYSDATE OR OPDETAIL.ACTUAL_CMPLT_DATE >= SYSDATE)
AND (RDETAIL.ORGN_CODE IS NULL OR RDETAIL.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY