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