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_SUPPLIES

Line 102: FROM msc_supplies ms,

98: nvl(ms.firm_date,ms.new_schedule_date) new_date,
99: sum(nvl(ms.firm_quantity,ms.new_order_quantity)) quantity,
100: 0 quantity2,
101: 0 sub_inst_id
102: FROM msc_supplies ms,
103: msc_form_query mfq
104: WHERE ms.plan_id = mfq.number4
105: AND ms.inventory_item_id = mfq.number1
106: AND ms.organization_id = mfq.number2

Line 209: msc_supplies ms,

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
213: AND ms.sr_instance_id = mfq.number3

Line 268: FROM msc_supplies ms,

264: nvl(ms.firm_ship_date,ms.new_ship_date) new_date,
265: sum(nvl(ms.firm_quantity,ms.new_order_quantity)) quantity,
266: 0 quantity2,
267: ms.sr_instance_id sub_inst_id
268: FROM msc_supplies ms,
269: msc_form_query mfq
270: WHERE ms.plan_id = mfq.number4
271: AND ms.inventory_item_id = mfq.number1
272: AND ms.source_organization_id = mfq.number2

Line 765: select msc_supplies_s.nextval into l_transaction_id from dual;

761: p_dock_date,
762: p_due_date, p_source_inst);
763:
764: --dbms_output.put_line('dock date='||p_dock_date);
765: select msc_supplies_s.nextval into l_transaction_id from dual;
766: --dbms_output.put_line('id ='||l_transaction_id);
767: insert into msc_supplies(
768: transaction_id,
769: last_update_date,

Line 767: insert into msc_supplies(

763:
764: --dbms_output.put_line('dock date='||p_dock_date);
765: select msc_supplies_s.nextval into l_transaction_id from dual;
766: --dbms_output.put_line('id ='||l_transaction_id);
767: insert into msc_supplies(
768: transaction_id,
769: last_update_date,
770: last_updated_by,
771: creation_date,

Line 940: from msc_supplies ms,

936: sysdate,
937: 1,
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

Line 941: msc_supplies parent,

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

Line 972: from msc_supplies ms,

968: sysdate,
969: 1,
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

Line 973: msc_supplies parent,

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

Line 1009: from msc_supplies ms,

1005: sysdate,
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