Saturday 13 April 2013

How To Upload Item Cross Reference Using mtl_cross_references_interface

INSERT INTO mtl_ci_interface
(customer_id,
customer_item_number,
commodity_code,
item_definition_level, process_flag, process_mode,
inactive_flag, transaction_type, lock_flag,
last_updated_by, created_by, last_update_date,
creation_date,ATTRIBUTE5,ATTRIBUTE6
)
VALUES
(2045,
'Test_upload',
'Finished Goods',
1, 1, 1,
'2', 'CREATE', 'N',
1212, 1212, SYSDATE,
SYSDATE,'E-0001','E-0002'
);


INSERT INTO mtl_ci_xrefs_interface
(customer_id,
customer_item_number,
preference_number,
inventory_item,
master_organization_id,
item_definition_level, process_flag, process_mode,
inactive_flag, transaction_type, lock_flag,
last_updated_by, created_by, last_update_date,
creation_date
)
VALUES (2045,
'Test_upload',
1,
'00-0001-0004-2-0000-0000',
313,
1, 1, 1,
'2', 'CREATE', 'N',1212,1212, SYSDATE,
SYSDATE
);

No comments:

Post a Comment