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_SECONDARY_INVENTORIES

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 1359: , mtl_secondary_inventories msi

1355: , mtl_material_transactions_temp mmtt
1356: , mtl_system_items_vl msik /* Bug 5581528 */
1357: , mtl_parameters mp
1358: , mtl_txn_request_lines mtrl
1359: , mtl_secondary_inventories msi
1360: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1361: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1362: AND mp.organization_id = wdt.organization_id
1363: AND mmtt.organization_id = msik.organization_id

Line 1481: , mtl_secondary_inventories msi

1477: , mtl_material_transactions_temp mmtt
1478: , mtl_system_items_vl msik /* Bug 5581528 */
1479: , mtl_parameters mp
1480: , mtl_txn_request_lines mtrl
1481: , mtl_secondary_inventories msi
1482: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1483: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1484: AND mp.organization_id = wdt.organization_id
1485: AND mmtt.organization_id = msik.organization_id

Line 1749: , mtl_secondary_inventories msi

1745: , 0 repetitive_schedule_id
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

Line 2563: mtl_secondary_inventories msi,

2559: INTO x_task_id, x_transaction_temp_id, x_task_type_id
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

Line 2608: mtl_secondary_inventories msi,

2604: INTO x_task_id, x_transaction_temp_id, x_task_type_id
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

Line 2644: mtl_secondary_inventories msi ,

2640: mmtt.transaction_temp_id,
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

Line 2691: mtl_secondary_inventories msi ,

2687: mmtt.transaction_temp_id,
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