how to check LPN status (to load/to drop/loaded)
Select count(*)
into v_count1
From apps.mtl_material_transactions_temp
Where transfer_lpn_id is null
and transaction_temp_id =:transaction_temp_id1;
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/，如需转载，请注明出处，否则将追究法律责任。
下一篇：
flow job
请登录后发表评论
登录
全部评论
