Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | Availability and planned usage of Process Manufacturing resources |
Implementation/DBA Data: | APPS.PMIBV_RESOURCE_PLAN_V |
SELECT RMASTER.RESOURCES
, /*REGULAR ATTRIBUTES */ RMASTER.RESOURCE_DESC
, RMASTER.STD_USAGE_UM
, RMASTER.RESOURCE_CLASS
, RMASTER.COST_CMPNTCLS_ID
, /*ID */ 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
, OPDETAIL.BATCHSTEP_ID
, OPACTV.OPRN_LINE_ID
, OPDETAIL.COST_ANALYSIS_CODE
, OPDETAIL.COST_CMPNTCLS_ID
, 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
WHERE RMASTER.RESOURCES = RDETAIL.RESOURCES(+)
AND RMASTER.RESOURCES = OPDETAIL.RESOURCES(+)
AND OPDETAIL.BATCHSTEP_ACTIVITY_ID = OPACTV.BATCHSTEP_ACTIVITY_ID(+)
AND OPACTV.BATCHSTEP_ID = BTCHSTEP.BATCHSTEP_ID(+) WITH READ ONLY