DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PUB dependencies on MTL_SYSTEM_ITEMS

Line 190: FROM mtl_system_items

186: ======================================*/
187:
188: CURSOR get_item_uom IS
189: SELECT primary_uom_code
190: FROM mtl_system_items
191: WHERE organization_id = p_lot_uom_conv_rec.organization_id
192: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
193:
194: l_item_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

Line 194: l_item_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

190: FROM mtl_system_items
191: WHERE organization_id = p_lot_uom_conv_rec.organization_id
192: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
193:
194: l_item_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
195:
196:
197: /*======================================
198: Cursor to get uom_class for a given