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_PUTAWAY_UTILS dependencies on MTL_ITEM_LOCATIONS

Line 2764: --,mtl_item_locations milk

2760: --R12 End
2761: FROM mtl_material_transactions_temp mmtt
2762: ,mtl_txn_request_lines mtrl
2763: ,wms_dispatched_tasks wdt
2764: --,mtl_item_locations milk
2765: ,mtl_system_items_kfv msik
2766: ,mtl_txn_request_headers mtrh
2767: ,wms_license_plate_numbers wln
2768: --,mtl_secondary_inventories msi

Line 3666: ,mtl_item_locations_kfv milk

3662: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
3663: FROM mtl_material_transactions_temp mmtt
3664: ,wms_license_plate_numbers wlpn
3665: ,mtl_secondary_inventories msi
3666: ,mtl_item_locations_kfv milk
3667: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
3668: AND mmtt.cartonization_id = wlpn.lpn_id(+)
3669: AND NVL(mmtt.transfer_to_location,mmtt.locator_id) = milk.inventory_location_id(+)
3670: AND msi.organization_id(+) = mmtt.organization_id

Line 12065: mtl_item_locations

12061: INTO
12062: l_into_lpn_project_id
12063: ,l_into_lpn_task_id
12064: FROM
12065: mtl_item_locations
12066: WHERE
12067: inventory_location_id = l_into_lpn_loc_id;
12068: ELSE -- context is 2 or 3
12069: SELECT