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 3360: , mtl_item_locations mil

3356: , 1
3357: ) parent_line_id
3358: FROM mtl_material_transactions_temp mmtt
3359: , mtl_secondary_inventories msi
3360: , mtl_item_locations mil
3361: , mtl_txn_request_lines mtrl
3362: , wsh_delivery_details_ob_grp_v wdd
3363: , wsh_delivery_assignments_v wda
3364: WHERE mmtt.organization_id = p_org_id

Line 3406: , mtl_item_locations mil

3402: , 1
3403: ) parent_line_id
3404: FROM mtl_material_transactions_temp mmtt
3405: , mtl_secondary_inventories msi
3406: , mtl_item_locations mil
3407: , mtl_txn_request_lines mtrl
3408: , mtl_txn_request_headers mtrh
3409: WHERE mmtt.organization_id = p_org_id
3410: AND mmtt.transfer_lpn_id = p_lpn_id

Line 3450: , mtl_item_locations mil

3446: , 1
3447: ) parent_line_id
3448: FROM mtl_material_transactions_temp mmtt
3449: , mtl_secondary_inventories msi
3450: , mtl_item_locations mil
3451: , mtl_txn_request_lines mtrl
3452: , mtl_txn_request_headers mtrh
3453: WHERE mmtt.organization_id = p_org_id
3454: AND mmtt.transfer_lpn_id = p_lpn_id

Line 9178: FROM mtl_item_locations mil

9174: IF p_drop_lpn IS NULL OR p_drop_lpn = 0 THEN
9175: BEGIN
9176: SELECT mil.inventory_location_type
9177: INTO l_to_loc_type
9178: FROM mtl_item_locations mil
9179: WHERE mil.organization_id = p_organization_id
9180: AND mil.subinventory_code = p_subinventory
9181: AND mil.inventory_location_id = p_loc_id;
9182: IF (l_debug = 1) THEN print_debug('l_to_loc_type' || l_to_loc_type , l_api_name); END IF;