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 718: msc_system_items i

714: FROM msc_resource_requirements crp,
715: msc_department_resources cpr,
716: msc_form_query list,
717: msc_supplies s,
718: msc_system_items i
719: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
720: AND cpr.resource_id = list.number3
721: AND cpr.plan_id = g_designator
722: AND cpr.organization_id = list.number1

Line 1077: msc_system_items i

1073: FROM msc_resource_requirements crp,
1074: msc_department_resources cpr,
1075: msc_form_query list,
1076: msc_supplies s,
1077: msc_system_items i
1078: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
1079: AND cpr.resource_id = list.number3
1080: AND cpr.plan_id = g_designator
1081: AND cpr.organization_id = list.number1

Line 1490: FROM msc_system_items cst

1486: v_bucket_size NUMBER;
1487: v_res_cost NUMBER := 0;
1488: cursor res_cost is
1489: SELECT NVL(cst.standard_cost, 0)
1490: FROM msc_system_items cst
1491: WHERE cst.inventory_item_id = activity_rec.assembly_item_id
1492: AND cst.organization_id = activity_rec.org_id
1493: AND cst.sr_instance_id = activity_rec.instance_id
1494: AND cst.plan_id = -1;