DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 980: bom_inventory_components ic1,

976: y_coordinate
977: FROM bom_cto_order_lines bcol1, -- components
978: bom_cto_order_lines bcol2, -- parent models or option classes
979: mtl_system_items msi,
980: bom_inventory_components ic1,
981: bom_bill_of_materials b1,
982: bom_operational_routings or1,
983: bom_operation_sequences os1
984: WHERE bcol1.parent_ato_line_id = pLineId /*AP*/

Line 1007: bom_inventory_components bic1

1003: (
1004: SELECT DISTINCT
1005: assembly_item_id
1006: FROM bom_bill_of_materials bbm1,
1007: bom_inventory_components bic1
1008: WHERE bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1009: AND component_sequence_id = bcol1.component_sequence_id
1010: AND bbm1.assembly_item_id = bcol2.inventory_item_id
1011: )

Line 1193: bom_inventory_components ic1,

1189: -- 5336292
1190: FROM bom_operation_sequences os1,
1191: bom_operational_routings or1,
1192: mtl_system_items si2,
1193: bom_inventory_components ic1,
1194: bom_bill_of_materials b1,
1195: mtl_system_items si1
1196: WHERE si1.organization_id = pOrgId
1197: AND si1.inventory_item_id = pModelId

Line 1827: bom_inventory_components ic1,

1823: x_coordinate,
1824: y_coordinate
1825: FROM bom_cto_order_lines bcol1, /* components */
1826: bom_cto_order_lines bcol2, /* parents model */
1827: bom_inventory_components ic1,
1828: bom_bill_of_materials b1,
1829: bom_operational_routings or1,
1830: bom_operation_sequences os1
1831: WHERE bcol1.parent_ato_line_id = pLineId

Line 1851: bom_inventory_components bic1

1847: (
1848: SELECT DISTINCT
1849: assembly_item_id
1850: FROM bom_bill_of_materials bbm1,
1851: bom_inventory_components bic1
1852: WHERE bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1853: AND component_sequence_id = bcol1.component_sequence_id
1854: AND bbm1.assembly_item_id = bcol2.inventory_item_id
1855: )

Line 2037: bom_inventory_components ic1,

2033:
2034: FROM bom_operation_sequences os1,
2035: bom_operational_routings or1,
2036: mtl_system_items si2,
2037: bom_inventory_components ic1,
2038: bom_bill_of_materials b1,
2039: mtl_system_items si1,
2040: bom_cto_order_lines bcol /* Model or option class */
2041: WHERE bcol.parent_ato_line_id = pLineId