APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 71: FROM mtl_material_transactions_temp mmtt,

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,
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

Line 139: , mtl_material_transactions_temp m

135: , 'TRUE'
136: ) is_bulk_pick
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

Line 186: , mtl_material_transactions_temp m

182: , l.lpn_context
183: , 'FALSE' is_bulk_pick
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

Line 261: , mtl_material_transactions_temp m

257: , 'TRUE'
258: ) is_bulk_pick
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

Line 304: FROM mtl_material_transactions_temp mmtt,

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,
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')

Line 367: , mtl_material_transactions_temp m

363: , l.lpn_context
364: , 'FALSE' is_bulk_pick
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

Line 439: , mtl_material_transactions_temp m

435: , 'TRUE'
436: ) is_bulk_pick
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

Line 464: FROM mtl_material_transactions_temp m2

460: )
461: )
462: AND EXISTS
463: ( SELECT 'x'
464: FROM mtl_material_transactions_temp m2
465: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
466: AND m2.organization_id = m.organization_id
467: AND m2.content_lpn_id = m.transfer_lpn_id
468: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 535: , mtl_material_transactions_temp m

531: , 'TRUE'
532: ) is_bulk_pick
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

Line 616: , mtl_material_transactions_temp m

612: , 'TRUE'
613: ) is_bulk_pick
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

Line 642: FROM mtl_material_transactions_temp m2

638: )
639: AND m.lpn_id IS NOT NULL
640: AND EXISTS
641: ( SELECT 'x'
642: FROM mtl_material_transactions_temp m2
643: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
644: AND m2.organization_id = m.organization_id
645: AND m2.content_lpn_id = m.lpn_id
646: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 713: , mtl_material_transactions_temp m

709: , 'TRUE'
710: ) is_bulk_pick
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

Line 738: FROM mtl_material_transactions_temp m2

734: AND m.content_lpn_id IS NULL
735: AND ( (m.lpn_id IS NOT NULL
736: AND NOT EXISTS
737: ( SELECT 'x'
738: FROM mtl_material_transactions_temp m2
739: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
740: AND m2.organization_id = m.organization_id
741: AND m2.content_lpn_id = m.lpn_id
742: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 757: FROM mtl_material_transactions_temp m3

753: OR m.lpn_id IS NULL
754: )
755: AND NOT EXISTS
756: ( SELECT 'x'
757: FROM mtl_material_transactions_temp m3
758: WHERE m3.transfer_lpn_id = m.transfer_lpn_id
759: AND m3.organization_id = m.organization_id
760: AND m3.content_lpn_id = m.transfer_lpn_id
761: AND m3.transaction_temp_id <> m.transaction_temp_id

Line 830: , mtl_material_transactions_temp m

826: , 'TRUE'
827: ) is_bulk_pick
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

Line 875: , mtl_material_transactions_temp m

871: , l.lpn_context
872: , 'FALSE' is_bulk_pick
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

Line 956: FROM mtl_material_transactions_temp m, mtl_system_items_vl k

952: BEGIN
953:
954: OPEN x_items FOR
955: SELECT k.concatenated_segments, k.inventory_item_id
956: FROM mtl_material_transactions_temp m, mtl_system_items_vl k
957: WHERE m.transfer_lpn_id=p_lpn_id
958: AND m.organization_id=k.organization_id
959: AND m.inventory_item_id=k.inventory_item_id
960: AND k.concatenated_segments LIKE (p_concat_segments);