APPS.INVPUTLI dependencies on MTL_UNITS_OF_MEASURE_TL

Line 1071: l_base_primary_UOM mtl_units_of_measure_tl.unit_of_measure%TYPE;

1067: l_created_by NUMBER;
1068: LOGGING_ERR EXCEPTION;
1069: l_Primary_Unit_of_Measure VARCHAR2(25);
1070: l_Primary_UOM_Code VARCHAR2(3);
1071: l_base_primary_UOM mtl_units_of_measure_tl.unit_of_measure%TYPE;
1072: BEGIN
1073:
1074: INVPUTLI.info('INVPUTLI: inside assign_master_defaults');
1075:

Line 1086: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl

1082: FROM MTL_SYSTEM_ITEMS_INTERFACE
1083: WHERE rowid = p_rowid;
1084:
1085: IF (l_Primary_UOM_Code IS NULL AND l_Primary_Unit_of_Measure IS NOT NULL) THEN
1086: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl
1087: SELECT uom_code INTO l_Primary_UOM_Code
1088: FROM mtl_all_primary_uoms_vv
1089: WHERE inventory_item_id = 0
1090: AND unit_of_measure_tl = l_Primary_Unit_of_Measure;*/

Line 1094: FROM mtl_units_of_measure_tl

1090: AND unit_of_measure_tl = l_Primary_Unit_of_Measure;*/
1091: BEGIN
1092: SELECT uom_code
1093: INTO l_Primary_UOM_Code
1094: FROM mtl_units_of_measure_tl
1095: WHERE language = USERENV('LANG')
1096: AND unit_of_measure = l_Primary_Unit_of_Measure;
1097: -- AND unit_of_measure_tl = l_Primary_Unit_of_Measure; -Bug5260388
1098: EXCEPTION

Line 1103: FROM mtl_units_of_measure_tl

1099: WHEN NO_DATA_FOUND THEN
1100: -- Bug:5438341 PUOM in interface table is a translated value
1101: SELECT uom_code, unit_of_measure
1102: INTO l_Primary_UOM_Code, l_base_primary_UOM
1103: FROM mtl_units_of_measure_tl
1104: WHERE language = USERENV('LANG')
1105: AND unit_of_measure_tl = l_Primary_Unit_of_Measure;
1106:
1107: END;

Line 2100: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl

2096: ELSE
2097: l_Primary_Unit_of_Measure := uom_default;
2098: END IF;
2099: END IF;
2100: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl
2101: SELECT uom_code
2102: INTO l_Primary_UOM_Code
2103: FROM mtl_all_primary_uoms_vv
2104: WHERE inventory_item_id = 0

Line 2109: FROM mtl_units_of_measure_tl

2105: AND unit_of_measure = l_Primary_Unit_of_Measure;--Bug:3775854*/
2106:
2107: SELECT uom_code
2108: INTO l_Primary_UOM_Code
2109: FROM mtl_units_of_measure_tl
2110: WHERE language = USERENV('LANG')
2111: AND unit_of_measure = l_Primary_Unit_of_Measure;
2112: -- AND unit_of_measure_tl = l_Primary_Unit_of_Measure; -Bug5260388
2113: --Bug 5192495 use unit_of_measure