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.

APPS.AHL_AMP_WORKBENCH_PVT dependencies on AHL_DEPT_RESOURCE_CAPACITY

Line 57: select count(distinct drc.AVAILABLE_DATE) no_of_working_date from AHL_DEPT_RESOURCE_CAPACITY drc where drc.available_date between TRUNC(c_start_date) and TRUNC(c_end_date) AND drc.organization_id = c_org_id AND drc.department_id = c_dept_id AND

53: -- cursor to get the working days in the interval
54: CURSOR c_number_of_working_days (c_org_id NUMBER,c_dept_id NUMBER,c_start_date DATE , c_end_date DATE)
55: IS
56: -- STHILAK CHANGES THE CURSOR DEFNITION
57: select count(distinct drc.AVAILABLE_DATE) no_of_working_date from AHL_DEPT_RESOURCE_CAPACITY drc where drc.available_date between TRUNC(c_start_date) and TRUNC(c_end_date) AND drc.organization_id = c_org_id AND drc.department_id = c_dept_id AND
58: drc.ASCP_PLAN_DATE = (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY ) order by drc.available_date;
59: BEGIN
60:
61: OPEN c_number_of_working_days(p_org_id,p_dept_id,p_start_dt,p_end_dt);

Line 58: drc.ASCP_PLAN_DATE = (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY ) order by drc.available_date;

54: CURSOR c_number_of_working_days (c_org_id NUMBER,c_dept_id NUMBER,c_start_date DATE , c_end_date DATE)
55: IS
56: -- STHILAK CHANGES THE CURSOR DEFNITION
57: select count(distinct drc.AVAILABLE_DATE) no_of_working_date from AHL_DEPT_RESOURCE_CAPACITY drc where drc.available_date between TRUNC(c_start_date) and TRUNC(c_end_date) AND drc.organization_id = c_org_id AND drc.department_id = c_dept_id AND
58: drc.ASCP_PLAN_DATE = (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY ) order by drc.available_date;
59: BEGIN
60:
61: OPEN c_number_of_working_days(p_org_id,p_dept_id,p_start_dt,p_end_dt);
62:

Line 304: (select distinct drc.AVAILABLE_DATE cal_date from AHL_DEPT_RESOURCE_CAPACITY drc where drc.available_date >=TRUNC(c_start_date)

300: -- cursor to get the working days in the interval
301: CURSOR c_working_dates(c_org_id NUMBER,c_dept_id NUMBER,c_start_date DATE , c_no_of_days NUMBER)
302: IS
303: select cal_date from
304: (select distinct drc.AVAILABLE_DATE cal_date from AHL_DEPT_RESOURCE_CAPACITY drc where drc.available_date >=TRUNC(c_start_date)
305: AND drc.organization_id = c_org_id AND drc.department_id = c_dept_id AND drc.ASCP_PLAN_DATE = (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY ) order by drc.available_date)
306: where ROWNUM < (c_no_of_days+1) ; /* Rule is :Rownum is executed first then follwed by order by , thats why made a sub query and put row num on top of that*/
307:
308:

Line 305: AND drc.organization_id = c_org_id AND drc.department_id = c_dept_id AND drc.ASCP_PLAN_DATE = (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY ) order by drc.available_date)

301: CURSOR c_working_dates(c_org_id NUMBER,c_dept_id NUMBER,c_start_date DATE , c_no_of_days NUMBER)
302: IS
303: select cal_date from
304: (select distinct drc.AVAILABLE_DATE cal_date from AHL_DEPT_RESOURCE_CAPACITY drc where drc.available_date >=TRUNC(c_start_date)
305: AND drc.organization_id = c_org_id AND drc.department_id = c_dept_id AND drc.ASCP_PLAN_DATE = (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY ) order by drc.available_date)
306: where ROWNUM < (c_no_of_days+1) ; /* Rule is :Rownum is executed first then follwed by order by , thats why made a sub query and put row num on top of that*/
307:
308:
309:

Line 333: FROM AHL_DEPT_RESOURCE_CAPACITY drc

329: CURSOR c_resource_avail(c_oranization_id NUMBER,c_department_id NUMBER,c_resource_id NUMBER,c_avail_dt DATE)
330: IS
331: SELECT DECODE(UOM_CODE,'DAY',CAPACITY_UNITS * 24,CAPACITY_UNITS) CAPACITY_UNITS ,
332: UOM_CODE
333: FROM AHL_DEPT_RESOURCE_CAPACITY drc
334: WHERE drc.ORGANIZATION_ID = c_oranization_id
335: AND drc.DEPARTMENT_ID =c_department_id
336: AND drc.RESOURCE_ID =c_resource_id
337: AND drc.AVAILABLE_DATE =TRUNC(c_avail_dt)

Line 339: (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY

335: AND drc.DEPARTMENT_ID =c_department_id
336: AND drc.RESOURCE_ID =c_resource_id
337: AND drc.AVAILABLE_DATE =TRUNC(c_avail_dt)
338: AND drc.ASCP_PLAN_DATE =
339: (SELECT MAX(ASCP_PLAN_DATE) FROM AHL_DEPT_RESOURCE_CAPACITY
340: );
341:
342: BEGIN
343: -- Enable Debug (optional)

Line 352: FROM AHL_DEPT_RESOURCE_CAPACITY;

348: -- ASCP last ran date
349: -- STHILAK ER #13799535 x_plan_date := TRUNC(sysdate);
350: SELECT MAX(ASCP_PLAN_DATE)
351: INTO x_plan_date
352: FROM AHL_DEPT_RESOURCE_CAPACITY;
353: IF G_DEBUG = 'Y' THEN
354: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : ASCP plan date = '|| x_plan_date );
355: END IF;
356: