cux_xm_item_project_mapping

select * from cux_item_project_mapping_temp;
先看026是否在运行中
1.
truncate table cux_item_project_mapping_temp;

2.select * from cux_item_project_mapping_temp for update;

3. 贴数据进去 字段对其

4.执行
MERGE INTO cux_xm_item_project_mapping cxp
USING (select nvl(cxd.FACTORY_CODE, '101178') FACTORY_CODE,
max(project_code) project_code,
ITEM_CODE
from cux_item_project_mapping_temp cxd
where 1=1--1=2
group by nvl(cxd.FACTORY_CODE, '101178'),
-- project_code,
ITEM_CODE) C
ON (cxp.ITEM_CODE = c.item_code and nvl(cxp.FACTORY_CODE, '101178') = c.FACTORY_CODE)

WHEN MATCHED THEN

UPDATE
SET cxp.PROJECT_CODE = c.project_code,
cxp.LAST_UPDATED_BY = fnd_global.USER_ID,
cxp.LAST_UPDATE_DATE = sysdate


WHEN NOT MATCHED THEN

INSERT
(cxp.DATA_ID,
cxp.PROJECT_CODE,
cxp.ITEM_CODE,
cxp.INVENTORY_ITEM_ID,
cxp.FACTORY_CODE,
cxp.CREATION_DATE,
cxp.CREATED_BY,
cxp.LAST_UPDATED_BY,
cxp.LAST_UPDATE_LOGIN,
cxp.LAST_UPDATE_DATE)
VALUES
(cux_xm_item_project_mapping_s.nextval,
C.project_code,
C.ITEM_CODE,
cux_common_utl.get_item_id(p_item_number => C.ITEM_CODE),
c.FACTORY_CODE,
sysdate,
fnd_global.USER_ID,
fnd_global.USER_ID,
-1,
sysdate);
5.检查数据
select * from cux_xm_item_project_mapping a
where a.LAST_UPDATE_DATE>sysdate-0.001;
6.保存