DBA Data[Home] [Help]

APPS.INV_MO_ADMIN_PUB dependencies on WMS_DISPATCHED_TASKS

Line 527: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

523: IF ( l_wms_org_flag ) THEN
524: Begin
525: select 1
526: into l_loaded_lpn_exists
527: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
528: where mmtt.transaction_temp_id = wdt.transaction_temp_id
529: and wdt.status = 4
530: and mmtt.transfer_lpn_id is not null
531: and mmtt.move_order_line_id = l_line_id

Line 740: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

736:
737: BEGIN
738: select 1
739: into l_loaded_lpn_exists
740: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
741: where mmtt.transaction_temp_id = wdt.transaction_temp_id
742: and wdt.status = 4
743: and mmtt.transfer_lpn_id is not null
744: and mmtt.move_order_line_id = l_line_id