VIEW: APPS.PMIFV_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 */ 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

View Text - HTML Formatted

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