销售出库流程

发运行

 

1、视图

   WSH_DELIVERABLES_V

    1.1 显示条件

       1.1.1 Nvl (Wdd.Line_Direction, 'O') IN ('O' , 'IO')

             Nvl(Wda.Type, 'S' ) IN ( 'S', 'C' )

       1.1.2 有发运行和分配

   2、表

   WSH_DELIVERY_DETAILS  --Wdd

   WSH_DELIVERY_ASSIGNMENTS  --Wda

   3、相关值集

   --Wdd.Source_Code

   SELECT Flv.Lookup_Code

         ,Flv.Meaning

     FROM Fnd_Lookup_Values Flv

    WHERE Flv.Lookup_Type = 'SOURCE_SYSTEM'       

      AND Flv.Language = 'ZHS' --Userenv('LANG')

      AND Flv.View_Application_Id = 665

      AND Flv.Security_Group_Id = 0 ;

　　　　

  --Wdd.Released_Status

   SELECT Meaning

         ,Flv_Released.Lookup_Code

     FROM Fnd_Lookup_Values Flv_Released

    WHERE Flv_Released.Lookup_Type = 'PICK_STATUS'

      AND Flv_Released.Language = 'ZHS' --Userenv('LANG')

      AND Flv_Released.View_Application_Id = 665

      AND Flv_Released.Security_Group_Id = 0

    

 

交货行

   1、视图

   WSH_DLVB_DLVY_V

   1.1 显示条件

       1.1.1 Wnd.Delivery_Type = 'STANDARD'

             Nvl(Wnd.Shipment_Direction, 'O' ) IN ( 'O', 'IO' )

             Nvl(Wda.Type, 'S' ) IN ( 'S', 'O' )

       1.1.2 有发货行和分配行

  

   2、表

   WSH_NEW_DELIVERIES --Wnd

   WSH_DELIVERY_ASSIGNMENTS  --Wda

   关联字段：Delivery_Id

   3、相关值集

   --Wnd.Status_Code --交货状态

   SELECT Lookup_Code

         ,Meaning

         , Description

     FROM Fnd_Lookup_Values Lv

    WHERE LANGUAGE = 'ZHS' --Userenv('LANG')

      AND View_Application_Id = 665

      AND Security_Group_Id = 0

      AND Lookup_Type = 'DELIVERY_STATUS' ;

  

 

 

保留

   1、视图

   MTL_RESERVATIONS_ALL_V

   查询条件：

   Demand_Source_Type_Id = 2    ---需求来源 SELECT * FROM Apps.Mtl_Txn_Source_Types;  2-->销售订单

   Demand_Source_Header_Id = 147461  -- Mtl_Sales_Orders.Sales_Order_Id

   Demand_Source_Line_Id = 207663  -- Oe_Order_Lines.Line_Id