APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_COMPONENT_OPERATIONS

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

2521: -- "additional" option dependent steps associated with options/OC
2522: -- Option dependent steps associated with mandatory comps.
2523: -- "additional" Option dependent steps associated with mandatory comps.
2524: The "additional" operation steps are the steps stored in the new
2525: table bom_component_operations to support one-to-many BOM components
2526: to Routing steps.
2527: +----------------------------------------------------------------*/
2528:
2529: lStmtNum := 50;

Line 2630: from bom_component_operations bco

2626: and os1.routing_sequence_id = or1.common_routing_sequence_id
2627: and ((os1.operation_seq_num = ic1.operation_seq_num)
2628: or (os1.operation_seq_num in
2629: (select bco.operation_seq_num
2630: from bom_component_operations bco
2631: where bco.component_sequence_id = ic1.component_sequence_id)))
2632: and os1.option_dependent_flag = 1
2633: and nvl(os1.operation_type,1) = 1;
2634:

Line 2681: from bom_component_operations bco

2677: and os1.option_dependent_flag = 1
2678: and ((os1.operation_seq_num = ic1.operation_seq_num)
2679: or (os1.operation_seq_num in
2680: (select bco.operation_seq_num
2681: from bom_component_operations bco
2682: where bco.component_sequence_id = ic1.component_sequence_id)))
2683: and nvl(os1.operation_type,1) = 1;
2684:
2685:

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

2953: -- "Additional" option dependent steps associated with options/option Class
2954: -- Option dependent steps associated with mandatory comps.
2955: -- "Additional" option dependent steps associated with mandatory comps.
2956: The "additional" operation steps are the steps stored in the new
2957: table bom_component_operations to support one-to-many BOM components
2958: to Routing steps.
2959: +-------------------------------------------------------------*/
2960: lStmtNum := 80;
2961: update bom_operation_sequences

Line 3056: from bom_component_operations bco

3052: and os1.routing_sequence_id = or1.common_routing_sequence_id
3053: and ((os1.operation_seq_num = ic1.operation_seq_num)
3054: or (os1.operation_seq_num in
3055: (select bco.operation_seq_num
3056: from bom_component_operations bco
3057: where bco.component_sequence_id = ic1.component_sequence_id)))
3058: and os1.option_dependent_flag = 1
3059: and nvl(os1.operation_type,1) = 1
3060: union

Line 3108: from bom_component_operations bco

3104: and os1.option_dependent_flag = 1
3105: and ((os1.operation_seq_num = ic1.operation_seq_num)
3106: or (os1.operation_seq_num in
3107: (select bco.operation_seq_num
3108: from bom_component_operations bco
3109: where bco.component_sequence_id = ic1.component_sequence_id)))
3110: and nvl(os1.operation_type,1) = 1)
3111: -- and effectivity_date <= greatest(nvl(lEstRelDate, sysdate),sysdate)
3112: and implementation_date is not null