VIEW: APPS.PMIBV_RESOURCE_PLAN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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