insert into OCC_TRAIL_A@dbl.eai
(
ID
,OWNING_OBJECT_ID
,ATTRIBUTE_DEFINITION_ID
,TYPE
,STRING_VALUE
,INTEGER_VALUE
,LONG_VALUE
,FLOAT_VALUE
,DOUBLE_VALUE
,BOOLEAN_VALUE
,TIMESTAMP_VALUE
,TIME_POINT_VALUE
)
select 
OCC_TRAIL_A_ID.nextval@dbl.eai as ID
,ot.object_inst_id as OWNING_OBJECT_ID
,d.ATTRIBUTE_ID as ATTRIBUTE_DEFINITION_ID
,d.DATA_TYPE as TYPE
,(case 
	when d.DATA_TYPE = 'C' then 
		GET_PICKLIST_DM_ENTRY(cas.ATTR_VALUE, substr(d.QUALIFIED_PICKLIST_ID, instr(d.QUALIFIED_PICKLIST_ID, ':')+1))
	when d.DATA_TYPE in ('S', 'U') then 
		cas.ATTR_VALUE
	else NULL 
end) as STRING_VALUE
,(case when d.DATA_TYPE = 'I' then cas.ATTR_VALUE else NULL end) as INTEGER_VALUE
,NULL as LONG_VALUE
,(case when d.DATA_TYPE = 'F' then cas.ATTR_VALUE else NULL end) as FLOAT_VALUE
,(case when d.DATA_TYPE = 'D' then cas.ATTR_VALUE else NULL end) as DOUBLE_VALUE
,NULL as BOOLEAN_VALUE
,(case when d.DATA_TYPE = 'T' then cas.ATTR_VALUE else NULL end) as TIMESTAMP_VALUE
,NULL as TIME_POINT_VALUE
from circ_attr_settings@dbl.granite cas, stg_trail_new stn, occ_trail@dbl.eai ot, val_attr_name@dbl.granite van, platform.object_registry@dbl.eai a, dyn_attr_group_obj_types@dbl.eai b, dyn_attr_group@dbl.eai c, dyn_attr_definition@dbl.eai d
where cas.circ_inst_id = stn.ref_id
and stn.name = ot.name
and stn.REVISION_NUMBER = ot.REVISION_NUMBER
and cas.VAL_ATTR_INST_ID = van.VAL_ATTR_INST_ID
and to_english(van.ATTR_NAME) = d.ATTRIBUTE_NAME
and to_english(van.GROUP_NAME) = c.GROUP_NAME
and a.OBJECT_REGISTRY_ID = b.OBJECT_TYPE_ID
and b.GROUP_ID = c.GROUP_ID
and c.GROUP_ID = d.GROUP_ID
and stn.GRANITE_OBJECT_TYPE = 'SEGMENT'
and a.QUALIFIED_OBJECT_ID = 'occ:trail'
and not exists (select 1 from OCC_TRAIL_A@dbl.eai chk_ta where chk_ta.OWNING_OBJECT_ID = ot.object_inst_id and chk_ta.ATTRIBUTE_DEFINITION_ID = d.ATTRIBUTE_ID);

insert into OCC_TRAIL_B@dbl.eai
(
ID
,OWNING_OBJECT_ID
,AFTER
,TARGET_OBJECT_TYPE
,TARGET_OBJECT_ID
,BINDING_NAME
,REV_GROUP_ID
,BINDING_DATA_ID
,BINDING_DATA_TYPE
,TARGET_OBJECT_REV_GROUP_ID
)
select 
OCC_TRAIL_B_ID.nextval@dbl.eai as ID
,ot.object_inst_id as OWNING_OBJECT_ID
,NULL as AFTER
,(select OBJECT_REGISTRY_ID from platform.object_registry@dbl.eai where QUALIFIED_OBJECT_ID = 'oci:site') as TARGET_OBJECT_TYPE
,os.site_inst_id as TARGET_OBJECT_ID
,'com.ericsson.granite.oss.core.path.binding.TrailToASideSite' as BINDING_NAME
,ot.REVISION_GROUP_ID as REV_GROUP_ID
,NULL as BINDING_DATA_ID
,NULL as BINDING_DATA_TYPE
,NULL as TARGET_OBJECT_REV_GROUP_ID
from occ_trail@dbl.eai ot, STG_TRAIL_NEW stn, oci_site@dbl.eai os
where ot.name = stn.name
and ot.REVISION_NUMBER = stn.REVISION_NUMBER
and stn.A_SIDE_SITE = os.name;