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

__EXIT__

__ENDIF__

__IF_EXISTS__
SELECT 1
  FROM USER_TABLES
 WHERE TABLE_NAME = 'F1_INSTALLATION'
/
__ELSE__

__EXIT__

__ENDIF__

UPDATE CI_MD_MENU SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION) WHERE MENU_NAME = 'CI_AD_FIN' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_L SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION) WHERE MENU_NAME = 'CI_AD_FIN' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_LINE SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION) WHERE MENU_LINE_ID = 'CI42959096' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_LINE_L SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)  WHERE MENU_LINE_ID = 'CI42959096' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_ITEM SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)  WHERE MENU_ITEM_ID = 'CI36016498' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_ITEM_L SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)   WHERE MENU_ITEM_ID = 'CI36016498' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)   WHERE MENU_NAME = 'CI_AUDQUERY' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_L SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)  WHERE MENU_NAME = 'CI_AUDQUERY' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_LINE SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)   WHERE MENU_LINE_ID = 'CI00000420' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_LINE_L SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)   WHERE MENU_LINE_ID = 'CI00000420' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_ITEM SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)   WHERE MENU_ITEM_ID = 'CI38300462' AND OWNER_FLG = 'F1'
/
UPDATE CI_MD_MENU_ITEM_L SET OWNER_FLG = ( SELECT OWNER_FLG FROM F1_INSTALLATION)   WHERE MENU_ITEM_ID = 'CI38300462' AND OWNER_FLG = 'F1'
/