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 101: FROM msc_supplies ms,

97: 1 sequence,
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: FROM msc_supplies ms,
102: msc_form_query mfq
103: WHERE ms.plan_id = mfq.number4
104: AND ms.inventory_item_id = mfq.number1
105: AND ms.organization_id = mfq.number2

Line 205: msc_supplies ms,

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

Line 262: FROM msc_supplies ms,

258: 9 sequence,
259: nvl(ms.firm_ship_date,ms.new_ship_date) new_date,
260: sum(nvl(ms.firm_quantity,ms.new_order_quantity)) quantity,
261: 0 quantity2
262: FROM msc_supplies ms,
263: msc_form_query mfq
264: WHERE ms.plan_id = mfq.number4
265: AND ms.inventory_item_id = mfq.number1
266: AND ms.source_organization_id = mfq.number2

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

746: p_dock_date,
747: p_due_date);
748:
749: --dbms_output.put_line('dock date='||p_dock_date);
750: select msc_supplies_s.nextval into l_transaction_id from dual;
751: --dbms_output.put_line('id ='||l_transaction_id);
752: insert into msc_supplies(
753: transaction_id,
754: last_update_date,

Line 752: insert into msc_supplies(

748:
749: --dbms_output.put_line('dock date='||p_dock_date);
750: select msc_supplies_s.nextval into l_transaction_id from dual;
751: --dbms_output.put_line('id ='||l_transaction_id);
752: insert into msc_supplies(
753: transaction_id,
754: last_update_date,
755: last_updated_by,
756: creation_date,

Line 925: from msc_supplies ms,

921: sysdate,
922: 1,
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

Line 926: msc_supplies parent,

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

Line 957: from msc_supplies ms,

953: sysdate,
954: 1,
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

Line 958: msc_supplies parent,

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

Line 994: from msc_supplies ms,

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