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.BOM_COPY_ROUTING dependencies on BOM_SETUP_TYPES

Line 1732: bom_setup_types bst -- added for bug 2751946

1728: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
1729: setup_id =
1730: (SELECT brs.setup_id
1731: FROM bom_resource_setups brs,
1732: bom_setup_types bst -- added for bug 2751946
1733: WHERE brs.resource_id = a.resource_id
1734: AND brs.setup_id = bst.setup_id
1735: AND bst.setup_code = (SELECT setup_code
1736: FROM bom_setup_types

Line 1736: FROM bom_setup_types

1732: bom_setup_types bst -- added for bug 2751946
1733: WHERE brs.resource_id = a.resource_id
1734: AND brs.setup_id = bst.setup_id
1735: AND bst.setup_code = (SELECT setup_code
1736: FROM bom_setup_types
1737: WHERE setup_id = a.setup_id))
1738: WHERE a.operation_sequence_id IN (
1739: SELECT operation_sequence_id
1740: FROM bom_operation_sequences

Line 1975: bom_setup_types bst

1971: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
1972: setup_id =
1973: (SELECT brs.setup_id
1974: FROM bom_resource_setups brs,
1975: bom_setup_types bst
1976: WHERE brs.resource_id = a.resource_id
1977: AND brs.setup_id = bst.setup_id
1978: AND bst.setup_code = (SELECT setup_code
1979: FROM bom_setup_types

Line 1979: FROM bom_setup_types

1975: bom_setup_types bst
1976: WHERE brs.resource_id = a.resource_id
1977: AND brs.setup_id = bst.setup_id
1978: AND bst.setup_code = (SELECT setup_code
1979: FROM bom_setup_types
1980: WHERE setup_id = a.setup_id))
1981: WHERE a.operation_sequence_id IN (
1982: SELECT operation_sequence_id
1983: FROM bom_operation_sequences

Line 3630: bom_setup_types bst -- added for bug 2751946

3626: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
3627: setup_id =
3628: (SELECT brs.setup_id
3629: FROM bom_resource_setups brs,
3630: bom_setup_types bst -- added for bug 2751946
3631: WHERE brs.resource_id = a.resource_id
3632: AND brs.setup_id = bst.setup_id
3633: AND bst.setup_code = (SELECT setup_code
3634: FROM bom_setup_types

Line 3634: FROM bom_setup_types

3630: bom_setup_types bst -- added for bug 2751946
3631: WHERE brs.resource_id = a.resource_id
3632: AND brs.setup_id = bst.setup_id
3633: AND bst.setup_code = (SELECT setup_code
3634: FROM bom_setup_types
3635: WHERE setup_id = a.setup_id))
3636: WHERE a.operation_sequence_id IN (
3637: SELECT operation_sequence_id
3638: FROM bom_operation_sequences

Line 3875: bom_setup_types bst

3871: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
3872: setup_id =
3873: (SELECT brs.setup_id
3874: FROM bom_resource_setups brs,
3875: bom_setup_types bst
3876: WHERE brs.resource_id = a.resource_id
3877: AND brs.setup_id = bst.setup_id
3878: AND bst.setup_code = (SELECT setup_code
3879: FROM bom_setup_types

Line 3879: FROM bom_setup_types

3875: bom_setup_types bst
3876: WHERE brs.resource_id = a.resource_id
3877: AND brs.setup_id = bst.setup_id
3878: AND bst.setup_code = (SELECT setup_code
3879: FROM bom_setup_types
3880: WHERE setup_id = a.setup_id))
3881: WHERE a.operation_sequence_id IN (
3882: SELECT operation_sequence_id
3883: FROM bom_operation_sequences