DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PUB dependencies on MTL_SYSTEM_ITEMS

Line 192: FROM mtl_system_items

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

Line 196: l_item_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

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