The Line number on the sales order Line: LINE_SHIPMENT_OPTION_NUMBER (1) Line block trigger POST-QUERY call: OE_LINE.Post_Query; (from library OEXOELIN) (2) Library OEXOELIN Line_Shipment_Option_Number assigned code: OE_CONCAT_VALUES.LINE_SHIPMENT_OPTION (Name_in (Line. lin
Line number on the sales order Line: LINE_SHIPMENT_OPTION_NUMBER fetch: (1) block-level trigger POST-QUERY call: OE_LINE.Post_Query; (from library OEXOELIN) (2) Library OEXOELIN Line_Shipment_Option_Number assigned code: OE_CONCAT_VALUES.LINE_SHIPMENT_OPTION (Name_in ('line. lin
The line number on the sales order line: LINE_SHIPMENT_OPTION_NUMBER; values:
(1) Line block trigger POST-QUERY call: OE_LINE.Post_Query; (from library OEXOELIN)
(2) The value assignment code of Line_Shipment_Option_Number in OEXOELIN: 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. comment '); (3) Comment PACKAGE code: package body comment 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 attachedElse 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;
/* If option number is not null */
-- If the service number is nullElse 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 attachedElse if component_number is not null then p_concat_value: = line_number | '.' | shipment_number | '.' | component_number; ELSE
/* Bug28000034-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;
/* 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 msiWHERE 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 ';