create or replace procedure ACCESS_PROD is
begin
execute immediate 'truncate table access_prod_inst';
select
a.PROD_INST_ID,
a.PRODUCT_ID,
a.ACC_NBR,
a.OWNER_CUST_ID,
a.USE_CUST_ID,
a.ADDRESS_DESC,
a.PRODUCT_PROP,
a.PAYMENT_MODE_CD,
a.CREATE_DATE,
a.FINISH_TIME,
a.COL1,
a.COL4,
a.COL8,
a.COL6,
a.COL10,
a.COMMON_REGION_ID,
a.COMP_INST_ID,
a.COMMENTS,
a.COMM_COL1,
a.COMM_COL2,
a.CHANNEL_ID
into access_prod_inst
from
access_prod_inst@crmbm a where a.lan_id='937'and a.state_cd='001';
execute immediate 'create index access_prod_inst on access_prod_inst (prod_inst_id,acc_nbr)';
commit;
end ACCESS_PROD;