基于Item Template,导入Item数据
1.查找到TEMPLATE_ID
SELECT * FROM MTL_ITEM_TEMPLATES_B b,MTL_ITEM_TEMPLATES_TL tl
WHERE b.TEMPLATE_ID = tl.TEMPLATE_ID
AND tl.TEMPLATE_NAME LIKE 'Purchased Item%';
2.基于模板插入Item
INSERT
INTO
MTL_SYSTEM_ITEMS_INTERFACE
(
process_flag,
set_process_id,
transaction_type,
organization_id,
segment1,
description,
TEMPLATE_ID
)
VALUES
(
1, --process_flag
1, --set_process_id
'CREATE', --transaction_type
204, --organization_id
'PTIAN1', --Item Segment1
'Testing Item Import With Template', --Item description
259 --Item TEMPLATE_ID
);
INSERT
INTO
MTL_SYSTEM_ITEMS_INTERFACE
(
process_flag,
set_process_id,
transaction_type,
organization_id,
segment1,
des