DBA Data[Home] [Help]

APPS.INV_MO_ADMIN_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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

Line 757: Delete MTL_MATERIAL_TRANSACTIONS_TEMP

753: where line_id = l_line_id;
754:
755: else /*bug fix3524130 ends*/
756: Begin
757: Delete MTL_MATERIAL_TRANSACTIONS_TEMP
758: Where
759: Move_Order_Line_Id = l_line_id;
760: Exception
761: when NO_DATA_FOUND then