Select count(*)
into v_count1
From apps.mtl_material_transactions_temp
Where transfer_lpn_id is null
and transaction_temp_id =:transaction_temp_id1;
Select count(*)
into v_count2
From apps.mtl_material_transactions_temp
Where transfer_lpn_id is not null
and transaction_temp_id =:transaction_temp_id1;
Select count(*)
into v_count3
From apps.wms_dispatched_tasks_history
Where transaction_temp_id =:transaction_temp_id1;
If v_count1>=1 then
Return 'To Load';
Elsif v_count2>=1 then
Return 'To Drop';
Elsif V_count3>=1 then
Return 'Dropped';
Else
Return Null;
End If;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15225049/viewspace-715843/,如需转载,请注明出处,否则将追究法律责任。