首页 > 代码库 > 销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER

销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER


销售订单行上行号:LINE_SHIPMENT_OPTION_NUMBER
取值:

 1
Line块的块级触发器POST-QUERY调用:
OE_LINE.Post_Query;(来自于库OEXOELIN)


 2)
库OEXOELIN里Line_Shipment_Option_Number赋值代码:
    OE_CONCAT_VALUES.LINE_SHIPMENT_OPTION
                                        (
                                         Name_in(‘Line.Line_Number‘ ),
                                         Name_In(‘Line.Shipment_Number‘ ),
                                         Name_In(‘Line.Option_Number‘ ),
                                         x_concat_values,
                                         Name_In(‘Line.Component_Number‘ ),
                                         Name_In(‘Line.Service_Number‘ )
                                         );

    COPY(x_concat_values, ‘Line.Line_Shipment_Option_Number‘ );
   
   
( 3)
OE_CONCAT_VALUES包代码:
PACKAGE BODY oe_concat_values IS
  PROCEDURE line_shipment_option(line_number      IN NUMBER ,
                                 shipment_number  IN NUMBER ,
                                 option_number    IN NUMBER ,
                                 p_concat_value   OUT VARCHAR2 ,
                                 component_number IN NUMBER DEFAULT NULL ,
                                 service_number   IN NUMBER DEFAULT NULL ) IS
  BEGIN
 
    --=========================================
    -- Added for identifying Service Lines
    --=========================================
    IF service_number IS NOT NULL THEN
      IF option_number IS NOT NULL THEN
        IF component_number IS NOT NULL THEN
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘.‘ ||
                            option_number || ‘.‘ || component_number || ‘.‘ ||
                            service_number;
        ELSE
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘.‘ ||
                            option_number || ‘..‘ || service_number;
        END IF ;
    
        --- if a option is not attached
      ELSE
        IF component_number IS NOT NULL THEN
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘..‘ ||
                            component_number || ‘.‘ || service_number;
        ELSE
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘...‘ ||
                            service_number;
        END IF ;
    
      END IF ; /* if option number is not null */
  
      -- if the service number is null
    ELSE
      IF option_number IS NOT NULL THEN
        IF component_number IS NOT NULL THEN
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘.‘ ||
                            option_number || ‘.‘ || component_number;
        ELSE
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘.‘ ||
                            option_number;
        END IF ;
    
        --- if a option is not attached
      ELSE
        IF component_number IS NOT NULL THEN
          p_concat_value := line_number || ‘.‘ || shipment_number || ‘..‘ ||
                            component_number;
        ELSE
          /*Bug2848734 - Added IF condition */
          IF (line_number IS NULL AND shipment_number IS NULL) THEN
            p_concat_value := NULL ;
          ELSE
            p_concat_value := line_number || ‘.‘ || shipment_number;
          END IF ;
        END IF ;
    
      END IF ; /* if option number is not null */
  
    END IF ; /* if service number is not null */
 
  END line_shipment_option;

END oe_concat_values;


SELECT ool.line_id
      ,to_char(ool.line_number) ||
       decode (ool.shipment_number,
              NULL ,
              NULL ,
              ‘.‘ || to_char(ool.shipment_number)) ||
       decode (ool.option_number,
              NULL ,
              NULL ,
              ‘.‘ || to_char(ool.option_number)) ||
       decode (ool.component_number,
              NULL ,
              NULL ,
              decode (ool.option_number, NULL , ‘.‘, NULL ) || ‘.‘ ||
              to_char(ool.component_number)) ||
       decode (ool.service_number,
              NULL ,
              NULL ,
              decode (ool.component_number, NULL , ‘.‘, NULL ) ||
              decode (ool.option_number, NULL , ‘.‘, NULL ) || ‘.‘ ||
              to_char(ool.service_number)) line_num
      ,msi.segment1 item_number
      ,ool.ordered_quantity
  FROM oe_order_lines_all ool, mtl_system_items msi
WHERE ool.header_id = &header_id
   AND ool.ship_from_org_id = msi.organization_id(+)
   AND ool.inventory_item_id = msi.inventory_item_id(+)
   AND ool.item_type_code <> ‘INCLUDED‘ ;

销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER