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_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 413: SELECT COUNT(1) INTO l_count FROM MTL_SECONDARY_INVENTORIES MSI

409: l_count := 0;
410:
411: IF (p_mtl_trx_tbl(i).subinventory_code IS NOT NULL) THEN
412: BEGIN
413: SELECT COUNT(1) INTO l_count FROM MTL_SECONDARY_INVENTORIES MSI
414: WHERE MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
415: AND MSI.SECONDARY_INVENTORY_NAME = p_mtl_trx_tbl(i).subinventory_code
416: AND TRUNC(p_mtl_trx_tbl(i).transaction_date) <= NVL(MSI.DISABLE_DATE,p_mtl_trx_tbl(i).transaction_date + 1);
417: EXCEPTION

Line 444: SELECT null FROM MTL_SECONDARY_INVENTORIES MTSI,

440:
441: BEGIN
442: SELECT 1 INTO l_count FROM dual WHERE exists
443: (
444: SELECT null FROM MTL_SECONDARY_INVENTORIES MTSI,
445: MTL_SYSTEM_ITEMS MSI
446: WHERE MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
447: AND MSI.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id
448: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1