APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_FORM_QUERY

Line 147: FROM msc_form_query list,

143: md.using_assembly_demand_date new_date,
144: md.using_assembly_demand_date old_date,
145: sum(md.using_requirement_quantity) new_quantity,
146: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
147: FROM msc_form_query list,
148: msc_demands md
149: WHERE md.plan_id = list.number4
150: AND md.inventory_item_id = list.number1
151: AND md.organization_id = list.number2

Line 201: FROM msc_form_query list,

197: forecast.consumption_date new_date,
198: forecast.consumption_date old_date,
199: sum(nvl(forecast.consumed_qty,0)) new_quantity,
200: 0 old_quantity
201: FROM msc_form_query list,
202: msc_forecast_updates forecast
203: where forecast.organization_id = list.number2
204: AND forecast.plan_id = list.number4
205: AND forecast.inventory_item_id = list.number1

Line 252: FROM msc_form_query list,

248: md.using_assembly_demand_date new_date,
249: md.using_assembly_demand_date old_date,
250: sum(nvl(md.using_requirement_quantity,0)) new_quantity,
251: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
252: FROM msc_form_query list,
253: msc_demands md
254: WHERE md.plan_id = list.number4
255: AND md.inventory_item_id = list.number1
256: AND md.organization_id = list.number2

Line 305: FROM msc_form_query list,

301: md.using_assembly_demand_date new_date,
302: md.using_assembly_demand_date old_date,
303: sum(nvl(md.using_requirement_quantity,0)) new_quantity,
304: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
305: FROM msc_form_query list,
306: msc_demands md
307: WHERE md.plan_id = list.number4
308: AND md.original_item_id = list.number1
309: AND md.organization_id = list.number2

Line 350: FROM msc_form_query list

346: to_date(1, 'J'),
347: to_date(1, 'J'),
348: 0,
349: 0
350: FROM msc_form_query list
351: WHERE list.query_id = item_list_id
352: ORDER BY
353: 1, 2,4,7;
354:

Line 959: INSERT INTO msc_form_query (

955: FETCH local_forecasting INTO p_ship_to_level;
956: CLOSE local_forecasting;
957: --dbms_output.put_line(p_org_id(a)||','|| p_inst_id(a)||','|| p_item_id(b)||','||p_ship_to_level||','||p_display_org_id);
958: begin
959: INSERT INTO msc_form_query (
960: query_id,
961: last_update_date,
962: last_updated_by,
963: creation_date,

Line 1010: INSERT INTO msc_form_query (

1006:
1007: else -- GLOBAL FORECASTING CASE
1008:
1009: forall b in 1..p_item_id.count
1010: INSERT INTO msc_form_query (
1011: query_id,
1012: last_update_date,
1013: last_updated_by,
1014: creation_date,

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

1109: l_ship_stmt := ' and md.demand_class = ''' || p_ship_id || '''';
1110: end if;
1111: end if;
1112:
1113: sql_stmt := 'INSERT INTO msc_form_query ( '||
1114: 'query_id, '||
1115: 'last_update_date, '||
1116: 'last_updated_by, '||
1117: 'creation_date, '||