APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on MTL_UNITS_OF_MEASURE

Line 737: FROM mtl_units_of_measure muom

733: END IF;
734:
735: SELECT muom.uom_code
736: INTO x_cascaded_table(n).uom_code
737: FROM mtl_units_of_measure muom
738: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
739: ELSE
740: IF (g_asn_debug = 'Y') THEN
741: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');

Line 1934: FROM mtl_units_of_measure muom,

1930: IF temp_cascaded_table(current_n).item_id IS NULL THEN
1931: BEGIN
1932: SELECT muom.unit_of_measure
1933: INTO temp_cascaded_table(current_n).primary_unit_of_measure
1934: FROM mtl_units_of_measure muom,
1935: mtl_units_of_measure tuom
1936: WHERE tuom.unit_of_measure = temp_cascaded_table(current_n).unit_of_measure
1937: AND tuom.uom_class = muom.uom_class
1938: AND muom.base_uom_flag = 'Y';

Line 1935: mtl_units_of_measure tuom

1931: BEGIN
1932: SELECT muom.unit_of_measure
1933: INTO temp_cascaded_table(current_n).primary_unit_of_measure
1934: FROM mtl_units_of_measure muom,
1935: mtl_units_of_measure tuom
1936: WHERE tuom.unit_of_measure = temp_cascaded_table(current_n).unit_of_measure
1937: AND tuom.uom_class = muom.uom_class
1938: AND muom.base_uom_flag = 'Y';
1939:

Line 3137: -- FROM mtl_units_of_measure mum

3133: -- begin
3134:
3135: -- SELECT min(unit_of_measure)
3136: -- INTO x_cascaded_table(n).primary_unit_of_measure
3137: -- FROM mtl_units_of_measure mum
3138: -- WHERE uom_class = x_cascaded_table(n).unit_of_measure_class
3139: -- AND mum.base_uom_flag = 'Y';
3140:
3141: -- exception