DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_COMPONENT_OPERATIONS

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

692: -- "additional" option dependent steps associated with options/OC
693: -- Option dependent steps associated with mandatory comps.
694: -- "additional" Option dependent steps associated with mandatory comps.
695: The "additional" operation steps are the steps stored in the new
696: table bom_component_operations to support one-to-many BOM components
697: to Routing steps.
698: +----------------------------------------------------------------*/
699:
700: --perf bug#4905857 , sql id 16103149

Line 1074: FROM bom_component_operations bco

1070: os1.operation_seq_num in
1071: (
1072: SELECT
1073: bco.operation_seq_num
1074: FROM bom_component_operations bco
1075: WHERE bco.component_sequence_id = ic1.component_sequence_id
1076: )
1077: )
1078: )

Line 1262: FROM bom_component_operations bco

1258: os1.operation_seq_num in
1259: (
1260: SELECT
1261: bco.operation_seq_num
1262: FROM bom_component_operations bco
1263: WHERE bco.component_sequence_id = ic1.component_sequence_id
1264: )
1265: )
1266: )

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

1546: -- "Additional" option dependent steps associated with options/option Class
1547: -- Option dependent steps associated with mandatory comps.
1548: -- "Additional" option dependent steps associated with mandatory comps.
1549: The "additional" operation steps are the steps stored in the new
1550: table bom_component_operations to support one-to-many BOM components
1551: to Routing steps.
1552: +-------------------------------------------------------------*/
1553:
1554: --perf bugfix 4905857 sql id 16103308

Line 1918: FROM bom_component_operations bco

1914: os1.operation_seq_num in
1915: (
1916: SELECT
1917: bco.operation_seq_num
1918: FROM bom_component_operations bco
1919: WHERE bco.component_sequence_id = ic1.component_sequence_id
1920: )
1921: )
1922: )

Line 2110: FROM bom_component_operations bco

2106: os1.operation_seq_num in
2107: (
2108: SELECT
2109: bco.operation_seq_num
2110: FROM bom_component_operations bco
2111: WHERE bco.component_sequence_id = ic1.component_sequence_id
2112: )
2113: )
2114: )