APPS.MSC_ALLOCATION_PLAN dependencies on MSC_FORM_QUERY

Line 102: msc_form_query mfq

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

Line 137: msc_form_query mfq

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
141: AND md.sr_instance_id = mfq.number3

Line 207: msc_form_query mfq

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
210: AND ms.plan_id = mfq.number4
211: AND ms.inventory_item_id = mfq.number1

Line 263: msc_form_query mfq

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
267: AND ms.source_sr_instance_id = mfq.number3

Line 284: FROM msc_form_query mfq

280: -1 sequence,
281: to_date(1, 'J') new_date,
282: 0 quantity,
283: 0 quantity2
284: FROM msc_form_query mfq
285: WHERE mfq.query_id = arg_query_id
286: ORDER BY 3,2,4;
287:
288: TYPE alloc_activity IS RECORD

Line 839: sql_stmt := 'INSERT INTO msc_form_query ( '||

835:
836: sql_stmt VARCHAR2(5000);
837: p_org_code varchar2(80);
838: BEGIN
839: sql_stmt := 'INSERT INTO msc_form_query ( '||
840: 'query_id, '||
841: 'last_update_date, '||
842: 'last_updated_by, '||
843: 'creation_date, '||

Line 905: SELECT msc_form_query_s.nextval

901: return NUMBER IS
902: p_query_id number;
903: BEGIN
904:
905: SELECT msc_form_query_s.nextval
906: INTO p_query_id
907: FROM dual;
908:
909: if p_sub_type in (1,9) then -- total, reqular org

Line 910: insert into msc_form_query(

906: INTO p_query_id
907: FROM dual;
908:
909: if p_sub_type in (1,9) then -- total, reqular org
910: insert into msc_form_query(
911: query_id,
912: last_update_date,
913: last_updated_by,
914: creation_date,

Line 928: msc_form_query mfq

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
931: and ms.plan_id = mfq.number4
932: and ms.inventory_item_id = mfq.number1

Line 942: insert into msc_form_query(

938: and parent.order_type = 51
939: and ms.new_schedule_date between p_start_date and p_end_date
940: and mfq.query_id = p_item_query_id;
941:
942: insert into msc_form_query(
943: query_id,
944: last_update_date,
945: last_updated_by,
946: creation_date,

Line 961: msc_form_query mfq

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
964: and ms.plan_id = mfq.number4
965: and ms.inventory_item_id = mfq.number1

Line 979: insert into msc_form_query(

975: and mfq.query_id = p_item_query_id;
976: end if; -- if p_sub_type in (1,9) then
977:
978: if p_sub_type <> 9 then -- not a reqular org
979: insert into msc_form_query(
980: query_id,
981: last_update_date,
982: last_updated_by,
983: creation_date,

Line 997: msc_form_query mfq

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
1001: and ms.inventory_item_id = mfq.number1