ITPub博客

首页 > Linux操作系统 > Linux操作系统 > how to check LPN status (to load/to drop/loaded)

how to check LPN status (to load/to drop/loaded)

原创 Linux操作系统 作者:susie0409 时间:2012-02-08 15:35:50 0 删除 编辑
 
 
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: flow job
请登录后发表评论 登录
全部评论

注册时间:2009-09-30

  • 博文量
    115
  • 访问量
    266794