APPS.CTO_MATCH_AND_RESERVE dependencies on BOM_CTO_ORDER_LINES

Line 207: from bom_cto_order_lines

203:
204:
205: cursor c_model_lines is
206: select line_id, parent_ato_line_id
207: from bom_cto_order_lines
208: where bom_item_type = 1
209: --and top_model_line_id = p_model_line_id
210: and ato_line_id = p_model_line_id
211: and nvl(wip_supply_type,0) <> 6

Line 289: -- call to populate_bom_cto_order_lines with top_model_line_id

285: IF (cto_workflow.validate_line(p_model_line_id) = FALSE) THEN
286: raise INVALID_LINE;
287: END IF;
288:
289: -- call to populate_bom_cto_order_lines with top_model_line_id
290: -- populating bcol using ato_line_id instead of top_model_line_id
291: -- change to support multiple ATO models under a PTO model, sajani
292:
293: l_stmt_num := 101;

Line 310: delete from bom_cto_order_lines where ato_line_id = p_model_line_id ;

306: IF PG_DEBUG <> 0 THEN
307: oe_debug_pub.add('Before populate_bcol.', 1);
308: END IF;
309:
310: delete from bom_cto_order_lines where ato_line_id = p_model_line_id ;
311:
312: IF PG_DEBUG <> 0 THEN
313: oe_debug_pub.add('CTOMCRSB: deleted bcol: ' || to_char(SQL%ROWCOUNT));
314: END IF;

Line 354: from bom_cto_order_lines bcol

350:
351: l_stmt_num := 105;
352: select bcol.inventory_item_id, bcol.ship_from_org_id, perform_match
353: into l_model_id, l_org_id , l_perform_match
354: from bom_cto_order_lines bcol
355: where bcol.line_id = p_model_line_id;
356:
357:
358: --

Line 397: -- 2. Add lines in bom_cto_order_lines

393:
394:
395: -- This is the part that will change. We need to do the following:
396: -- 1. Select and mark the lines in oe_order_lines_all
397: -- 2. Add lines in bom_cto_order_lines
398: -- 3. Match up the tree (stop as soon as an assly does not match)
399: -- 4. If the final assembly matches,
400: -- a. add sourcing info in bom_cto_src_orgs
401: -- b. call create items, which will create all the items

Line 408: -- This is the loop that traverses bom_cto_order_lines to match

404: -- 5. Unmark the records
405:
406:
407: --
408: -- This is the loop that traverses bom_cto_order_lines to match
409: -- each configured assembly from bottom to top. The loop
410: -- exits as soon as an assembly does not match.
411: --
412:

Line 433: delete from bom_cto_order_lines

429:
430: x_message_name := 'CTO_MATCH_NA' ;
431:
432: l_stmt_num := 137;
433: delete from bom_cto_order_lines
434: where top_model_line_id = l_top_model_line_id;
435:
436: IF PG_DEBUG <> 0 THEN
437: oe_debug_pub.add(x_error_message,1);

Line 493: from bom_cto_order_lines

489: v_cto_match_rec.plan_level,
490: v_cto_match_rec.bom_item_type,
491: v_cto_match_rec.wip_supply_type,
492: v_cto_match_rec.ship_from_org_id --bugfix 3692727
493: from bom_cto_order_lines
494: where ato_line_id = p_model_line_id
495: order by plan_level ;
496:
497:

Line 568: delete from bom_cto_order_lines

564: x_error_message := 'No matching configurations for line '
565: || to_char(l_top_model_line_id);
566:
567: l_stmt_num := 137;
568: delete from bom_cto_order_lines
569: where top_model_line_id = l_top_model_line_id;
570:
571: IF PG_DEBUG <> 0 THEN
572: oe_debug_pub.add(x_error_message,1);

Line 652: -- bom_cto_order_lines and create all items in all src orgs

648: END IF;
649:
650:
651: -- call create_all_items, which will go through
652: -- bom_cto_order_lines and create all items in all src orgs
653:
654: IF PG_DEBUG <> 0 THEN
655: oe_debug_pub.add('Calling Create_All_Items');
656: END IF;