View: MRP_AP_DEPARTMENT_RESOURCES_V

View Text

SELECT X.RESOURCE_ID
, X.DEPARTMENT_ID
, X.LINE_FLAG
, X.OWNING_DEPARTMENT_ID
, X.CAPACITY_UNITS
, X.RESOURCE_GROUP_NAME
, X.AVAILABLE_24_HOURS_FLAG
, X.CTP_FLAG
, X.UTILIZATION
, X.EFFICIENCY
, X.ORGANIZATION_ID
, X.DEPARTMENT_CODE
, X.DEPARTMENT_CLASS
, X.DEPARTMENT_DESCRIPTION
, X.RESOURCE_CODE
, X.RESOURCE_DESCRIPTION
, X.RESOURCE_TYPE
, X.DISABLE_DATE
, MPES.USER_TIME_FENCE
, MPES.OVER_UTILIZED_PERCENT
, MPES.UNDER_UTILIZED_PERCENT
, MPES.RESOURCE_SHORTAGE_TYPE
, MPES.RESOURCE_EXCESS_TYPE
, NVL(MPES.RN
, 0) RN6
, X.RN5 RN5
, X.RN4 RN4
, X.RN3 RN3
, X.RN2 RN2
, X.RN1 RN1
FROM MRP_AP_PL_EX_SETS_SN MPES
, (SELECT BDR.RESOURCE_ID
, BDR.DEPARTMENT_ID
, 2 LINE_FLAG
, ODR.DEPARTMENT_ID OWNING_DEPARTMENT_ID
, ODR.CAPACITY_UNITS
, ODR.RESOURCE_GROUP_NAME
, ODR.EXCEPTION_SET_NAME
, ODR.AVAILABLE_24_HOURS_FLAG
, ODR.CTP_FLAG
, ODR.UTILIZATION
, ODR.EFFICIENCY
, BD.ORGANIZATION_ID
, BD.DEPARTMENT_CODE
, BD.DEPARTMENT_CLASS_CODE DEPARTMENT_CLASS
, BD.DESCRIPTION DEPARTMENT_DESCRIPTION
, BR.RESOURCE_CODE
, BR.DESCRIPTION RESOURCE_DESCRIPTION
, BR.RESOURCE_TYPE
, BR.DISABLE_DATE
, BR.RN RN5
, BD.RN RN4
, ODR.RN RN3
, BDR.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_RESS_SN BR
, MRP_AP_DEPTS_SN BD
, MRP_AP_DEPT_RESS_SN ODR
, MRP_AP_DEPT_RESS_SN BDR
WHERE BD.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND BD.DEPARTMENT_ID= BDR.DEPARTMENT_ID
AND ODR.DEPARTMENT_ID= NVL(BDR.SHARE_FROM_DEPT_ID
, BDR.DEPARTMENT_ID)
AND ODR.RESOURCE_ID= BDR.RESOURCE_ID
AND BR.RESOURCE_ID= BDR.RESOURCE_ID) X
WHERE MPES.EXCEPTION_SET_NAME(+)= X.EXCEPTION_SET_NAME
AND MPES.ORGANIZATION_ID(+)= X.ORGANIZATION_ID

Columns