APPS.POA_DBI_UOM_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 105: from mtl_units_of_measure uom

101: IF (p_from_uom_code IS NULL) THEN
102: -- Get uom_class and base_uom_flag using unit_of_measure
103: select uom.UOM_CLASS,uom.BASE_UOM_FLAG
104: into l_line_uom_class,l_line_base_uom
105: from mtl_units_of_measure uom
106: where uom.UNIT_OF_MEASURE = p_from_unit_of_measure;
107: ELSE
108: -- Get uom_class and base_uom_flag using uom_code
109: SELECT uom.uom_class

Line 113: FROM mtl_units_of_measure uom

109: SELECT uom.uom_class
110: , uom.base_uom_flag
111: INTO l_line_uom_class
112: , l_line_base_uom
113: FROM mtl_units_of_measure uom
114: WHERE uom.uom_code = p_from_uom_code ;
115: END IF ;
116: exception
117: when no_data_found then

Line 128: from mtl_units_of_measure uom

124: begin
125: if(p_item_primary_uom_code is null) then
126: select uom.UOM_CLASS, uom.base_uom_flag, item.primary_uom_code
127: into l_item_uom_class, l_item_base_uom, l_item_primary_uom_code
128: from mtl_units_of_measure uom
129: ,mtl_system_items item
130: where uom.UOM_CODE = item.PRIMARY_UOM_CODE
131: and item.inventory_item_id = p_item_id
132: and item.organization_id = p_org_id;

Line 136: from mtl_units_of_measure

132: and item.organization_id = p_org_id;
133: else
134: select uom_class, base_uom_flag
135: into l_item_uom_class, l_item_base_uom
136: from mtl_units_of_measure
137: where uom_code = p_item_primary_uom_code;
138: end if;
139: exception
140: when no_data_found then