EAM Open Interface for Import Asset Number
Dear all,
I'm using Open Interface for Import Asset Number (mass upload). I have populate required data and inserting into interface table. The sql script as shown below.
INSERT INTO APPS.MTL_EAM_ASSET_NUM_INTERFACE
( BATCH_ID,PROCESS_FLAG,IMPORT_MODE, IMPORT_SCOPE,INVENTORY_ITEM_ID, SERIAL_NUMBER,ORGANIZATION_CODE,OWNING_DEPARTMENT_ID, ERROR_CODE,ERROR_MESSAGE,CATEGORY_ID,DESCRIPTIVE_TEXT, CURRENT_ORGANIZATION_ID,WIP_ACCOUNTING_CLASS_CODE,
MAINTAINABLE_FLAg, EAM_LOCATION_ID, ASSET_CRITICALITY_CODE, INTERFACE_GROUP_ID, INTERFACE_HEADER_ID,
LOCATION_CODES, OWNING_DEPARTMENT_CODE, asset_criticality_id, current_status, LAST_UPDATE_date, LAST_UPDATEd_BY, CREATION_DATE, CREATED_BY)