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.WMS_TASK_LOAD dependencies on MTL_SECONDARY_INVENTORIES

Line 7218: FROM mtl_secondary_inventories

7214: -- bug 2398247
7215: -- verify if sub is active
7216: SELECT COUNT(*)
7217: INTO l_sub_active
7218: FROM mtl_secondary_inventories
7219: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
7220: AND organization_id = p_org_id
7221: AND secondary_inventory_name = l_sub;
7222:

Line 11243: FROM mtl_secondary_inventories

11239:
11240: IF l_xfr_sub IS NOT NULL THEN
11241: SELECT lpn_controlled_flag
11242: INTO l_lpn_controlled_flag
11243: FROM mtl_secondary_inventories
11244: WHERE organization_id = p_organization_id
11245: AND secondary_inventory_name = l_xfr_sub;
11246: END IF;
11247:

Line 11304: , mtl_secondary_inventories msi

11300: FROM DUAL
11301: WHERE EXISTS
11302: ( SELECT 'x'
11303: FROM mtl_material_transactions_temp mmtt
11304: , mtl_secondary_inventories msi
11305: WHERE mmtt.transaction_temp_id <> p_temp_id
11306: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
11307: AND msi.organization_id = p_organization_id
11308: AND msi.secondary_inventory_name = mmtt.transfer_subinventory