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

1110: , mtl_material_transactions_temp mmtt
1111: , mtl_system_items_vl msik /* Bug 5581528 */
1112: , mtl_parameters mp
1113: , mtl_txn_request_lines mtrl
1114: , mtl_secondary_inventories msi
1115: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1116: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1117: AND mp.organization_id = wdt.organization_id
1118: AND mmtt.organization_id = msik.organization_id

Line 1221: , mtl_secondary_inventories msi

1217: , mtl_material_transactions_temp mmtt
1218: , mtl_system_items_vl msik /* Bug 5581528 */
1219: , mtl_parameters mp
1220: , mtl_txn_request_lines mtrl
1221: , mtl_secondary_inventories msi
1222: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1223: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1224: AND mp.organization_id = wdt.organization_id
1225: AND mmtt.organization_id = msik.organization_id

Line 1489: , mtl_secondary_inventories msi

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

Line 2337: mtl_secondary_inventories msi,

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