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 489: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub

485: , mmtt.inventory_item_id inventory_item_id
486: , mmtt.cartonization_id cartonization_id
487: , mmtt.allocated_lpn_id allocated_lpn_id
488: , mmtt.serial_allocated_flag serial_allocated_flag
489: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
490: WHERE wdt.person_id = p_sign_on_emp_id
491: AND wdt.organization_id = p_sign_on_org_id
492: AND wdt.status <= 3
493: AND (wdt.task_type IN (1, 4, 5, 6))

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

536: , mmtt.inventory_item_id inventory_item_id
537: , mmtt.cartonization_id cartonization_id
538: , mmtt.allocated_lpn_id allocated_lpn_id
539: , mmtt.serial_allocated_flag serial_allocated_flag
540: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
541: WHERE wdt.person_id = p_sign_on_emp_id
542: AND wdt.organization_id = p_sign_on_org_id
543: AND wdt.status <= 3
544: AND (wdt.task_type IN (1, 4, 5, 6))

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

587: , mmtt.inventory_item_id inventory_item_id
588: , mmtt.cartonization_id cartonization_id
589: , mmtt.allocated_lpn_id allocated_lpn_id
590: , mmtt.serial_allocated_flag serial_allocated_flag
591: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
592: WHERE wdt.person_id = p_sign_on_emp_id
593: AND wdt.organization_id = p_sign_on_org_id
594: AND wdt.status <= 3
595: AND (wdt.task_type IN (1, 4, 5, 6))

Line 1750: , mtl_item_locations mil

1746: , 0 operation_seq_num
1747: , mmtt.transfer_to_location --Bug#2756609
1748: FROM mtl_material_transactions_temp mmtt
1749: , mtl_secondary_inventories msi
1750: , mtl_item_locations mil
1751: , wms_dispatched_tasks wdt
1752: , mtl_system_items_vl msik /* Bug 5581528 */
1753: WHERE mmtt.organization_id = p_organization_id
1754: AND mmtt.transfer_lpn_id = p_transfer_lpn_id

Line 2564: mtl_item_locations mil

2560: FROM (SELECT wdt.task_id, mmtt.transaction_temp_id, wdt.task_type
2561: FROM wms_dispatched_tasks wdt,
2562: mtl_material_transactions_temp mmtt,
2563: mtl_secondary_inventories msi,
2564: mtl_item_locations mil
2565: WHERE wdt.person_id = p_employee_id
2566: AND wdt.organization_id = p_organization_id
2567: AND wdt.task_type = 1 -- Picking
2568: AND wdt.status = 3

Line 2609: mtl_item_locations mil

2605: FROM (select wdt.task_id, mmtt.transaction_temp_id, wdt.task_type
2606: FROM wms_dispatched_tasks wdt,
2607: mtl_material_transactions_temp mmtt,
2608: mtl_secondary_inventories msi,
2609: mtl_item_locations mil
2610: WHERE wdt.person_id = p_employee_id
2611: AND wdt.organization_id = p_organization_id
2612: AND wdt.task_type = 1 -- Picking
2613: AND wdt.status = 3

Line 2645: mtl_item_locations mil

2641: wdt.task_type
2642: FROM wms_dispatched_tasks wdt ,
2643: mtl_material_transactions_temp mmtt,
2644: mtl_secondary_inventories msi ,
2645: mtl_item_locations mil
2646: WHERE wdt.person_id = p_employee_id
2647: AND wdt.organization_id = p_organization_id
2648: AND wdt.task_type = 1 -- Picking
2649: AND wdt.status = 3

Line 2692: mtl_item_locations mil

2688: wdt.task_type
2689: FROM wms_dispatched_tasks wdt ,
2690: mtl_material_transactions_temp mmtt,
2691: mtl_secondary_inventories msi ,
2692: mtl_item_locations mil
2693: WHERE wdt.person_id = p_employee_id
2694: AND wdt.organization_id = p_organization_id
2695: AND wdt.task_type = 1 -- Picking
2696: AND wdt.status = 3