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 880: msc_plans mp

876: lv_plan_id
877: FROM msc_supplies s,
878: msc_plan_organizations_v orgs,
879: msc_system_items msi,
880: msc_plans mp
881: WHERE mp.plan_id = arg_plan_id
882: AND s.release_errors is NULL
883: AND nvl(s.cfm_routing_flag,0) = 3
884: AND s.implement_quantity > 0

Line 1769: FROM msc_plans mp,

1765: INTO lv_transaction_id,
1766: lv_instance_id,
1767: lv_org_id,
1768: lv_plan_id
1769: FROM msc_plans mp,
1770: msc_supplies s,
1771: msc_plan_organizations_v orgs
1772: WHERE mp.plan_id = arg_plan_id
1773: AND s.release_errors is NULL

Line 2677: msc_plans mp

2673: lv_round_primary_item
2674: FROM msc_supplies s,
2675: msc_plan_organizations_v orgs,
2676: msc_system_items msi, -- REMOVE
2677: msc_plans mp
2678: WHERE mp.plan_id = arg_plan_id
2679: AND s.release_errors is NULL
2680: AND s.implement_quantity > 0
2681: AND s.organization_id = orgs.planned_organization

Line 3780: msc_plans mp

3776: lv_org_id,
3777: lv_plan_id
3778: FROM msc_supplies s,
3779: msc_plan_organizations_v orgs,
3780: msc_plans mp
3781: WHERE s.release_errors is NULL
3782: AND s.implement_quantity > 0
3783: AND s.organization_id = orgs.planned_organization
3784: AND s.sr_instance_id = orgs.sr_instance_id