DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_COMPONENT_OPERATIONS

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

678: -- "additional" option dependent steps associated with options/OC
679: -- Option dependent steps associated with mandatory comps.
680: -- "additional" Option dependent steps associated with mandatory comps.
681: The "additional" operation steps are the steps stored in the new
682: table bom_component_operations to support one-to-many BOM components
683: to Routing steps.
684: +----------------------------------------------------------------*/
685:
686: --perf bug#4905857 , sql id 16103149

Line 1055: FROM bom_component_operations bco

1051: os1.operation_seq_num in
1052: (
1053: SELECT
1054: bco.operation_seq_num
1055: FROM bom_component_operations bco
1056: WHERE bco.component_sequence_id = ic1.component_sequence_id
1057: )
1058: )
1059: )

Line 1244: FROM bom_component_operations bco

1240: os1.operation_seq_num in
1241: (
1242: SELECT
1243: bco.operation_seq_num
1244: FROM bom_component_operations bco
1245: WHERE bco.component_sequence_id = ic1.component_sequence_id
1246: )
1247: )
1248: )

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

1527: -- "Additional" option dependent steps associated with options/option Class
1528: -- Option dependent steps associated with mandatory comps.
1529: -- "Additional" option dependent steps associated with mandatory comps.
1530: The "additional" operation steps are the steps stored in the new
1531: table bom_component_operations to support one-to-many BOM components
1532: to Routing steps.
1533: +-------------------------------------------------------------*/
1534:
1535: --perf bugfix 4905857 sql id 16103308

Line 1899: FROM bom_component_operations bco

1895: os1.operation_seq_num in
1896: (
1897: SELECT
1898: bco.operation_seq_num
1899: FROM bom_component_operations bco
1900: WHERE bco.component_sequence_id = ic1.component_sequence_id
1901: )
1902: )
1903: )

Line 2092: FROM bom_component_operations bco

2088: os1.operation_seq_num in
2089: (
2090: SELECT
2091: bco.operation_seq_num
2092: FROM bom_component_operations bco
2093: WHERE bco.component_sequence_id = ic1.component_sequence_id
2094: )
2095: )
2096: )