DBA Data[Home] [Help]

APPS.INV_MO_ADMIN_PUB dependencies on WMS_DISPATCHED_TASKS

Line 517: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

513: IF ( l_wms_org_flag ) THEN
514: Begin
515: select 1
516: into l_loaded_lpn_exists
517: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
518: where mmtt.transaction_temp_id = wdt.transaction_temp_id
519: and wdt.status = 4
520: and mmtt.transfer_lpn_id is not null
521: and mmtt.move_order_line_id = l_line_id

Line 730: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

726:
727: BEGIN
728: select 1
729: into l_loaded_lpn_exists
730: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
731: where mmtt.transaction_temp_id = wdt.transaction_temp_id
732: and wdt.status = 4
733: and mmtt.transfer_lpn_id is not null
734: and mmtt.move_order_line_id = l_line_id