DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on MTL_UNITS_OF_MEASURE

Line 1955: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;

1951: l_from_ou NUMBER;
1952: l_to_ou NUMBER;
1953:
1954: l_conversion_rate NUMBER;
1955: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1956: l_trans_uom_code mtl_units_of_measure.uom_code%TYPE;
1957: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1958:
1959: BEGIN

Line 1956: l_trans_uom_code mtl_units_of_measure.uom_code%TYPE;

1952: l_to_ou NUMBER;
1953:
1954: l_conversion_rate NUMBER;
1955: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1956: l_trans_uom_code mtl_units_of_measure.uom_code%TYPE;
1957: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1958:
1959: BEGIN
1960:

Line 1957: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1953:
1954: l_conversion_rate NUMBER;
1955: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1956: l_trans_uom_code mtl_units_of_measure.uom_code%TYPE;
1957: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1958:
1959: BEGIN
1960:
1961: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2070: FROM mtl_units_of_measure_vl

2066: THEN
2067:
2068: SELECT uom_code
2069: INTO l_primary_uom_code
2070: FROM mtl_units_of_measure_vl
2071: WHERE unit_of_measure_tl = l_primary_uom;
2072:
2073: SELECT uom_code
2074: INTO l_trans_uom_code

Line 2075: FROM mtl_units_of_measure_vl

2071: WHERE unit_of_measure_tl = l_primary_uom;
2072:
2073: SELECT uom_code
2074: INTO l_trans_uom_code
2075: FROM mtl_units_of_measure_vl
2076: WHERE unit_of_measure_tl = p_trans_uom;
2077:
2078: inv_convert.inv_um_conversion(
2079: from_unit => l_primary_uom_code