eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_BILL_OF_MATERIALS

Line 44: | Add bom_bill_of_materials.organization_id = pOrgId condition

40: | ksarkar 17-AUG-01 Bugfix 1935580
41: | Unique constraint on bom_operation_sequences will be violated
42: | hen config item has selected models with same op seq number.
43: | Refer bug for details
44: | Add bom_bill_of_materials.organization_id = pOrgId condition
45: | to select routing from correct organisation.
46: |
47: | Combining 1935580 and 1906371 ; since option rows are inserted into
48: | bom_operation_sequences after model rows , check needs to be there

Line 981: bom_bill_of_materials b1,

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*/
985: AND bcol1.item_type_code in ('CLASS','OPTION')

Line 999: FROM bom_bill_of_materials bbm

995: AND ic1.bill_sequence_id =
996: (
997: SELECT
998: common_bill_sequence_id
999: FROM bom_bill_of_materials bbm
1000: WHERE organization_id = pOrgId
1001: AND alternate_bom_designator is null
1002: AND assembly_item_id =
1003: (

Line 1006: FROM bom_bill_of_materials bbm1,

1002: AND assembly_item_id =
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

Line 1194: bom_bill_of_materials b1,

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
1198: AND si1.bom_item_type = 1 /* model */

Line 1828: bom_bill_of_materials b1,

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
1832: AND bcol1.item_type_code in ('CLASS','OPTION')

Line 1843: FROM bom_bill_of_materials bbm

1839: AND ic1.bill_sequence_id =
1840: (
1841: SELECT
1842: common_bill_sequence_id
1843: FROM bom_bill_of_materials bbm
1844: WHERE organization_id = pOrgId
1845: AND alternate_bom_designator is null
1846: AND assembly_item_id =
1847: (

Line 1850: FROM bom_bill_of_materials bbm1,

1846: AND assembly_item_id =
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

Line 2038: bom_bill_of_materials b1,

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
2042: AND bcol.component_sequence_id is not null