__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
 WHERE SCRIPT_FILE_NAME = 'FW420_POSTDATA2.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 F1_SCHEMA WHERE SCHEMA_NAME = 'Z1BP12366530'
/
DELETE FROM CI_SCR_STEP WHERE SCR_CD = 'Z1BP12366530'
/
DELETE FROM CI_SCR_L WHERE SCR_CD = 'Z1BP12366530'
/
                    
DELETE FROM CI_SCR  WHERE SCR_CD = 'Z1BP12366530'
/
                    
DELETE FROM CI_SCR_DA WHERE SCR_CD = 'Z1BP12366530'
/
                  
DELETE FROM CI_SCR_STEP_L WHERE SCR_CD = 'Z1BP12366530'
/

DELETE FROM CI_BATCH_CTRL_P WHERE BATCH_CD = 'ZPARMTES'
/                  
DELETE FROM CI_BATCH_CTRL_P WHERE BATCH_CD = 'ZPARMTES'
/                       
DELETE FROM CI_BATCH_CTRL_P_L WHERE BATCH_CD = 'ZPARMTES'
/                        
DELETE FROM CI_BATCH_CTRL  WHERE BATCH_CD = 'ZPARMTES'
/    