APPS.BOM_COPY_ROUTING dependencies on BOM_RESOURCE_SETUPS

Line 1731: FROM bom_resource_setups brs,

1727: WHERE a.resource_id = c.resource_id
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

Line 1974: FROM bom_resource_setups brs,

1970: WHERE a.resource_id = c.resource_id
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

Line 3629: FROM bom_resource_setups brs,

3625: WHERE a.resource_id = c.resource_id
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

Line 3874: FROM bom_resource_setups brs,

3870: WHERE a.resource_id = c.resource_id
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