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_CRP_HORIZONTAL_PLAN dependencies on MSC_SYSTEM_ITEMS

Line 571: msc_system_items i

567: FROM msc_resource_requirements crp,
568: msc_department_resources cpr,
569: msc_form_query list,
570: msc_supplies s,
571: msc_system_items i
572: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
573: AND cpr.resource_id = list.number3
574: AND cpr.plan_id = g_designator
575: AND cpr.organization_id = list.number1

Line 902: msc_system_items i

898: FROM msc_resource_requirements crp,
899: msc_department_resources cpr,
900: msc_form_query list,
901: msc_supplies s,
902: msc_system_items i
903: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
904: AND cpr.resource_id = list.number3
905: AND cpr.plan_id = g_designator
906: AND cpr.organization_id = list.number1

Line 1315: FROM msc_system_items cst

1311: v_bucket_size NUMBER;
1312: v_res_cost NUMBER := 0;
1313: cursor res_cost is
1314: SELECT NVL(cst.standard_cost, 0)
1315: FROM msc_system_items cst
1316: WHERE cst.inventory_item_id = activity_rec.assembly_item_id
1317: AND cst.organization_id = activity_rec.org_id
1318: AND cst.sr_instance_id = activity_rec.instance_id
1319: AND cst.plan_id = -1;