DBA Data[Home] [Help]

APPS.POA_DBI_UOM_PKG dependencies on MTL_SYSTEM_ITEMS

Line 129: ,mtl_system_items item

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;
133: else

Line 274: from mtl_system_items

270:
271: if(p_item_id is not null) then
272: select primary_unit_of_measure
273: into l_base_uom
274: from mtl_system_items
275: where inventory_item_id = p_item_id
276: and organization_id = p_org_id;
277: else
278: l_base_uom := p_from_unit_of_measure;