DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 999: bom_inventory_components ic1,

995:
996: FROM bom_cto_order_lines bcol1, -- components
997: bom_cto_order_lines bcol2, -- parent models or option classes
998: mtl_system_items msi,
999: bom_inventory_components ic1,
1000: bom_bill_of_materials b1,
1001: bom_operational_routings or1,
1002: bom_operation_sequences os1
1003: WHERE bcol1.parent_ato_line_id = pLineId /*AP*/

Line 1026: bom_inventory_components bic1

1022: (
1023: SELECT DISTINCT
1024: assembly_item_id
1025: FROM bom_bill_of_materials bbm1,
1026: bom_inventory_components bic1
1027: WHERE bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1028: AND component_sequence_id = bcol1.component_sequence_id
1029: AND bbm1.assembly_item_id = bcol2.inventory_item_id
1030: )

Line 1211: bom_inventory_components ic1,

1207: -- 5336292
1208: FROM bom_operation_sequences os1,
1209: bom_operational_routings or1,
1210: mtl_system_items si2,
1211: bom_inventory_components ic1,
1212: bom_bill_of_materials b1,
1213: mtl_system_items si1
1214: WHERE si1.organization_id = pOrgId
1215: AND si1.inventory_item_id = pModelId

Line 1846: bom_inventory_components ic1,

1842: x_coordinate,
1843: y_coordinate
1844: FROM bom_cto_order_lines bcol1, /* components */
1845: bom_cto_order_lines bcol2, /* parents model */
1846: bom_inventory_components ic1,
1847: bom_bill_of_materials b1,
1848: bom_operational_routings or1,
1849: bom_operation_sequences os1
1850: WHERE bcol1.parent_ato_line_id = pLineId

Line 1870: bom_inventory_components bic1

1866: (
1867: SELECT DISTINCT
1868: assembly_item_id
1869: FROM bom_bill_of_materials bbm1,
1870: bom_inventory_components bic1
1871: WHERE bbm1.common_bill_sequence_id = bic1.bill_sequence_id
1872: AND component_sequence_id = bcol1.component_sequence_id
1873: AND bbm1.assembly_item_id = bcol2.inventory_item_id
1874: )

Line 2055: bom_inventory_components ic1,

2051:
2052: FROM bom_operation_sequences os1,
2053: bom_operational_routings or1,
2054: mtl_system_items si2,
2055: bom_inventory_components ic1,
2056: bom_bill_of_materials b1,
2057: mtl_system_items si1,
2058: bom_cto_order_lines bcol /* Model or option class */
2059: WHERE bcol.parent_ato_line_id = pLineId