销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER,shipmentnumber
销售订单行上行号: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' ;
销售订单号和销售订单行号,尤其是订单行号,一般是针对一个订单有多个产品的情况下,分不同的行的;
可以举个例子,比如订单号码是1000,这个订单下面有2个不同型号的产品,则对应的订单行号就是1000-1、1000-2;这个只是个例子,具体的编码规则可以由各个企业自行制定。
首先确认两件事:
1,启用了ATP check
2,配置了可产生PR的计划行,计划行类别里有个设置,自己能看懂的
操作时:
1,默认情况下自动确认计划行50数量
2,手工添加计划行的第二行,计划行类别为你设定好的计划行类别
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。