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
1665: hour_uom_class_v, a.schedule_flag,
1666: 2
1667: )
1668: )
1669: FROM mtl_units_of_measure b,
1670: bom_resources c
1671: WHERE a.resource_id = c.resource_id
1672: AND c.unit_of_measure = b.unit_of_measure(+)),
1673: setup_id =
1900: hour_uom_class_v, a.schedule_flag,
1901: 2
1902: )
1903: )
1904: FROM mtl_units_of_measure b,
1905: bom_resources c
1906: WHERE a.resource_id = c.resource_id
1907: AND c.unit_of_measure = b.unit_of_measure(+)),
1908: setup_id =
2349:
2350: BEGIN
2351: SELECT uom_class
2352: INTO hour_uom_class_v
2353: FROM mtl_units_of_measure
2354: WHERE uom_code = hour_uom_code_v;
2355: EXCEPTION
2356: WHEN OTHERS
2357: THEN
3497: hour_uom_class_v, a.schedule_flag,
3498: 2
3499: )
3500: )
3501: FROM mtl_units_of_measure b,
3502: bom_resources c
3503: WHERE a.resource_id = c.resource_id
3504: AND c.unit_of_measure = b.unit_of_measure(+)),
3505: setup_id =
3734: hour_uom_class_v, a.schedule_flag,
3735: 2
3736: )
3737: )
3738: FROM mtl_units_of_measure b,
3739: bom_resources c
3740: WHERE a.resource_id = c.resource_id
3741: AND c.unit_of_measure = b.unit_of_measure(+)),
3742: setup_id =