oracle的template用法,Oracle 基于Item Template,导入Item数据

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,

description,

TEMPLATE_ID

)

VALUES

(

1,    --process_flag

1,     --set_process_id

'CREATE', --transaction_type

207,  --organization_id

'PTIAN1',  --Item Segment1

'Testing Item Import With Template',  --Item description

259  --Item TEMPLATE_ID

);

COMMIT;

关于Item Interface表-MTL_SYSTEM_ITEMS_INTERFACE

MTL_SYSTEM_ITEMS_INTERFACE temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.

.

This table contains user friendly columns which allow you to easily enter your data as well as their corresponding foreign keys. Oracle Inventory will default column values you do not enter, after performing the proper validation. For example, you enter the ORGANIZATION_CODE, and Oracle Inventory will fill in the corresponding ORGANIZATION_ID for you. It is strongly recommended that users enter the segment information for the item instead of the item number.

.

You can also specifiy a TEMPLATE_ID to copy item attributes from.

.

Also, if you enter REVISION, Oracle Inventory will insert a record into MTL_ITEM_REVISIONS for your item.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/121967/viewspace-1576091/，如需转载，请注明出处，否则将追究法律责任。