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

Line 327: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

323: , mmtt.inventory_item_id inventory_item_id
324: , mmtt.cartonization_id cartonization_id
325: , mmtt.allocated_lpn_id allocated_lpn_id
326: , mmtt.serial_allocated_flag serial_allocated_flag
327: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
328: WHERE wdt.person_id = p_sign_on_emp_id
329: AND wdt.organization_id = p_sign_on_org_id
330: AND wdt.status <= 3
331: AND (wdt.task_type IN (1, 4, 5, 6))

Line 378: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

374: , mmtt.inventory_item_id inventory_item_id
375: , mmtt.cartonization_id cartonization_id
376: , mmtt.allocated_lpn_id allocated_lpn_id
377: , mmtt.serial_allocated_flag serial_allocated_flag
378: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
379: WHERE wdt.person_id = p_sign_on_emp_id
380: AND wdt.organization_id = p_sign_on_org_id
381: AND wdt.status <= 3
382: AND (wdt.task_type IN (1, 4, 5, 6))

Line 429: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

425: , mmtt.inventory_item_id inventory_item_id
426: , mmtt.cartonization_id cartonization_id
427: , mmtt.allocated_lpn_id allocated_lpn_id
428: , mmtt.serial_allocated_flag serial_allocated_flag
429: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
430: WHERE wdt.person_id = p_sign_on_emp_id
431: AND wdt.organization_id = p_sign_on_org_id
432: AND wdt.status <= 3
433: AND (wdt.task_type IN (1, 4, 5, 6))

Line 1490: , mtl_item_locations mil

1486: , 0 operation_seq_num
1487: , mmtt.transfer_to_location --Bug#2756609
1488: FROM mtl_material_transactions_temp mmtt
1489: , mtl_secondary_inventories msi
1490: , mtl_item_locations mil
1491: , wms_dispatched_tasks wdt
1492: , mtl_system_items_vl msik /* Bug 5581528 */
1493: WHERE mmtt.organization_id = p_organization_id
1494: AND mmtt.transfer_lpn_id = p_transfer_lpn_id

Line 2338: mtl_item_locations mil

2334: FROM (select wdt.task_id, mmtt.transaction_temp_id, wdt.task_type
2335: FROM wms_dispatched_tasks wdt,
2336: mtl_material_transactions_temp mmtt,
2337: mtl_secondary_inventories msi,
2338: mtl_item_locations mil
2339: WHERE wdt.person_id = p_employee_id
2340: AND wdt.organization_id = p_organization_id
2341: AND wdt.task_type = 1 -- Picking
2342: AND wdt.status = 3