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 210: msc_single_lvl_peg mslp,

206: 0 quantity2,
207: decode(md.customer_id, null, md.source_org_instance_id, 0) sub_inst_id
208: FROM msc_demands md,
209: msc_supplies ms,
210: msc_single_lvl_peg mslp,
211: msc_form_query mfq
212: WHERE ms.organization_id = mfq.number2
213: AND ms.sr_instance_id = mfq.number3
214: AND ms.plan_id = mfq.number4

Line 942: msc_single_lvl_peg mslp,

938: 1,
939: mslp.parent_id
940: from msc_supplies ms,
941: msc_supplies parent,
942: msc_single_lvl_peg mslp,
943: msc_form_query mfq
944: where ms.organization_id = mfq.number2
945: AND ms.sr_instance_id = mfq.number3
946: and ms.plan_id = mfq.number4

Line 975: msc_single_lvl_peg mslp,

971: md.demand_id
972: from msc_supplies ms,
973: msc_supplies parent,
974: msc_demands md,
975: msc_single_lvl_peg mslp,
976: msc_form_query mfq
977: where ms.organization_id = mfq.number2
978: AND ms.sr_instance_id = mfq.number3
979: and ms.plan_id = mfq.number4

Line 1010: msc_single_lvl_peg mslp,

1006: 1,
1007: 1,
1008: mslp.parent_id
1009: from msc_supplies ms,
1010: msc_single_lvl_peg mslp,
1011: msc_demands md,
1012: msc_form_query mfq
1013: where ms.organization_id = mfq.number2
1014: AND ms.sr_instance_id = mfq.number3