APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_COMPONENT_OPERATIONS

Line 2436: table bom_component_operations to support one-to-many BOM components

2432: -- "additional" option dependent steps associated with options/OC
2433: -- Option dependent steps associated with mandatory comps.
2434: -- "additional" Option dependent steps associated with mandatory comps.
2435: The "additional" operation steps are the steps stored in the new
2436: table bom_component_operations to support one-to-many BOM components
2437: to Routing steps.
2438: +----------------------------------------------------------------*/
2439:
2440: lStmtNum := 50;

Line 2541: from bom_component_operations bco

2537: and os1.routing_sequence_id = or1.common_routing_sequence_id
2538: and ((os1.operation_seq_num = ic1.operation_seq_num)
2539: or (os1.operation_seq_num in
2540: (select bco.operation_seq_num
2541: from bom_component_operations bco
2542: where bco.component_sequence_id = ic1.component_sequence_id)))
2543: and os1.option_dependent_flag = 1
2544: and nvl(os1.operation_type,1) = 1;
2545:

Line 2592: from bom_component_operations bco

2588: and os1.option_dependent_flag = 1
2589: and ((os1.operation_seq_num = ic1.operation_seq_num)
2590: or (os1.operation_seq_num in
2591: (select bco.operation_seq_num
2592: from bom_component_operations bco
2593: where bco.component_sequence_id = ic1.component_sequence_id)))
2594: and nvl(os1.operation_type,1) = 1;
2595:
2596:

Line 2868: table bom_component_operations to support one-to-many BOM components

2864: -- "Additional" option dependent steps associated with options/option Class
2865: -- Option dependent steps associated with mandatory comps.
2866: -- "Additional" option dependent steps associated with mandatory comps.
2867: The "additional" operation steps are the steps stored in the new
2868: table bom_component_operations to support one-to-many BOM components
2869: to Routing steps.
2870: +-------------------------------------------------------------*/
2871: lStmtNum := 80;
2872: update bom_operation_sequences

Line 2967: from bom_component_operations bco

2963: and os1.routing_sequence_id = or1.common_routing_sequence_id
2964: and ((os1.operation_seq_num = ic1.operation_seq_num)
2965: or (os1.operation_seq_num in
2966: (select bco.operation_seq_num
2967: from bom_component_operations bco
2968: where bco.component_sequence_id = ic1.component_sequence_id)))
2969: and os1.option_dependent_flag = 1
2970: and nvl(os1.operation_type,1) = 1
2971: union

Line 3019: from bom_component_operations bco

3015: and os1.option_dependent_flag = 1
3016: and ((os1.operation_seq_num = ic1.operation_seq_num)
3017: or (os1.operation_seq_num in
3018: (select bco.operation_seq_num
3019: from bom_component_operations bco
3020: where bco.component_sequence_id = ic1.component_sequence_id)))
3021: and nvl(os1.operation_type,1) = 1)
3022: -- and effectivity_date <= greatest(nvl(lEstRelDate, sysdate),sysdate)
3023: and implementation_date is not null