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 1867: FROM mtl_units_of_measure

1863:
1864: ELSE
1865: Select UNIT_OF_MEASURE
1866: INTO x_att_rec.secondary_unit_of_measure
1867: FROM mtl_units_of_measure
1868: WHERE uom_code = x_att_rec.secondary_uom_code;
1869:
1870: l_progress :='0009';
1871: IF g_asn_debug = 'Y' THEN

Line 1906: FROM mtl_units_of_measure

1902: END IF;
1903:
1904: SELECT UNIT_OF_MEASURE
1905: INTO l_secondary_unit_of_measure
1906: FROM mtl_units_of_measure
1907: WHERE uom_code = x_att_rec.secondary_uom_code;
1908:
1909: l_progress :='0011';
1910: IF g_asn_debug = 'Y' THEN

Line 1964: FROM mtl_units_of_measure

1960: END IF;
1961:
1962: Select UNIT_OF_MEASURE
1963: INTO x_att_rec.secondary_unit_of_measure
1964: FROM mtl_units_of_measure
1965: WHERE uom_code = x_att_rec.secondary_uom_code;
1966:
1967: l_progress :='0014';
1968: IF g_asn_debug = 'Y' THEN

Line 2024: FROM mtl_units_of_measure

2020: l_progress :='0017';
2021:
2022: SELECT UNIT_OF_MEASURE
2023: INTO l_secondary_unit_of_measure
2024: FROM mtl_units_of_measure
2025: WHERE uom_code = x_att_rec.secondary_uom_code;
2026:
2027: l_progress :='0171';
2028: IF g_asn_debug = 'Y' THEN