eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CRP_24HR_AVAILABLE_HOURS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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