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 74: FROM wms_license_plate_numbers wlpn1

70: , To_number(NULL) taskid
71: , wlpn1.lpn_context
72: , 'FALSE' is_bulk_pick
73: , 1 dummy_sort
74: FROM wms_license_plate_numbers wlpn1
75: WHERE wlpn1.license_plate_number LIKE p_concat_segments
76: START WITH
77: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
78: FROM mtl_material_transactions_temp mmtt,

Line 80: wms_license_plate_numbers wlpn2

76: START WITH
77: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
78: FROM mtl_material_transactions_temp mmtt,
79: wms_dispatched_tasks wdt,
80: wms_license_plate_numbers wlpn2
81: WHERE l_wms_po_j_or_higher = 1
82: AND mmtt.organization_id = p_organization_id
83: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
84: AND wdt.organization_id = p_organization_id

Line 148: , wms_license_plate_numbers l

144: , 2 dummy_sort
145: FROM wms_dispatched_tasks w
146: , mtl_material_transactions_temp m
147: , mtl_system_items_kfv i
148: , wms_license_plate_numbers l
149: , mtl_txn_request_lines mtrl
150: WHERE w.person_id = p_user_id
151: AND w.organization_id = p_organization_id
152: AND w.status = 4

Line 195: , wms_license_plate_numbers l

191: , 3 dummy_sort
192: FROM wms_dispatched_tasks w
193: , mtl_material_transactions_temp m
194: , mtl_system_items_kfv i
195: , wms_license_plate_numbers l
196: WHERE w.person_id = p_user_id
197: AND w.organization_id = p_organization_id
198: AND w.status = 4
199: AND w.transaction_temp_id = m.transaction_temp_id

Line 271: , wms_license_plate_numbers l

267: , 2 dummy_sort
268: FROM wms_dispatched_tasks w
269: , mtl_material_transactions_temp m
270: , mtl_system_items_kfv i
271: , wms_license_plate_numbers l
272: , mtl_txn_request_lines mtrl
273: , wms_license_plate_numbers wlpn2
274: WHERE w.person_id = p_user_id
275: AND w.organization_id = p_organization_id

Line 273: , wms_license_plate_numbers wlpn2

269: , mtl_material_transactions_temp m
270: , mtl_system_items_kfv i
271: , wms_license_plate_numbers l
272: , mtl_txn_request_lines mtrl
273: , wms_license_plate_numbers wlpn2
274: WHERE w.person_id = p_user_id
275: AND w.organization_id = p_organization_id
276: AND w.status = 4
277: AND w.transaction_temp_id = m.transaction_temp_id

Line 285: --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)

281: AND w.task_type IN (1,4,5)
282: AND l.outermost_lpn_id = wlpn2.lpn_id --12984304
283: AND l.lpn_id = m.transfer_lpn_id --12984304
284: AND l.lpn_id <> l.outermost_lpn_id --12984304
285: --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)
286: AND m.move_order_line_id = mtrl.line_id (+)
287: AND (m.parent_line_id IS NULL
288: OR
289: (m.parent_line_id IS NOT NULL

Line 314: FROM wms_license_plate_numbers wlpn1

310: , To_number(NULL) taskid
311: , wlpn1.lpn_context
312: , 'FALSE' is_bulk_pick
313: , 1 dummy_sort
314: FROM wms_license_plate_numbers wlpn1
315: WHERE wlpn1.license_plate_number LIKE p_concat_segments
316: START WITH
317: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
318: FROM mtl_material_transactions_temp mmtt,

Line 320: wms_license_plate_numbers wlpn2

316: START WITH
317: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
318: FROM mtl_material_transactions_temp mmtt,
319: wms_dispatched_tasks wdt,
320: wms_license_plate_numbers wlpn2
321: WHERE l_wms_po_j_or_higher = 1
322: AND (p_page_type IS NULL OR p_page_type <> 'MANUAL_UNLOAD')
323: AND mmtt.organization_id = p_organization_id
324: AND mmtt.transaction_temp_id = wdt.transaction_temp_id

Line 383: , wms_license_plate_numbers l

379: , 1 dummy_sort
380: FROM wms_dispatched_tasks w
381: , mtl_material_transactions_temp m
382: , mtl_system_items_kfv i
383: , wms_license_plate_numbers l
384: , mtl_txn_request_lines mtrl
385: WHERE l_wms_po_j_or_higher <> 1
386: AND w.person_id = p_user_id
387: AND w.organization_id = p_organization_id

Line 456: , wms_license_plate_numbers l

452: , 2 dummy_sort
453: FROM wms_dispatched_tasks w
454: , mtl_material_transactions_temp m
455: , mtl_system_items_kfv i
456: , wms_license_plate_numbers l
457: , mtl_txn_request_lines mtrl
458: WHERE w.person_id = p_user_id
459: AND w.organization_id = p_organization_id
460: AND w.status = 4

Line 553: , wms_license_plate_numbers l

549: , 3 dummy_sort
550: FROM wms_dispatched_tasks w
551: , mtl_material_transactions_temp m
552: , mtl_system_items_kfv i
553: , wms_license_plate_numbers l
554: , mtl_txn_request_lines mtrl
555: WHERE w.person_id = p_user_id
556: AND w.organization_id = p_organization_id
557: AND w.status = 4

Line 635: , wms_license_plate_numbers l

631: , 4 dummy_sort
632: FROM wms_dispatched_tasks w
633: , mtl_material_transactions_temp m
634: , mtl_system_items_kfv i
635: , wms_license_plate_numbers l
636: , mtl_txn_request_lines mtrl
637: WHERE w.person_id = p_user_id
638: AND w.organization_id = p_organization_id
639: AND w.status = 4

Line 733: , wms_license_plate_numbers l

729: , 5 dummy_sort
730: FROM wms_dispatched_tasks w
731: , mtl_material_transactions_temp m
732: , mtl_system_items_kfv i
733: , wms_license_plate_numbers l
734: , mtl_txn_request_lines mtrl
735: WHERE w.person_id = p_user_id
736: AND w.organization_id = p_organization_id
737: AND w.status = 4

Line 852: , wms_license_plate_numbers l

848: , 2 dummy_sort
849: FROM wms_dispatched_tasks w
850: , mtl_material_transactions_temp m
851: , mtl_system_items_kfv i
852: , wms_license_plate_numbers l
853: , mtl_txn_request_lines mtrl
854: , wms_license_plate_numbers wlpn2
855: WHERE w.person_id = p_user_id
856: AND w.organization_id = p_organization_id

Line 854: , wms_license_plate_numbers wlpn2

850: , mtl_material_transactions_temp m
851: , mtl_system_items_kfv i
852: , wms_license_plate_numbers l
853: , mtl_txn_request_lines mtrl
854: , wms_license_plate_numbers wlpn2
855: WHERE w.person_id = p_user_id
856: AND w.organization_id = p_organization_id
857: AND w.status = 4
858: AND w.transaction_temp_id = m.transaction_temp_id

Line 866: --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)

862: AND w.task_type IN (1,4,5,DECODE(p_page_type , 'MANUAL_UNLOAD' , 6))--13807883
863: AND l.outermost_lpn_id = wlpn2.lpn_id --12984304
864: AND m.transfer_lpn_id = l.lpn_id --12984304
865: AND l.lpn_id <> l.outermost_lpn_id --12984304
866: --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)
867: AND m.move_order_line_id = mtrl.line_id (+)
868: AND (m.parent_line_id IS NULL
869: OR
870: (m.parent_line_id IS NOT NULL

Line 901: , wms_license_plate_numbers l

897: , 6 dummy_sort
898: FROM wms_dispatched_tasks w
899: , mtl_material_transactions_temp m
900: , mtl_system_items_kfv i
901: , wms_license_plate_numbers l
902: WHERE w.person_id = p_user_id
903: AND w.organization_id = p_organization_id
904: AND w.status = 4
905: AND w.transaction_temp_id = m.transaction_temp_id

Line 939: FROM wms_license_plate_numbers wlpn1

935: , To_number(NULL) taskid
936: , wlpn1.lpn_context
937: , 'FALSE' is_bulk_pick
938: , 1 dummy_sort
939: FROM wms_license_plate_numbers wlpn1
940: WHERE wlpn1.license_plate_number LIKE p_concat_segments
941: and lpn_context IN (3,6,7)
942: and organization_id=p_Organization_Id
943: and (p_page_type = 'MANUAL_UNLOAD' and p_unload_receiving='YES')