-
编辑 删除
库存批次存在非法字符,无法操作问题的解决.
需要修改inv.mtl_material_transactions mtl_onhand_quantities_detail INV.MTL_LOT_NUMBERS 等表后,系统正常[@more@]
-
编辑 删除
ship_confirm API
ship_confirm API[@more@] SET SERVEROUTPUT ON SIZE 100000 DECLARE p_api_version_number NUMBER; x_return_status VARCHAR2(15); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); p_action_code VARCHAR2(25); p_delivery_id NUMBER; p_delivery_name VARCHAR2(30); p_asg_trip_id NUMBER; p_asg_trip_name VARCHAR2(30); p_asg_pickup_stop_id NUMBER; p_asg_pickup_loc_id NUMBER; p_a
-
编辑 删除
发放订单API
发放订单API[@more@]PL/SQL Developer Test script 3.098declare l_rowid varchar2(20);l_batch_id number;l_customer_id number;l_order_header_id number;l_Ship_Set_ID number;l_Inventory_Item_Id number;l_Order_Type_Id number;l_pick_grouping_rule_id number :=1006;l_pick_sequence_rule_id number :=1006;l_Organization_Id number;l_org_id number;l_name varchar2(20); l_user_id number;l_request_id number;l_req_quantity number;p_userid number :=1057;p_Pick_From_Subinventory varchar2(20) :='库';p_Pick_to_Subinven
-
编辑 删除
交货分行
交货分行[@more@]SET SERVEROUTPUT ON SIZE 100000DECLAREp_api_version_number NUMBER;p_from_detail_id NUMBER; x_new_detail_id NUMBER;x_split_quantity NUMBER;x_split_quantity2 NUMBER;p_commit VARCHAR2(30);p_validation_level NUMBER;x_return_status VARCHAR2(2000);x_msg_count NUMBER;x_msg_data VARCHAR2(2000);BEGINp_api_version_number := 1.0;p_from_detail_id := 439297; x_split_quantity := 1; wsh_delivery_details_pub.split_line(p_api_version => p_api_version_number,p_init_msg_list => FND_API.G_TRUE
-
编辑 删除
分配或取消交货号
分配或取消交货号[@more@]SET SERVEROUTPUT ON SIZE 100000DECLAREp_api_version_number NUMBER;p_TabOfDelDets WSH_DELIVERY_DETAILS_PUB.ID_TAB_TYPE; p_action VARCHAR2(15);p_delivery_id NUMBER; p_delivery_name VARCHAR2(30); p_commit VARCHAR2(30);p_validation_level NUMBER;x_return_status VARCHAR2(2000);x_msg_count NUMBER;x_msg_data VARCHAR2(2000);BEGINp_TabOfDelDets(1) := '439395'; p_action := 'ASSIGN';p_api_version_number := 1.0;p_delivery_id := '152501';p_delivery_name := '152501';wsh_delivery_details
-
编辑 删除
根据delivery_detail_id创建交货号
根据delivery_detail_id创建交货号[@more@]SET SERVEROUTPUT ON SIZE 100000DECLAREp_api_version_number NUMBER;p_commit VARCHAR2(30); x_return_status VARCHAR2(2000);x_msg_count NUMBER;x_msg_data VARCHAR2(2000);p_line_rows WSH_UTIL_CORE.ID_TAB_TYPE;x_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;BEGINp_api_version_number := 1.0;p_line_rows(1) := 439300; p_line_rows(2) := 439301; --p_line_rows(3) := 214179; wsh_delivery_details_pub.autocreate_deliveries(p_api_version_number => p_api_version_number,p_init_msg_l
