View: CRP_AVAILABLE_HOURS

Product:	CRP - Capacity
Description:	View of gross available capacity of all resources
Implementation/DBA Data:	APPS.CRP_AVAILABLE_HOURS

View Text

SELECT DEPARTMENT_ID
, DEPT_CODE
, DEPT_DESCRIPTION
, RESOURCE_ID
, RES_CODE
, RES_DESCRIPTION
, ORGANIZATION_ID
, ORGANIZATION_CODE
, AVAILABLE_DATE
, AVAILABLE_HOURS
FROM CRP_OTHER_AVAILABLE_HOURS UNION ALL SELECT DEPARTMENT_ID
, DEPT_CODE
, DEPT_DESCRIPTION
, RESOURCE_ID
, RES_CODE
, RES_DESCRIPTION
, ORGANIZATION_ID
, ORGANIZATION_CODE
, AVAILABLE_DATE
, AVAILABLE_HOURS
FROM CRP_24HR_AVAILABLE_HOURS

Columns