__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW43020_POSTDATA1.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 IN ('F1-DE', 'F1-DE-MULQRY', 'F1-DE-QUERY', 'F1-DE-SINGLE')
/
UPDATE F1_MIGR_OBJ_ALG SET ALG_PROC_TYPE_FLG='F1M2' WHERE ALG_PROC_TYPE_FLG=' '
/
DELETE from F1_IWS_SVC_ANN WHERE ANN_CD='F1-USERNAM'
/
UPDATE CI_MD_MENU_LINE_L SET SEQ_NUM = '50' WHERE MENU_LINE_ID = 'F157226748' AND SEQ_NUM = '53'
/
UPDATE CI_MD_MENU_LINE_L SET SEQ_NUM = '50' WHERE MENU_LINE_ID = 'F157115689' AND SEQ_NUM = '52'
/
UPDATE CI_MD_MENU_LINE_L SET SEQ_NUM = '50' WHERE MENU_LINE_ID = 'F101379814' AND SEQ_NUM = '51'
/
UPDATE CI_BATCH_CTRL_P SET REQUIRED_SW = 'N' WHERE BATCH_CD = 'F1-MGDPR' AND SEQ_NUM = 60 AND REQUIRED_SW = 'Y'
/
UPDATE CI_BATCH_CTRL SET F1_BATCH_CTGY_FLG = 'F1PG' WHERE BATCH_CD = 'F1-TDPG' AND (F1_BATCH_CTGY_FLG = ' ' OR F1_BATCH_CTGY_FLG = 'F1TD')
/
UPDATE CI_BATCH_CTRL SET F1_BATCH_CTGY_FLG = 'F1PG' WHERE BATCH_CD = 'F1-NDPUR' AND (F1_BATCH_CTGY_FLG = ' ' OR F1_BATCH_CTGY_FLG = 'F1AD')
/