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

Line 3547: , mtl_item_locations mil

3543: , 1
3544: ) parent_line_id
3545: FROM mtl_material_transactions_temp mmtt
3546: , mtl_secondary_inventories msi
3547: , mtl_item_locations mil
3548: , mtl_txn_request_lines mtrl
3549: , wsh_delivery_details_ob_grp_v wdd
3550: , wsh_delivery_assignments_v wda
3551: WHERE mmtt.organization_id = p_org_id

Line 3595: , mtl_item_locations mil

3591: , 1
3592: ) parent_line_id
3593: FROM mtl_material_transactions_temp mmtt
3594: , mtl_secondary_inventories msi
3595: , mtl_item_locations mil
3596: , mtl_txn_request_lines mtrl
3597: , mtl_txn_request_headers mtrh
3598: , wms_dispatched_tasks wdt -- Added for bug 12853197
3599: WHERE mmtt.organization_id = p_org_id

Line 3643: , mtl_item_locations mil

3639: , 1
3640: ) parent_line_id
3641: FROM mtl_material_transactions_temp mmtt
3642: , mtl_secondary_inventories msi
3643: , mtl_item_locations mil
3644: , mtl_txn_request_lines mtrl
3645: , mtl_txn_request_headers mtrh
3646: WHERE mmtt.organization_id = p_org_id
3647: AND mmtt.transfer_lpn_id = p_lpn_id

Line 9497: FROM mtl_item_locations mil

9493: IF p_drop_lpn IS NULL OR p_drop_lpn = 0 THEN
9494: BEGIN
9495: SELECT mil.inventory_location_type
9496: INTO l_to_loc_type
9497: FROM mtl_item_locations mil
9498: WHERE mil.organization_id = p_organization_id
9499: AND mil.subinventory_code = p_subinventory
9500: AND mil.inventory_location_id = p_loc_id;
9501: IF (l_debug = 1) THEN print_debug('l_to_loc_type' || l_to_loc_type , l_api_name); END IF;