[Home] [Help]
21: | from match and reserve. Then, it does an in batch match on |
22: | the configurations. |
23: | |
24: | BOMPCHDU.existing_dupl_match -- for a given demand_id, it |
25: | searches BOM ATO Configurations for a matching configuration. |
26: | |
27: | BOMPCHDU.check_dupl_batch_match -- for a given demand_id, it |
28: | checks the other rows to be processed whether any has an |
29: | identical configuration. If any of the other rows are |
284: stmt_num :=60;
285: update mtl_demand m
286: set m.duplicated_config_item_id = (
287: select BAC1.config_item_id
288: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */
289: so_lines_all solp, /* Parent of ATO Model if any */
290: so_lines_all sol1, /* processing */
291: mtl_system_items msi,
292: bom_operational_routings bor,
305: where sol5.ato_line_id = sol1.line_id
306: and sol5.ordered_quantity > nvl(sol5.cancelled_quantity,0)
307: and sol5.inventory_item_id not in
308: (select BAC2.component_item_id
309: from BOM_ATO_CONFIGURATIONS BAC2 /* duplicates */
310: where BAC2.config_item_id = BAC1.config_item_id
311: and BAC2.component_item_id <> BAC1.component_item_id
312: and BAC2.component_item_id = sol5.inventory_item_id
313: and BAC2.component_code =
319: (sol1.ordered_quantity-nvl(sol1.cancelled_quantity,0)))
320: )
321: )
322: and exists(select 'X'
323: from BOM_ATO_CONFIGURATIONS BAC3 /* duplicates */
324: where BAC3.config_item_id = BAC1.config_item_id
325: and BAC3.component_item_id <> BAC1.component_item_id
326: having count(*) = (select count (*)
327: from so_lines_all sol7 /* processing */
346: /* **** is this REALLY necessary? just updated it*** */
347:
348: if (match_results is not null) then
349: stmt_num := 70;
350: update bom_ato_configurations
351: set last_referenced_date = SYSDATE
352: where config_item_id = match_results;
353:
354: end if;