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 2218: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */

2214: RAISE fnd_api.g_exc_error;
2215: END;
2216: END IF;
2217:
2218: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */
2219: BEGIN
2220: SELECT 1
2221: INTO l_item_sub
2222: FROM mtl_item_sub_inventories

Line 2222: FROM mtl_item_sub_inventories

2218: /* Check if an entry exists in MTL_ITEM_SUB_INVENTORIES table for the item passed */
2219: BEGIN
2220: SELECT 1
2221: INTO l_item_sub
2222: FROM mtl_item_sub_inventories
2223: WHERE inventory_item_id = l_inventory_item_id
2224: AND secondary_inventory = p_subinventory_code
2225: AND organization_id = l_organization_id;
2226: EXCEPTION

Line 2228: INSERT INTO mtl_item_sub_inventories

2224: AND secondary_inventory = p_subinventory_code
2225: AND organization_id = l_organization_id;
2226: EXCEPTION
2227: WHEN NO_DATA_FOUND THEN
2228: INSERT INTO mtl_item_sub_inventories
2229: (
2230: inventory_item_id
2231: , organization_id
2232: , secondary_inventory