EBS OM发运状态 wsh_delivery_details.RELEASED_STATUS

﹏ヽ暗。殇╰゛Y 2022-10-02 03:47 106阅读 0赞

wsh\_delivery\_details这个表用来存储记录销售订单的物料的发运明细信息，字段RELEASED\_STATUS标识着该发运的状态，通常有值R,S,Y,C这几个状态。

通过一脚本查下这个字段的含义：

SELECT Lookup_Type,
           Lookup_Code,
           Meaning,
           Description,
           View_Application_Id,
           Decode(View_Application_Id,
                  660,
                  'ONT',
                  665,
                  'WSH',
                  201,
                  'PO',
                  401,
                  'INV',
                  200,
                  'AP',
                  222,
                  'AR',
                  101,
                  'GL',
                  661,
                  'QP',
                  0,
                  'FND',
                  702,
                  'BOM',
                  140,
                  'OFA',
                  700,
                  'MFG') Application
      FROM Apps.Fnd_Lookup_Values Lv
     WHERE LANGUAGE = Userenv('LANG')
       --AND View_Application_Id = 665
       AND Security_Group_Id = 0
       AND Lookup_Type = 'PICK_STATUS'
     ORDER BY 1, 2, 5;

结果如下：

![blob.png][]

<table>        
 <tbody> 
  <tr> 
   <td><strong>LOOKUP_TYPE</strong></td> 
   <td><strong>LOOKUP_CODE</strong></td> 
   <td><strong>MEANING</strong></td> 
   <td><strong>DESCRIPTION</strong></td> 
   <td><strong>VIEW_APPLICATION_ID</strong></td> 
   <td><strong>APPLICATION</strong></td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>B</td> 
   <td>已延交</td> 
   <td>未能在库存管理系统中分配行</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>C</td> 
   <td>已发运</td> 
   <td>已发运行</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>D</td> 
   <td>已取消</td> 
   <td>已取消行</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>E</td> 
   <td>已请求补充</td> 
   <td>行已请求补充</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>F</td> 
   <td>已完成补充</td> 
   <td>行已完成补充</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>I</td> 
   <td>已连接</td> 
   <td>已发送行并将其连接至 Oracle Order Management 和 Oracle Inventory。</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>K</td> 
   <td>已计划直接发货</td> 
   <td>X 码头的线路已计划</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>L</td> 
   <td>已关闭</td> 
   <td>已接收行</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>N</td> 
   <td>未准备发放</td> 
   <td>行没有准备好进行发放</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>P</td> 
   <td>已清除</td> 
   <td>已从源系统中清除行</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>R</td> 
   <td>准备发放</td> 
   <td>行已准备好进行发放</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>S</td> 
   <td>已发放至仓库</td> 
   <td>已将行发放至库存管理系统进行处理</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>X</td> 
   <td>不适用</td> 
   <td>行不适合挑库发放</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
  <tr> 
   <td>PICK_STATUS</td> 
   <td>Y</td> 
   <td>分批发运/确认挑库</td> 
   <td>库存管理系统已挑库并分批发运行</td> 
   <td>665</td> 
   <td>WSH</td> 
  </tr> 
 </tbody> 
</table>

转载于:https://blog.51cto.com/baser/2059271

[blob.png]: https://s1.51cto.com/images/20180110/1515546395971777.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=