物料目录导入 Item catalog upload

1. 制作数据模板，包含基本属性：item_number, catalog group name, descriotive elements name, value

2. 上传数据模板至相应服务器目录下

3. 跑upload程序将数据插入至临时表

4. 跑import程序将临时表里的数据直接通过程序插入至基本表

 

注意：catalog 的属性维护职能去master items 下进行维护，并且按照程序以及业务逻辑的要求进行catalog group name 以及 element value的维护。

 

--******************************************************************************

--Organization and Item informations

SELECT *
  FROM mtl_parameters
 WHERE organization_code = '';

SELECT segment1
  FROM mtl_system_items_b
 WHERE organization_id = AND inventory_item_id = ;

--******************************************************************************

--

--Base table information

SELECT *
  FROM mtl_catalog_search_items;

SELECT *
  FROM mtl_item_catalog_groups_b
 WHERE segment1 LIKE '%E%';

SELECT *
  FROM mtl_item_catalog_groups_tl;

--******************************************************************************

SELECT *
  FROM mtl_item_catalog_groups
 WHERE TRUNC (creation_date) = TRUNC (SYSDATE);

SELECT *
  FROM mtl_descriptive_elements;

SELECT *
  FROM mtl_descr_element_values
 WHERE TRUNC (creation_date) = TRUNC (SYSDATE);

SELECT *
  FROM xxinv_vlvs_item_catalog
 WHERE TRUNC (creation_date) = TRUNC (SYSDATE);

SELECT *
  -- INTO v_item_catalog_group_id
FROM   mtl_item_catalog_groups
 WHERE UPPER (segment1) = UPPER ('');

SELECT DISTINCT inventory_item_id, item_catalog_group_id
--        INTO v_inventory_item_id,
--             v_item_catalog_group_id
FROM            mtl_system_items_b