ITPub博客

关于特定制造体系ERP核算流程实用性改进.ppt[@more@]

浅议大型国企实施ERP项目中的问题及对策 干桃荣 曲荣晓编者按:在大型国企中实施ERP项目，肯定会出现各种各样的问题。有主观也有客观上的，本文作者罗列出这其中所出现的有代表性的问题，对其进行深层次分析, 提出了适合于自身企业信息化建设的几点建议，归纳起来就是“坚持三个先行，处理好四个关系”。即：坚持整体规划先行、坚持培训先行、坚持制度规章先行，正确处理IT部门和业务部门之间的关系、正确处理正常业务与ERP业务的关系、正确处理先进观念与实用观念之间的关系、正确处理培养人才与人才流失的关系。ERP（E

需要修改inv.mtl_material_transactions mtl_onhand_quantities_detail INV.MTL_LOT_NUMBERS 等表后,系统正常[@more@]

家中请客(最佳ERP教材)全集一天中午，老张突然回到家里对妻子说：“亲爱的老婆，晚上几个同事要来家里吃饭。这次我专门回家来要用最先进的ERP理念来完成咱家的请客过程了，要把这次宴会搞成一次ERP家宴。你看，我已经用CRM客户关系管理模块全面管理与这几个同事的关系往来了。这次他们确定要来吃饭的相关信息，我已经放到了销售管理中的合同管理和订单管理中，而且已经自动传递相关数据到应收帐模块、财务模块、还有主生产计划模块中，根据客人的意向和要求，确定了最后做什么菜，也就是主生产计划都有了”。妻子：“那太好了，家里就是你

goal: How to Unclose a Discrete Jobfact: Oracle Work in Process 11.5fact: Oracle Work in Process 11.0.3fact: WIPDJMDF - Define Discrete Job[@more@]goal: How to Unclose a Discrete Jobfact: Oracle Work in Process 11.5fact: Oracle Work in Process 11.0.3fact: WIPDJMDF - Define Discrete Jobfix:To enable the Unclose function: 1. Login to the application as responsibility = SYSADMIN 2. Navigate to Application > Function.3. Query the Function = WIP_WIPDJMDF_CLOSE4. Click on the Form tab.5. Tab to the

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[@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创建交货号[@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