APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 78: FROM mtl_material_transactions_temp mmtt,

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

Line 146: , mtl_material_transactions_temp m

142: , 'TRUE'
143: ) is_bulk_pick
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

Line 193: , mtl_material_transactions_temp m

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

Line 269: , mtl_material_transactions_temp m

265: , 'TRUE'
266: ) is_bulk_pick
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

Line 318: FROM mtl_material_transactions_temp mmtt,

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

Line 381: , mtl_material_transactions_temp m

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

Line 454: , mtl_material_transactions_temp m

450: , 'TRUE'
451: ) is_bulk_pick
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

Line 479: FROM mtl_material_transactions_temp m2

475: )
476: )
477: AND EXISTS
478: ( SELECT 'x'
479: FROM mtl_material_transactions_temp m2
480: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
481: AND m2.organization_id = m.organization_id
482: AND m2.content_lpn_id = m.transfer_lpn_id
483: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 551: , mtl_material_transactions_temp m

547: , 'TRUE'
548: ) is_bulk_pick
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

Line 633: , mtl_material_transactions_temp m

629: , 'TRUE'
630: ) is_bulk_pick
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

Line 659: FROM mtl_material_transactions_temp m2

655: )
656: AND m.lpn_id IS NOT NULL
657: AND EXISTS
658: ( SELECT 'x'
659: FROM mtl_material_transactions_temp m2
660: WHERE m2.transfer_lpn_id = m.transfer_lpn_id
661: AND m2.organization_id = m.organization_id
662: AND m2.content_lpn_id = m.lpn_id
663: AND m2.transaction_temp_id <> m.transaction_temp_id

Line 731: , mtl_material_transactions_temp m

727: , 'TRUE'
728: ) is_bulk_pick
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

Line 756: FROM mtl_material_transactions_temp m2

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

Line 775: FROM mtl_material_transactions_temp m3

771: OR m.lpn_id IS NULL
772: )
773: AND NOT EXISTS
774: ( SELECT 'x'
775: FROM mtl_material_transactions_temp m3
776: WHERE m3.transfer_lpn_id = m.transfer_lpn_id
777: AND m3.organization_id = m.organization_id
778: AND m3.content_lpn_id = m.transfer_lpn_id
779: AND m3.transaction_temp_id <> m.transaction_temp_id

Line 850: , mtl_material_transactions_temp m

846: , 'TRUE'
847: ) is_bulk_pick
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

Line 899: , mtl_material_transactions_temp m

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

Line 1026: FROM mtl_material_transactions_temp m, mtl_system_items_vl k

1022: BEGIN
1023:
1024: OPEN x_items FOR
1025: SELECT k.concatenated_segments, k.inventory_item_id
1026: FROM mtl_material_transactions_temp m, mtl_system_items_vl k
1027: WHERE m.transfer_lpn_id=p_lpn_id
1028: AND m.organization_id=k.organization_id
1029: AND m.inventory_item_id=k.inventory_item_id
1030: AND k.concatenated_segments LIKE (p_concat_segments);