Line 1046: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id)
1042: END IF;
1043:
1044: if (p_loc_id IS NOT NULL) THEN
1045: begin 1046: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id) 1047: INTO l_loc_uom, l_uom_string
1048: FROM mtl_item_locations
1049: WHERE organization_id = p_org_id
1050: AND subinventory_code = p_sub_code
Line 1069: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,
1065: end if;
1066:
1067: if (l_loc_uom IS NULL) THEN
1068: begin 1069: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, 1070: p_org_Id,
1071: p_item_Id)
1072: INTO l_loc_uom, l_uom_string
1073: FROM MTL_SECONDARY_INVENTORIES