Dynamic query method of enterprise management software inventory resources

A technology of dynamic query and enterprise management, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of low efficiency of multi-organization resource query, does not support fuzzy query, etc. The effect of mobile phone remote resource query and simple development

Inactive Publication Date: 2010-02-24
DALIAN METALLURGICAL BEARING
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to overcome the low efficiency of multi-organization resource query in the existing ERP, especially the lack of support for fuzzy query, and provide a dynamic query method for enterprise management software inventory resources

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Dynamic query method of enterprise management software inventory resources
  • Dynamic query method of enterprise management software inventory resources

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0011] The dynamic query method of inventory resources of enterprise management software includes hardware and software. The hardware part includes servers and terminal computers installed in various functional departments and positions, and is connected through a bus to form a local area network or an Ethernet. .

[0012] The software part includes:

[0013] A. Depending on the development tool, create a FORM that can connect to the database. One (or more, as needed) text baskets for receiving input parameters, one option button, one command button for executing queries, and a display that need to be placed on the FORM A table of results.

[0014] B. Standardize the inventory organization, inventory code, and material code. If necessary, you can enable the flexible field (FLEXFIELD) to facilitate fuzzy queries.

[0015] C. Use the SQL language to create a query statement, which is the most critical content, and the statement is simple to be efficient. It is necessary to re...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a dynamic query method of enterprise management software inventory resources, comprising two main parts, hardware and software, wherein, the hardware part comprises a server andterminal computers arranged in each functional department and connected into a local network or formed into Ethernet by bus lines; the software part is as follows: ORACLE EBS is taken as an example,similarly hereinafter, high-level computer languages supporting database development are used, such as VISUAL BASIC, C++, JAVA, FORMBUILDER and other development tools, three tables provided by usingORACLE EBS are mtl_Onhand_quantities_detail, mtl_reserVations and mtl_material_transactions_temp which can be associated with a pricelist QP_LIST_LINES, a cost table cst_item_costs and the like to form unified query if required; fields such as inventory organization, subinventory, material code and the like are taken as variables, and 'equal mark' and 'LIKE' in a select are used to associate withvariables. The invention overcomes the deficiency that the original software does not support fuzzy query, which facilitates realizing multi-organization dynamic resource query and achieving the purposes of improving efficiency and quickening response speed of customers.

Description

technical field [0001] The invention relates to a resource dynamic query method for enterprise management software in the subfield of computer software products in the field of electronics and information, especially suitable for enterprises and units that have implemented or are about to implement ERP and logistics management systems, and have multiple organizations that need to share resources. Background technique [0002] At present, there are quite a lot of enterprises implementing ERP. In mainstream ERP systems such as ORACLE, SAP and other systems, the information is mostly shielded by the operating unit (OPERATION UNIT) and the inventory organization (1NVENTORY ORGANIZATION). For users, information shielding is necessary in terms of finance and management; however, for the use of resources, information shielding will bring a lot of inconvenience, which is not conducive to the sharing and utilization of resources, and is not conducive to better resource efficiency. pl...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30G06Q10/00
Inventor闫波
OwnerDALIAN METALLURGICAL BEARING