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_DEMANDS

Line 136: FROM msc_demands md,

132: SUM(DECODE(md.origination_type, 29,nvl(md.probability,1),1) *
133: nvl(old_using_requirement_quantity,
134: using_requirement_quantity)) quantity,
135: sum(md.unmet_quantity) quantity2
136: FROM msc_demands md,
137: msc_form_query mfq
138: WHERE md.plan_id = mfq.number4
139: AND md.inventory_item_id = mfq.number1
140: AND md.organization_id = mfq.number2

Line 204: FROM msc_demands md,

200: arg_group_by)) sequence,
201: ms.new_schedule_date new_date,
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

Line 959: msc_demands md,

955: 1,
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

Line 996: msc_demands md,

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
1000: and ms.plan_id = mfq.number4