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_TASK_DISPATCH_LOV dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 67: FROM wms_license_plate_numbers wlpn1

63: , To_number(NULL) taskid
64: , wlpn1.lpn_context
65: , 'FALSE' is_bulk_pick
66: , 1 dummy_sort
67: FROM wms_license_plate_numbers wlpn1
68: WHERE wlpn1.license_plate_number LIKE p_concat_segments
69: START WITH
70: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
71: FROM mtl_material_transactions_temp mmtt,

Line 73: wms_license_plate_numbers wlpn2

69: START WITH
70: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
71: FROM mtl_material_transactions_temp mmtt,
72: wms_dispatched_tasks wdt,
73: wms_license_plate_numbers wlpn2
74: WHERE l_wms_po_j_or_higher = 1
75: AND mmtt.organization_id = p_organization_id
76: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
77: AND wdt.organization_id = p_organization_id

Line 141: , wms_license_plate_numbers l

137: , 2 dummy_sort
138: FROM wms_dispatched_tasks w
139: , mtl_material_transactions_temp m
140: , mtl_system_items_kfv i
141: , wms_license_plate_numbers l
142: , mtl_txn_request_lines mtrl
143: WHERE w.person_id = p_user_id
144: AND w.organization_id = p_organization_id
145: AND w.status = 4

Line 188: , wms_license_plate_numbers l

184: , 3 dummy_sort
185: FROM wms_dispatched_tasks w
186: , mtl_material_transactions_temp m
187: , mtl_system_items_kfv i
188: , wms_license_plate_numbers l
189: WHERE w.person_id = p_user_id
190: AND w.organization_id = p_organization_id
191: AND w.status = 4
192: AND w.transaction_temp_id = m.transaction_temp_id

Line 263: , wms_license_plate_numbers l

259: , 2 dummy_sort
260: FROM wms_dispatched_tasks w
261: , mtl_material_transactions_temp m
262: , mtl_system_items_kfv i
263: , wms_license_plate_numbers l
264: , mtl_txn_request_lines mtrl
265: WHERE w.person_id = p_user_id
266: AND w.organization_id = p_organization_id
267: AND w.status = 4

Line 273: AND l.lpn_id IN (SELECT DISTINCT(wlpn1.outermost_lpn_id) FROM wms_license_plate_numbers wlpn1 WHERE wlpn1.lpn_id = m.transfer_lpn_id AND wlpn1.lpn_id <> wlpn1.outermost_lpn_id)

269: AND m.organization_id = i.organization_id
270: AND m.inventory_item_id = i.inventory_item_id
271: AND m.organization_id = l.organization_id
272: AND w.task_type IN (1,4,5)
273: AND l.lpn_id IN (SELECT DISTINCT(wlpn1.outermost_lpn_id) FROM wms_license_plate_numbers wlpn1 WHERE wlpn1.lpn_id = m.transfer_lpn_id AND wlpn1.lpn_id <> wlpn1.outermost_lpn_id)
274: AND m.move_order_line_id = mtrl.line_id (+)
275: AND (m.parent_line_id IS NULL
276: OR
277: (m.parent_line_id IS NOT NULL

Line 300: FROM wms_license_plate_numbers wlpn1

296: , To_number(NULL) taskid
297: , wlpn1.lpn_context
298: , 'FALSE' is_bulk_pick
299: , 1 dummy_sort
300: FROM wms_license_plate_numbers wlpn1
301: WHERE wlpn1.license_plate_number LIKE p_concat_segments
302: START WITH
303: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
304: FROM mtl_material_transactions_temp mmtt,

Line 306: wms_license_plate_numbers wlpn2

302: START WITH
303: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
304: FROM mtl_material_transactions_temp mmtt,
305: wms_dispatched_tasks wdt,
306: wms_license_plate_numbers wlpn2
307: WHERE l_wms_po_j_or_higher = 1
308: AND (p_page_type IS NULL OR p_page_type <> 'MANUAL_UNLOAD')
309: AND mmtt.organization_id = p_organization_id
310: AND mmtt.transaction_temp_id = wdt.transaction_temp_id

Line 369: , wms_license_plate_numbers l

365: , 1 dummy_sort
366: FROM wms_dispatched_tasks w
367: , mtl_material_transactions_temp m
368: , mtl_system_items_kfv i
369: , wms_license_plate_numbers l
370: , mtl_txn_request_lines mtrl
371: WHERE l_wms_po_j_or_higher <> 1
372: AND w.person_id = p_user_id
373: AND w.organization_id = p_organization_id

Line 441: , wms_license_plate_numbers l

437: , 2 dummy_sort
438: FROM wms_dispatched_tasks w
439: , mtl_material_transactions_temp m
440: , mtl_system_items_kfv i
441: , wms_license_plate_numbers l
442: , mtl_txn_request_lines mtrl
443: WHERE w.person_id = p_user_id
444: AND w.organization_id = p_organization_id
445: AND w.status = 4

Line 537: , wms_license_plate_numbers l

533: , 3 dummy_sort
534: FROM wms_dispatched_tasks w
535: , mtl_material_transactions_temp m
536: , mtl_system_items_kfv i
537: , wms_license_plate_numbers l
538: , mtl_txn_request_lines mtrl
539: WHERE w.person_id = p_user_id
540: AND w.organization_id = p_organization_id
541: AND w.status = 4

Line 618: , wms_license_plate_numbers l

614: , 4 dummy_sort
615: FROM wms_dispatched_tasks w
616: , mtl_material_transactions_temp m
617: , mtl_system_items_kfv i
618: , wms_license_plate_numbers l
619: , mtl_txn_request_lines mtrl
620: WHERE w.person_id = p_user_id
621: AND w.organization_id = p_organization_id
622: AND w.status = 4

Line 715: , wms_license_plate_numbers l

711: , 5 dummy_sort
712: FROM wms_dispatched_tasks w
713: , mtl_material_transactions_temp m
714: , mtl_system_items_kfv i
715: , wms_license_plate_numbers l
716: , mtl_txn_request_lines mtrl
717: WHERE w.person_id = p_user_id
718: AND w.organization_id = p_organization_id
719: AND w.status = 4

Line 832: , wms_license_plate_numbers l

828: , 2 dummy_sort
829: FROM wms_dispatched_tasks w
830: , mtl_material_transactions_temp m
831: , mtl_system_items_kfv i
832: , wms_license_plate_numbers l
833: , mtl_txn_request_lines mtrl
834: WHERE w.person_id = p_user_id
835: AND w.organization_id = p_organization_id
836: AND w.status = 4

Line 842: AND l.lpn_id IN (SELECT DISTINCT(wlpn1.outermost_lpn_id) FROM wms_license_plate_numbers wlpn1 WHERE wlpn1.lpn_id = m.transfer_lpn_id AND wlpn1.lpn_id <> wlpn1.outermost_lpn_id)

838: AND m.organization_id = i.organization_id
839: AND m.inventory_item_id = i.inventory_item_id
840: AND m.organization_id = l.organization_id
841: AND w.task_type IN (1,4,5)
842: AND l.lpn_id IN (SELECT DISTINCT(wlpn1.outermost_lpn_id) FROM wms_license_plate_numbers wlpn1 WHERE wlpn1.lpn_id = m.transfer_lpn_id AND wlpn1.lpn_id <> wlpn1.outermost_lpn_id)
843: AND m.move_order_line_id = mtrl.line_id (+)
844: AND (m.parent_line_id IS NULL
845: OR
846: (m.parent_line_id IS NOT NULL

Line 877: , wms_license_plate_numbers l

873: , 6 dummy_sort
874: FROM wms_dispatched_tasks w
875: , mtl_material_transactions_temp m
876: , mtl_system_items_kfv i
877: , wms_license_plate_numbers l
878: WHERE w.person_id = p_user_id
879: AND w.organization_id = p_organization_id
880: AND w.status = 4
881: AND w.transaction_temp_id = m.transaction_temp_id