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_ALLOCATION_PLAN dependencies on MSC_SINGLE_LVL_PEG

Line 206: msc_single_lvl_peg mslp,

202: SUM(mslp.quantity) quantity,
203: 0 quantity2
204: FROM msc_demands md,
205: msc_supplies ms,
206: msc_single_lvl_peg mslp,
207: msc_form_query mfq
208: WHERE ms.organization_id = mfq.number2
209: AND ms.sr_instance_id = mfq.number3
210: AND ms.plan_id = mfq.number4

Line 927: msc_single_lvl_peg mslp,

923: 1,
924: mslp.parent_id
925: from msc_supplies ms,
926: msc_supplies parent,
927: msc_single_lvl_peg mslp,
928: msc_form_query mfq
929: where ms.organization_id = mfq.number2
930: AND ms.sr_instance_id = mfq.number3
931: and ms.plan_id = mfq.number4

Line 960: msc_single_lvl_peg mslp,

956: md.demand_id
957: from msc_supplies ms,
958: msc_supplies parent,
959: msc_demands md,
960: msc_single_lvl_peg mslp,
961: msc_form_query mfq
962: where ms.organization_id = mfq.number2
963: AND ms.sr_instance_id = mfq.number3
964: and ms.plan_id = mfq.number4

Line 995: msc_single_lvl_peg mslp,

991: 1,
992: 1,
993: mslp.parent_id
994: from msc_supplies ms,
995: msc_single_lvl_peg mslp,
996: msc_demands md,
997: msc_form_query mfq
998: where ms.organization_id = mfq.number2
999: AND ms.sr_instance_id = mfq.number3