__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW43001_POSTDATA3.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__
 
DELETE FROM CI_ZONE_PRM WHERE ZONE_HDL_PRM_NAME = 'OUTPUTCLASSNAME' AND ZONE_HDL_CD = 'F1-DE' AND OWNER_FLG != 'CM'
/

UPDATE CI_MD_TBL SET AUDIT_TBL_NAME='CI_AUDIT' WHERE AUDIT_PGM_NAME IN ('com.splwg.base.domain.common.audit.DefaultTableAuditor','com.splwg.base.domain.common.audit.ModifiedTableAuditor') AND AUDIT_TBL_NAME <> 'CI_AUDIT'
/

UPDATE F1_BUS_OBJ_STATUS SET STATUS_REASON_FLG = ' ' WHERE BUS_OBJ_CD = 'F1-SyncRequest' and BO_STATUS_CD = 'SYNC_WITH_ER' and STATUS_REASON_FLG <> ' '
/

UPDATE F1_BUS_OBJ_STATUS SET STATUS_REASON_FLG = 'F1OT' WHERE BUS_OBJ_CD ='F1-GenericBISyncRequest' and BO_STATUS_CD = 'DISCARDED' and STATUS_REASON_FLG <> 'F1OT' 
/

UPDATE F1_BUS_OBJ_STATUS SET STATUS_REASON_FLG = 'F1RD' WHERE BUS_OBJ_CD = 'F1-GenericBISyncRequest' and BO_STATUS_CD = 'CANCELED' and STATUS_REASON_FLG <> 'F1RD'
/

UPDATE F1_BUS_OBJ_STATUS_RSN SET STATUS_REASON_SELECT_FLG = 'F1US' WHERE BO_STATUS_BO_CD = 'F1-GenericBISyncRequest' AND BO_STATUS_CD = 'DISCARDED' and BO_STATUS_REASON_CD = 'F1NR' and STATUS_REASON_SELECT_FLG <> 'F1US'
/

