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 614: FROM mtl_units_of_measure muom

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

Line 1062: mtl_units_of_measure_tl mum,

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

Line 3196: FROM mtl_units_of_measure

3192:
3193: -- check that the uom is valid
3194: SELECT NVL(MAX(unit_of_measure), 'notfound')
3195: INTO x_unit_of_measure
3196: FROM mtl_units_of_measure
3197: WHERE unit_of_measure = x_uom_record.unit_of_measure;
3198:
3199: IF (x_unit_of_measure = 'notfound') THEN
3200: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');