APPS.INVPUTLI dependencies on MTL_UNITS_OF_MEASURE

Line 1078: l_base_primary_UOM mtl_units_of_measure_tl.unit_of_measure%TYPE;

1074: l_created_by NUMBER;
1075: LOGGING_ERR EXCEPTION;
1076: l_Primary_Unit_of_Measure VARCHAR2(25);
1077: l_Primary_UOM_Code VARCHAR2(3);
1078: l_base_primary_UOM mtl_units_of_measure_tl.unit_of_measure%TYPE;
1079: BEGIN
1080:
1081: INVPUTLI.info('INVPUTLI: inside assign_master_defaults');
1082:

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

1089: FROM MTL_SYSTEM_ITEMS_INTERFACE
1090: WHERE rowid = p_rowid;
1091:
1092: IF (l_Primary_UOM_Code IS NULL AND l_Primary_Unit_of_Measure IS NOT NULL) THEN
1093: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl
1094: SELECT uom_code INTO l_Primary_UOM_Code
1095: FROM mtl_all_primary_uoms_vv
1096: WHERE inventory_item_id = 0
1097: AND unit_of_measure_tl = l_Primary_Unit_of_Measure;*/

Line 1101: FROM mtl_units_of_measure_tl

1097: AND unit_of_measure_tl = l_Primary_Unit_of_Measure;*/
1098: BEGIN
1099: SELECT uom_code
1100: INTO l_Primary_UOM_Code
1101: FROM mtl_units_of_measure_tl
1102: WHERE language = USERENV('LANG')
1103: AND unit_of_measure = l_Primary_Unit_of_Measure;
1104: -- AND unit_of_measure_tl = l_Primary_Unit_of_Measure; -Bug5260388
1105: EXCEPTION

Line 1110: FROM mtl_units_of_measure_tl

1106: WHEN NO_DATA_FOUND THEN
1107: -- Bug:5438341 PUOM in interface table is a translated value
1108: SELECT uom_code, unit_of_measure
1109: INTO l_Primary_UOM_Code, l_base_primary_UOM
1110: FROM mtl_units_of_measure_tl
1111: WHERE language = USERENV('LANG')
1112: AND unit_of_measure_tl = l_Primary_Unit_of_Measure;
1113:
1114: END;

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

2171: ELSE
2172: l_Primary_Unit_of_Measure := uom_default;
2173: END IF;
2174: END IF;
2175: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl
2176: SELECT uom_code
2177: INTO l_Primary_UOM_Code
2178: FROM mtl_all_primary_uoms_vv
2179: WHERE inventory_item_id = 0

Line 2184: FROM mtl_units_of_measure_tl

2180: AND unit_of_measure = l_Primary_Unit_of_Measure;--Bug:3775854*/
2181:
2182: SELECT uom_code
2183: INTO l_Primary_UOM_Code
2184: FROM mtl_units_of_measure_tl
2185: WHERE language = USERENV('LANG')
2186: AND unit_of_measure = l_Primary_Unit_of_Measure;
2187: -- AND unit_of_measure_tl = l_Primary_Unit_of_Measure; -Bug5260388
2188: --Bug 5192495 use unit_of_measure

Line 2193: FROM mtl_units_of_measure

2189: ELSE
2190: IF ( l_Primary_Unit_of_Measure IS NULL ) THEN
2191: SELECT unit_of_measure --Bug:3775854 --Bug 5192495 Use of unit_of_measure
2192: INTO l_Primary_Unit_of_Measure
2193: FROM mtl_units_of_measure
2194: WHERE uom_code = l_Primary_UOM_Code;
2195: END IF;
2196: END IF;
2197: