销售订单行上行号：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.Lin
销售订单行上行号：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' ;