[Home] [Help]
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
192: forecast.consumption_date new_date,
193: forecast.consumption_date old_date,
194: sum(nvl(forecast.consumed_qty,0)) new_quantity,
195: 0 old_quantity
196: FROM msc_form_query list,
197: msc_forecast_updates forecast
198: where forecast.organization_id = list.number2
199: AND forecast.plan_id = list.number4
200: AND forecast.inventory_item_id = list.number1
237: md.using_assembly_demand_date new_date,
238: md.using_assembly_demand_date old_date,
239: sum(nvl(md.using_requirement_quantity,0)) new_quantity,
240: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
241: FROM msc_form_query list,
242: msc_demands md
243: WHERE md.plan_id = list.number4
244: AND md.inventory_item_id = list.number1
245: AND md.organization_id = list.number2
289: md.using_assembly_demand_date new_date,
290: md.using_assembly_demand_date old_date,
291: sum(nvl(md.using_requirement_quantity,0)) new_quantity,
292: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
293: FROM msc_form_query list,
294: msc_demands md
295: WHERE md.plan_id = list.number4
296: AND md.original_item_id = list.number1
297: AND md.organization_id = list.number2
334: to_date(1, 'J'),
335: to_date(1, 'J'),
336: 0,
337: 0
338: FROM msc_form_query list
339: WHERE list.query_id = item_list_id
340: ORDER BY
341: 1, 2,4,7;
342:
943: FETCH local_forecasting INTO p_ship_to_level;
944: CLOSE local_forecasting;
945: --dbms_output.put_line(p_org_id(a)||','|| p_inst_id(a)||','|| p_item_id(b)||','||p_ship_to_level||','||p_display_org_id);
946: begin
947: INSERT INTO msc_form_query (
948: query_id,
949: last_update_date,
950: last_updated_by,
951: creation_date,
994:
995: else -- GLOBAL FORECASTING CASE
996:
997: forall b in 1..p_item_id.count
998: INSERT INTO msc_form_query (
999: query_id,
1000: last_update_date,
1001: last_updated_by,
1002: creation_date,
1101: l_ship_stmt := ' and md.demand_class = ''' || p_ship_id || '''';
1102: end if;
1103: end if;
1104:
1105: sql_stmt := 'INSERT INTO msc_form_query ( '||
1106: 'query_id, '||
1107: 'last_update_date, '||
1108: 'last_updated_by, '||
1109: 'creation_date, '||