add_action('wp_footer', function () { echo ''; }, 99); Creating Maintenance Routes with BOM_RTG_PUB API (You can use this API for discrete manufacturing) » engin hafızoğlu
msgbartop
Delivery Assurance Manager
msgbarbottom

20 Jan 11 Creating Maintenance Routes with BOM_RTG_PUB API (You can use this API for discrete manufacturing)

Firstly I create a custom table then I insert the datas from excel sheet.

[sql]CREATE TABLE XXINN_MAINTENANCE_ROUTES(
ASSEMBLY_ITEM_NAME VARCHAR2(240 BYTE),
ORGANIZATION_CODE VARCHAR2(3 BYTE),
LONG_DESCRIPTION VARCHAR2(4000 BYTE),
OPERATION_DESCRIPTION VARCHAR2(400 BYTE),
OPERATION_SEQUENCE_NUMBER NUMBER,
DEPARTMENT_CODE VARCHAR2(10 BYTE),
RESOURCE_SEQUENCE_NUMBER NUMBER,
RESOURCE_CODE VARCHAR2(10 BYTE),
USAGE_RATE_OR_AMOUNT NUMBER,
ASSIGNED_UNITS NUMBER,
ERROR VARCHAR2(2000 BYTE)
)[/sql]

Then I have written this procedure for creating the maintenance routes.

Yorum Yaz