APPS.BOMPMCFG dependencies on BOM_ATO_CONFIGURATIONS

Line 28: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */

24: CURSOR dupl_rows IS
25: select BAC1.config_item_id,BAC1.organization_id,sol1.unit_code,
26: (sol1.ordered_quantity-nvl(sol1.cancelled_quantity,0)),
27: soh.order_number,sot.name,sod.line_detail_id
28: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */
29: so_lines_all solp, /* Parent of the Model of processing if any */
30: so_lines_all sol1, /* processing */
31: so_headers_all soh, /* to get the header info */
32: so_order_types_all sot,

Line 53: from BOM_ATO_CONFIGURATIONS BAC2 /* duplicates */

49: where sol5.ato_line_id = sol1.line_id
50: and sol5.ordered_quantity > nvl(sol5.cancelled_quantity,0)
51: and sol5.inventory_item_id not in
52: (select BAC2.component_item_id
53: from BOM_ATO_CONFIGURATIONS BAC2 /* duplicates */
54: where BAC2.config_item_id = BAC1.config_item_id
55: and BAC2.component_item_id <> BAC1.component_item_id
56: and BAC2.component_item_id = sol5.inventory_item_id
57: and BAC2.component_code =

Line 67: from BOM_ATO_CONFIGURATIONS BAC3 /* duplicates */

63: (sol1.ordered_quantity-nvl(sol1.cancelled_quantity,0)))
64: )
65: )
66: and not exists(select 'X'
67: from BOM_ATO_CONFIGURATIONS BAC3 /* duplicates */
68: where BAC3.config_item_id = BAC1.config_item_id
69: and BAC3.component_item_id <> BAC1.component_item_id
70: having count(*) <> (select count (*)
71: from so_lines_all sol7 /* processing */

Line 89: update bom_ato_configurations

85: exit when (dupl_rows%notfound);
86: dupl_count := dupl_count + 1;
87:
88: stmt_num := 30;
89: update bom_ato_configurations
90: set last_referenced_date = SYSDATE
91: where config_item_id = configuration_item_id;
92:
93: status := BOMPMCFG.insert_mtl_dem_interface(configuration_item_id,org_id,

Line 237: insert into BOM_ATO_CONFIGURATIONS(

233: is
234: stmt_num number;
235: begin
236: stmt_num := 500;
237: insert into BOM_ATO_CONFIGURATIONS(
238: organization_id,
239: base_model_id,
240: config_item_id,
241: component_item_id,

Line 323: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */

319: stmt_num :=600;
320: update mtl_demand m
321: set m.duplicated_config_item_id = (
322: select BAC1.config_item_id
323: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */
324: so_lines_all solp, /* Parent of ATO Model if any */
325: so_lines_all sol1, /* processing */
326: mtl_system_items msi,
327: bom_parameters bp

Line 342: from BOM_ATO_CONFIGURATIONS BAC2 /* duplicates */

338: where sol5.ato_line_id = sol1.line_id
339: and sol5.ordered_quantity > nvl(sol5.cancelled_quantity,0)
340: and sol5.inventory_item_id not in
341: (select BAC2.component_item_id
342: from BOM_ATO_CONFIGURATIONS BAC2 /* duplicates */
343: where BAC2.config_item_id = BAC1.config_item_id
344: and BAC2.component_item_id <> BAC1.component_item_id
345: and BAC2.component_item_id = sol5.inventory_item_id
346: and BAC2.component_code =

Line 356: from BOM_ATO_CONFIGURATIONS BAC3 /* duplicates */

352: (sol1.ordered_quantity-nvl(sol1.cancelled_quantity,0)))
353: )
354: )
355: and not exists(select 'X'
356: from BOM_ATO_CONFIGURATIONS BAC3 /* duplicates */
357: where BAC3.config_item_id = BAC1.config_item_id
358: and BAC3.component_item_id <> BAC1.component_item_id
359: having count(*) <> (select count (*)
360: from so_lines_all sol7 /* processing */

Line 373: update bom_ato_configurations

369: and m.demand_type = 1
370: and m.duplicated_config_item_id is NULL;
371:
372: stmt_num := 700;
373: update bom_ato_configurations
374: set last_referenced_date = SYSDATE
375: where config_item_id in (select m.duplicated_config_item_id
376: from mtl_demand m
377: where m.config_group_id = USERENV('SESSIONID')