eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_SYSTEM_ITEMS

Line 361: FROM MTL_SYSTEM_ITEMS

357: CONV_GET_ERR EXCEPTION;
358:
359: CURSOR get_uom_codes IS
360: SELECT primary_uom_code, secondary_uom_code
361: FROM MTL_SYSTEM_ITEMS
362: WHERE
363: organization_id = p_lot_uom_conv_rec.organization_id AND
364: inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
365:

Line 366: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

362: WHERE
363: organization_id = p_lot_uom_conv_rec.organization_id AND
364: inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
365:
366: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
367: l_secondary_uom MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%TYPE;
368:
369: /* Bug#5228919 added the following cursor to get the lot attributes
370: from mtl_lot_numbers table */

Line 367: l_secondary_uom MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%TYPE;

363: organization_id = p_lot_uom_conv_rec.organization_id AND
364: inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
365:
366: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
367: l_secondary_uom MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%TYPE;
368:
369: /* Bug#5228919 added the following cursor to get the lot attributes
370: from mtl_lot_numbers table */
371: CURSOR c_get_attr IS