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 138: FROM msc_demands md,

134: nvl(old_using_requirement_quantity,
135: using_requirement_quantity)) quantity,
136: sum(md.unmet_quantity) quantity2,
137: decode(md.customer_id, null, md.source_org_instance_id, 0) sub_inst_id
138: FROM msc_demands md,
139: msc_form_query mfq
140: WHERE md.plan_id = mfq.number4
141: AND md.inventory_item_id = mfq.number1
142: AND md.organization_id = mfq.number2

Line 208: FROM msc_demands md,

204: ms.new_schedule_date new_date,
205: SUM(mslp.quantity) quantity,
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

Line 974: msc_demands md,

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

Line 1011: msc_demands md,

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