DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_UNITS_OF_MEASURE

Line 149: FROM mtl_units_of_measure

145: x_error_status := rcv_error_pkg.g_ret_sts_error;
146:
147: SELECT NVL(MAX(unit_of_measure), 'notfound')
148: INTO x_unit_of_measure
149: FROM mtl_units_of_measure
150: WHERE unit_of_measure = x_uom_record.unit_of_measure;
151:
152: IF (x_unit_of_measure = 'notfound') THEN
153: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');

Line 2048: FROM mtl_units_of_measure

2044:
2045: ELSE
2046: Select UNIT_OF_MEASURE
2047: INTO x_att_rec.secondary_unit_of_measure
2048: FROM mtl_units_of_measure
2049: WHERE uom_code = x_att_rec.secondary_uom_code;
2050:
2051: l_progress :='0009';
2052: IF g_asn_debug = 'Y' THEN

Line 2087: FROM mtl_units_of_measure

2083: END IF;
2084:
2085: SELECT UNIT_OF_MEASURE
2086: INTO l_secondary_unit_of_measure
2087: FROM mtl_units_of_measure
2088: WHERE uom_code = x_att_rec.secondary_uom_code;
2089:
2090: l_progress :='0011';
2091: IF g_asn_debug = 'Y' THEN

Line 2145: FROM mtl_units_of_measure

2141: END IF;
2142:
2143: Select UNIT_OF_MEASURE
2144: INTO x_att_rec.secondary_unit_of_measure
2145: FROM mtl_units_of_measure
2146: WHERE uom_code = x_att_rec.secondary_uom_code;
2147:
2148: l_progress :='0014';
2149: IF g_asn_debug = 'Y' THEN

Line 2205: FROM mtl_units_of_measure

2201: l_progress :='0017';
2202:
2203: SELECT UNIT_OF_MEASURE
2204: INTO l_secondary_unit_of_measure
2205: FROM mtl_units_of_measure
2206: WHERE uom_code = x_att_rec.secondary_uom_code;
2207:
2208: l_progress :='0171';
2209: IF g_asn_debug = 'Y' THEN