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 1000: bom_bill_of_materials b1,

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

Line 1018: FROM bom_bill_of_materials bbm

1014: AND ic1.bill_sequence_id =
1015: (
1016: SELECT
1017: common_bill_sequence_id
1018: FROM bom_bill_of_materials bbm
1019: WHERE organization_id = pOrgId
1020: AND alternate_bom_designator is null
1021: AND assembly_item_id =
1022: (

Line 1025: FROM bom_bill_of_materials bbm1,

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

Line 1212: bom_bill_of_materials b1,

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

Line 1847: bom_bill_of_materials b1,

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

Line 1862: FROM bom_bill_of_materials bbm

1858: AND ic1.bill_sequence_id =
1859: (
1860: SELECT
1861: common_bill_sequence_id
1862: FROM bom_bill_of_materials bbm
1863: WHERE organization_id = pOrgId
1864: AND alternate_bom_designator is null
1865: AND assembly_item_id =
1866: (

Line 1869: FROM bom_bill_of_materials bbm1,

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

Line 2056: bom_bill_of_materials b1,

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