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.INV_LOT_API_PUB dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 11000: FROM mtl_lot_uom_class_conversions

10996: l_from_UOM_code VARCHAR2(50);
10997:
10998: CURSOR c_check_exists(p_org_id NUMBER,p_to_UOM VARCHAR2 ,p_from_UOM VARCHAR2) IS
10999: SELECT 1
11000: FROM mtl_lot_uom_class_conversions
11001: WHERE organization_id = p_org_id
11002: AND lot_number = p_lot_number
11003: AND inventory_item_id = p_inventory_item_id
11004: AND TO_UOM_CODE=p_to_UOM

Line 11214: --this procedure inserts data in MTL_LOT_UOM_CLASS_CONVERSIONS table

11210: END IF;
11211: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11212: END lot_UOM_conv_OrgTxf;
11213:
11214: --this procedure inserts data in MTL_LOT_UOM_CLASS_CONVERSIONS table
11215: --Bug#10202198
11216:
11217: PROCEDURE create_lot_UOM_conv_orgtxf (
11218: p_organization_id IN NUMBER

Line 11244: INSERT INTO MTL_LOT_UOM_CLASS_CONVERSIONS(

11240: OPEN GET_CONV_SEQ;
11241: FETCH GET_CONV_SEQ INTO l_conv_seq;
11242: CLOSE GET_CONV_SEQ;
11243:
11244: INSERT INTO MTL_LOT_UOM_CLASS_CONVERSIONS(
11245: CONVERSION_ID,
11246: LOT_NUMBER,
11247: ORGANIZATION_ID,
11248: INVENTORY_ITEM_ID,

Line 11291: FROM MTL_LOT_UOM_CLASS_CONVERSIONS

11287: , REQUEST_ID
11288: , PROGRAM_APPLICATION_ID
11289: , PROGRAM_ID
11290: , PROGRAM_UPDATE_DATE
11291: FROM MTL_LOT_UOM_CLASS_CONVERSIONS
11292: where LOT_NUMBER=p_lot_number
11293: and ORGANIZATION_ID=p_xfr_organization_id
11294: and INVENTORY_ITEM_ID=p_inventory_item_id
11295: AND TO_UOM_CODE=p_to_UOM_code