View: CRP_24HR_AVAILABLE_HOURS

Product:	CRP - Capacity
Description:	View of daily available capacity of 24 hour resources
Implementation/DBA Data:	APPS.CRP_24HR_AVAILABLE_HOURS

View Text

SELECT DEPT_RES.DEPARTMENT_ID
, DEPTS.DEPARTMENT_CODE
, DEPTS.DESCRIPTION
, DEPT_RES.RESOURCE_ID
, RES.RESOURCE_CODE
, RES.DESCRIPTION
, RES.ORGANIZATION_ID
, PARAM.ORGANIZATION_CODE
, CAL.CALENDAR_DATE
, SUM(OWNER_RES.CAPACITY_UNITS * 24)
FROM MTL_PARAMETERS PARAM
, BOM_DEPARTMENTS DEPTS
, BOM_RESOURCES RES
, BOM_DEPARTMENT_RESOURCES DEPT_RES
, BOM_DEPARTMENT_RESOURCES OWNER_RES
, BOM_CALENDAR_DATES CAL
WHERE CAL.SEQ_NUM IS NOT NULL
AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND OWNER_RES.AVAILABLE_24_HOURS_FLAG = 1
AND OWNER_RES.DEPARTMENT_ID = NVL(DEPT_RES.SHARE_FROM_DEPT_ID
, DEPTS.DEPARTMENT_ID)
AND OWNER_RES.RESOURCE_ID = RES.RESOURCE_ID
AND DEPT_RES.AVAILABLE_24_HOURS_FLAG = 1
AND DEPT_RES.DEPARTMENT_ID = DEPTS.DEPARTMENT_ID
AND DEPT_RES.RESOURCE_ID = RES.RESOURCE_ID
AND DEPTS.ORGANIZATION_ID = PARAM.ORGANIZATION_ID
AND RES.ORGANIZATION_ID = PARAM.ORGANIZATION_ID GROUP BY DEPT_RES.DEPARTMENT_ID
, DEPTS.DEPARTMENT_CODE
, DEPTS.DESCRIPTION
, DEPT_RES.RESOURCE_ID
, RES.RESOURCE_CODE
, RES.DESCRIPTION
, RES.ORGANIZATION_ID
, PARAM.ORGANIZATION_CODE
, CAL.CALENDAR_DATE

Columns