__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
 WHERE SCRIPT_FILE_NAME = 'FW44020_POSTDATA_OUAF-13769.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__

__EXIT__

__ENDIF__

__IF_EXISTS__
SELECT 1
  FROM CI_INSTALL_PROD
 WHERE INSTALL_OPT_ID = '11111'
   AND OWNER_FLG = 'F1'
/
__ELSE__

__EXIT__

__ENDIF__

update f1_iws_svc a set a.uri_component=('/'||a.in_svc_name) where a.uri_component is null and a.owner_flg='CM' and a.WEB_SVC_CLASS_FLG= 'F1RT'
/

insert into F1_EXT_LOOKUP_VAL_CHAR ( BUS_OBJ_CD, F1_EXT_LOOKUP_VALUE, CHAR_TYPE_CD,        SEQ_NUM,             CHAR_VAL,            ADHOC_CHAR_VAL,      CHAR_VAL_FK1,        CHAR_VAL_FK2,        CHAR_VAL_FK3,        CHAR_VAL_FK4,        CHAR_VAL_FK5,        SRCH_CHAR_VAL,       OWNER_FLG,          VERSION  ) select A.BUS_OBJ_CD,  A.F1_EXT_LOOKUP_VALUE, 'F1-URL',10,' ','/'||A.F1_EXT_LOOKUP_VALUE,' ',' ',' ',' ',' ','/'||upper(A.F1_EXT_LOOKUP_VALUE),A.OWNER_FLG,A.VERSION  from F1_EXT_LOOKUP_VAL A where A.BUS_OBJ_CD = 'F1-RESTResourceCategory' and a.owner_flg = 'CM' and not exists (select 1 from F1_EXT_LOOKUP_VAL_CHAR B where A.bus_obj_cd= B.bus_obj_cd and A.f1_ext_lookup_value=B.f1_ext_lookup_value and B.char_type_cd='F1-URL') 
/