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_REL_PS_PLAN_PUB dependencies on MSC_PLANS

Line 906: msc_plans mp

902: lv_plan_id
903: FROM msc_supplies s,
904: msc_plan_organizations_v orgs,
905: msc_system_items msi,
906: msc_plans mp
907: WHERE mp.plan_id = arg_plan_id
908: AND s.release_errors is NULL
909: AND nvl(s.cfm_routing_flag,0) = 3
910: AND s.implement_quantity > 0

Line 1796: FROM msc_plans mp,

1792: INTO lv_transaction_id,
1793: lv_instance_id,
1794: lv_org_id,
1795: lv_plan_id
1796: FROM msc_plans mp,
1797: msc_supplies s,
1798: msc_plan_organizations_v orgs
1799: WHERE mp.plan_id = arg_plan_id
1800: AND s.release_errors is NULL

Line 2704: msc_plans mp

2700: lv_round_primary_item
2701: FROM msc_supplies s,
2702: msc_plan_organizations_v orgs,
2703: msc_system_items msi, -- REMOVE
2704: msc_plans mp
2705: WHERE mp.plan_id = arg_plan_id
2706: AND s.release_errors is NULL
2707: AND s.implement_quantity > 0
2708: AND s.organization_id = orgs.planned_organization

Line 3807: msc_plans mp

3803: lv_org_id,
3804: lv_plan_id
3805: FROM msc_supplies s,
3806: msc_plan_organizations_v orgs,
3807: msc_plans mp
3808: WHERE s.release_errors is NULL
3809: AND s.implement_quantity > 0
3810: AND s.organization_id = orgs.planned_organization
3811: AND s.sr_instance_id = orgs.sr_instance_id