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 8743: FROM mtl_secondary_inventories

8739: -- bug 2398247
8740: -- verify if sub is active
8741: SELECT COUNT(*)
8742: INTO l_sub_active
8743: FROM mtl_secondary_inventories
8744: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
8745: AND organization_id = p_org_id
8746: AND secondary_inventory_name = l_sub;
8747:

Line 13517: FROM mtl_secondary_inventories

13513:
13514: IF l_xfr_sub IS NOT NULL THEN
13515: SELECT lpn_controlled_flag
13516: INTO l_lpn_controlled_flag
13517: FROM mtl_secondary_inventories
13518: WHERE organization_id = p_organization_id
13519: AND secondary_inventory_name = l_xfr_sub;
13520: END IF;
13521:

Line 13578: , mtl_secondary_inventories msi

13574: FROM DUAL
13575: WHERE EXISTS
13576: ( SELECT 'x'
13577: FROM mtl_material_transactions_temp mmtt
13578: , mtl_secondary_inventories msi
13579: WHERE mmtt.transaction_temp_id <> p_temp_id
13580: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
13581: AND msi.organization_id = p_organization_id
13582: AND msi.secondary_inventory_name = mmtt.transfer_subinventory