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.MSC_AATP_FUNC dependencies on MSC_RESOURCE_HIERARCHY_MV

Line 458: FROM msc_resource_hierarchy_mv

454: END IF;
455:
456: SELECT allocation_percent/100
457: INTO l_alloc_percent
458: FROM msc_resource_hierarchy_mv
459: WHERE demand_class = p_demand_class
460: AND department_id = p_dept_id
461: AND resource_id = p_res_id
462: AND organization_id = p_org_id

Line 479: FROM msc_resource_hierarchy_mv

475: END IF;
476: BEGIN
477: SELECT allocation_percent/100
478: INTO l_alloc_percent
479: FROM msc_resource_hierarchy_mv
480: WHERE demand_class = p_demand_class
481: AND department_id = p_dept_id
482: AND resource_id = p_res_id
483: AND organization_id = p_org_id

Line 491: FROM msc_resource_hierarchy_mv

487: EXCEPTION
488: WHEN NO_DATA_FOUND THEN
489: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
490: INTO l_alloc_percent
491: FROM msc_resource_hierarchy_mv
492: WHERE department_id = p_dept_id
493: AND resource_id = p_res_id
494: AND organization_id = p_org_id
495: AND sr_instance_id = p_instance_id

Line 507: FROM msc_resource_hierarchy_mv

503: END IF;
504:
505: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
506: INTO l_alloc_percent
507: FROM msc_resource_hierarchy_mv
508: WHERE department_id = p_dept_id
509: AND resource_id = p_res_id
510: AND organization_id = p_org_id
511: AND sr_instance_id = p_instance_id

Line 523: FROM msc_resource_hierarchy_mv

519: msc_sch_wb.atp_debug('Get the Allocation on Request Date:2');
520: END IF;
521: SELECT allocation_percent/100
522: INTO l_alloc_percent
523: FROM msc_resource_hierarchy_mv
524: WHERE demand_class = p_demand_class
525: AND department_id = p_dept_id
526: AND resource_id = p_res_id
527: AND organization_id = p_org_id

Line 542: FROM msc_resource_hierarchy_mv

538:
539: BEGIN
540: SELECT allocation_percent/100
541: INTO l_alloc_percent
542: FROM msc_resource_hierarchy_mv
543: WHERE demand_class = p_demand_class
544: AND department_id = p_dept_id
545: AND resource_id = p_res_id
546: AND organization_id = p_org_id

Line 554: FROM msc_resource_hierarchy_mv

550: EXCEPTION
551: WHEN NO_DATA_FOUND THEN
552: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
553: INTO l_alloc_percent
554: FROM msc_resource_hierarchy_mv
555: WHERE department_id = p_dept_id
556: AND resource_id = p_res_id
557: AND organization_id = p_org_id
558: AND sr_instance_id = p_instance_id

Line 566: FROM msc_resource_hierarchy_mv

562: END;
563: ELSE
564: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
565: INTO l_alloc_percent
566: FROM msc_resource_hierarchy_mv
567: WHERE department_id = p_dept_id
568: AND resource_id = p_res_id
569: AND organization_id = p_org_id
570: AND sr_instance_id = p_instance_id

Line 1276: FROM msc_resource_hierarchy_mv

1272: IF G_HIERARCHY_PROFILE = 1 THEN
1273:
1274: SELECT (allocation_percent- NVL(min_allocation_percent, 0))/100
1275: INTO l_alloc_percent
1276: FROM msc_resource_hierarchy_mv
1277: WHERE demand_class = p_demand_class
1278: AND department_id = p_dept_id
1279: AND resource_id = p_res_id
1280: AND organization_id = p_org_id

Line 1289: FROM msc_resource_hierarchy_mv

1285: ELSE
1286:
1287: SELECT (allocation_percent- NVL(min_allocation_percent, 0))/100
1288: INTO l_alloc_percent
1289: FROM msc_resource_hierarchy_mv
1290: WHERE demand_class = p_demand_class
1291: AND department_id = p_dept_id
1292: AND resource_id = p_res_id
1293: AND organization_id = p_org_id

Line 1308: FROM msc_resource_hierarchy_mv

1304: IF G_HIERARCHY_PROFILE = 1 THEN
1305:
1306: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
1307: INTO l_alloc_percent
1308: FROM msc_resource_hierarchy_mv
1309: WHERE department_id = p_dept_id
1310: AND resource_id = p_res_id
1311: AND organization_id = p_org_id
1312: AND sr_instance_id = p_instance_id

Line 1320: FROM msc_resource_hierarchy_mv

1316: ELSE
1317:
1318: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
1319: INTO l_alloc_percent
1320: FROM msc_resource_hierarchy_mv
1321: WHERE department_id = p_dept_id
1322: AND resource_id = p_res_id
1323: AND organization_id = p_org_id
1324: AND sr_instance_id = p_instance_id

Line 1405: FROM msc_resource_hierarchy_mv

1401: BEGIN
1402: --diag_atp
1403: SELECT distinct time_phase_id, allocation_rule_name
1404: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
1405: FROM msc_resource_hierarchy_mv
1406: WHERE resource_id = p_resource_id
1407: AND department_id = p_department_id
1408: AND organization_id = p_organization_id
1409: AND sr_instance_id = p_instance_id

Line 1476: FROM msc_resource_hierarchy_mv

1472: BEGIN
1473:
1474: SELECT distinct time_phase_id, allocation_rule_name
1475: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
1476: FROM msc_resource_hierarchy_mv
1477: WHERE resource_id = p_resource_id
1478: AND department_id = p_department_id
1479: AND organization_id = p_organization_id
1480: AND sr_instance_id = p_instance_id