APPS.BOM_COPY_ROUTING dependencies on MTL_UNITS_OF_MEASURE

Line 303: FROM mtl_units_of_measure

299:
300: BEGIN
301: SELECT uom_class
302: INTO hour_uom_class_v
303: FROM mtl_units_of_measure
304: WHERE uom_code = hour_uom_code_v;
305: EXCEPTION
306: WHEN OTHERS
307: THEN

Line 1725: FROM mtl_units_of_measure b,

1721: hour_uom_class_v, a.schedule_flag,
1722: 2
1723: )
1724: )
1725: FROM mtl_units_of_measure b,
1726: bom_resources c
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 =

Line 1968: FROM mtl_units_of_measure b,

1964: hour_uom_class_v, a.schedule_flag,
1965: 2
1966: )
1967: )
1968: FROM mtl_units_of_measure b,
1969: bom_resources c
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 =

Line 2417: FROM mtl_units_of_measure

2413:
2414: BEGIN
2415: SELECT uom_class
2416: INTO hour_uom_class_v
2417: FROM mtl_units_of_measure
2418: WHERE uom_code = hour_uom_code_v;
2419: EXCEPTION
2420: WHEN OTHERS
2421: THEN

Line 3623: FROM mtl_units_of_measure b,

3619: hour_uom_class_v, a.schedule_flag,
3620: 2
3621: )
3622: )
3623: FROM mtl_units_of_measure b,
3624: bom_resources c
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 =

Line 3868: FROM mtl_units_of_measure b,

3864: hour_uom_class_v, a.schedule_flag,
3865: 2
3866: )
3867: )
3868: FROM mtl_units_of_measure b,
3869: bom_resources c
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 =