__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW44031_APPDATA_OUAF-19010.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__
__EXIT__
__ENDIF__

update ci_alg set owner_flg = 'CM' where alg_cd = 'F1-LDAPIMPRT' and owner_flg = 'F1'
/
update ci_alg_l set owner_flg = 'CM' where alg_cd = 'F1-LDAPIMPRT' and owner_flg = 'F1'
/
update ci_alg_ver set owner_flg = 'CM' where alg_cd = 'F1-LDAPIMPRT' and owner_flg = 'F1'
/
update ci_alg_type set owner_flg = 'CM' where alg_type_cd = 'F1-LDAPIMPRT' and owner_flg = 'F1'
/
update ci_alg_type_l set owner_flg = 'CM' where alg_type_cd = 'F1-LDAPIMPRT' and owner_flg = 'F1'
/
update ci_alg set owner_flg = 'CM' where alg_cd = 'F1-LDAPPREPR' and owner_flg = 'F1'
/
update ci_alg_l set owner_flg = 'CM' where alg_cd = 'F1-LDAPPREPR' and owner_flg = 'F1'
/
update ci_alg_ver set owner_flg = 'CM' where alg_cd = 'F1-LDAPPREPR' and owner_flg = 'F1'
/
update ci_alg_type set owner_flg = 'CM' where alg_type_cd = 'F1-LDAPPREPR' and owner_flg = 'F1'
/
update ci_alg_type_l set owner_flg = 'CM' where alg_type_cd = 'F1-LDAPPREPR' and owner_flg = 'F1'
/
UPDATE CI_TD_DRLKEY_TY SET OWNER_FLG = 'CM' WHERE TD_TYPE_CD = 'F1-SYNRQ' AND OWNER_FLG = 'F1'
/
UPDATE CI_TD_SRTKEY_TY SET OWNER_FLG = 'CM' WHERE TD_TYPE_CD = 'F1-SYNRQ' AND OWNER_FLG = 'F1'
/
UPDATE CI_TD_SRTKEY_TY_L SET OWNER_FLG = 'CM' WHERE TD_TYPE_CD = 'F1-SYNRQ' AND OWNER_FLG = 'F1'
/
UPDATE CI_TD_TYPE SET OWNER_FLG = 'CM' WHERE TD_TYPE_CD = 'F1-SYNRQ' AND OWNER_FLG = 'F1'
/
UPDATE CI_TD_TYPE_L SET OWNER_FLG = 'CM' WHERE TD_TYPE_CD = 'F1-SYNRQ' AND OWNER_FLG = 'F1'
/
UPDATE F1_BUS_OBJ SET OWNER_FLG = 'CM' WHERE BUS_OBJ_CD = 'F1-EnvironmentRefPhysicalBO' AND OWNER_FLG = 'F1'
/
UPDATE F1_BUS_OBJ_L SET OWNER_FLG = 'CM' WHERE BUS_OBJ_CD = 'F1-EnvironmentRefPhysicalBO' AND OWNER_FLG = 'F1'
/
UPDATE F1_SCHEMA SET OWNER_FLG = 'CM' WHERE SCHEMA_NAME = 'F1-EnvironmentRefPhysicalBO' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MO SET OWNER_FLG = 'CM' WHERE MAINT_OBJ_CD = 'ENV REF' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MO_L SET OWNER_FLG = 'CM' WHERE MAINT_OBJ_CD = 'ENV REF' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MO_OPT SET OWNER_FLG = 'CM' WHERE MAINT_OBJ_CD = 'ENV REF' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MO_TBL SET OWNER_FLG = 'CM' WHERE MAINT_OBJ_CD = 'ENV REF' AND OWNER_FLG = 'F1'
/
UPDATE CI_ZONE SET OWNER_FLG = 'CM' WHERE ZONE_CD IN ('F1-IWSSCHS', 'F1-IWSSCHS1', 'F1-IWSSCHS2', 'F1-IWSSCHS3')  AND OWNER_FLG = 'F1'
/
UPDATE CI_ZONE_L SET OWNER_FLG = 'CM' WHERE ZONE_CD IN ('F1-IWSSCHS', 'F1-IWSSCHS1', 'F1-IWSSCHS2', 'F1-IWSSCHS3')  AND OWNER_FLG = 'F1'
/
UPDATE CI_ZONE_PRM SET OWNER_FLG = 'CM' WHERE ZONE_CD IN ('F1-IWSSCHS', 'F1-IWSSCHS1', 'F1-IWSSCHS2', 'F1-IWSSCHS3')  AND OWNER_FLG = 'F1'
/

