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_LOC_WMS_PUB dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2122: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */

2118: RAISE fnd_api.g_exc_error;
2119: END;
2120: END IF;
2121:
2122: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */
2123: BEGIN
2124: SELECT 1
2125: INTO l_item_sub
2126: FROM mtl_item_sub_inventories

Line 2126: FROM mtl_item_sub_inventories

2122: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */
2123: BEGIN
2124: SELECT 1
2125: INTO l_item_sub
2126: FROM mtl_item_sub_inventories
2127: WHERE inventory_item_id = l_inventory_item_id
2128: AND secondary_inventory = p_subinventory_code
2129: AND organization_id = l_organization_id;
2130: EXCEPTION

Line 2132: INSERT INTO mtl_item_sub_inventories

2128: AND secondary_inventory = p_subinventory_code
2129: AND organization_id = l_organization_id;
2130: EXCEPTION
2131: WHEN NO_DATA_FOUND THEN
2132: INSERT INTO mtl_item_sub_inventories
2133: (
2134: inventory_item_id
2135: , organization_id
2136: , secondary_inventory