APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_UNITS_OF_MEASURE

Line 380: FROM mtl_units_of_measure muom

376: END IF;
377:
378: SELECT muom.uom_code
379: INTO x_cascaded_table(n).uom_code
380: FROM mtl_units_of_measure muom
381: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
382: ELSE
383: IF (g_asn_debug = 'Y') THEN
384: asn_debug.put_line('uom_code not derived as unit_of_measure is null');

Line 436: FROM mtl_units_of_measure muom

432: END IF;
433:
434: SELECT muom.uom_code
435: INTO x_cascaded_table(n).uom_code
436: FROM mtl_units_of_measure muom
437: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
438: ELSE
439: IF (g_asn_debug = 'Y') THEN
440: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');

Line 613: FROM mtl_units_of_measure muom

609: END IF;
610:
611: SELECT muom.uom_code
612: INTO x_cascaded_table(n).uom_code
613: FROM mtl_units_of_measure muom
614: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
615: ELSE
616: IF (g_asn_debug = 'Y') THEN
617: asn_debug.put_line('uom_code not derived as unit_of_measure is null');

Line 1061: mtl_units_of_measure_tl mum,

1057: FROM oe_order_headers_all oeh,
1058: oe_order_lines_all oel,
1059: oe_transaction_types_all olt,
1060: oe_transaction_types_tl t,
1061: mtl_units_of_measure_tl mum,
1062: mtl_system_items msi
1063: WHERE oeh.header_id = v_header_id
1064: AND oeh.header_id = oel.header_id
1065: AND oel.line_id = NVL(v_line_id, oel.line_id)-- bug 4740567

Line 3056: FROM mtl_units_of_measure

3052:
3053: -- check that the uom is valid
3054: SELECT NVL(MAX(unit_of_measure), 'notfound')
3055: INTO x_unit_of_measure
3056: FROM mtl_units_of_measure
3057: WHERE unit_of_measure = x_uom_record.unit_of_measure;
3058:
3059: IF (x_unit_of_measure = 'notfound') THEN
3060: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');