sql.mysql.CA_MNXFR_ELIM_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE CA_MNXFR_ELIM_T
/
INSERT INTO CA_MNXFR_ELIM_T (FOBJ_MNXFR_ELIM_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FOBJ_MNXFR_ELIM_NM)
VALUES ('E','10253E9DB8CB7EBEE043814FD8817EBE',1.0,'Y','ELIMINATIONS OBJECT')
/
INSERT INTO CA_MNXFR_ELIM_T (FOBJ_MNXFR_ELIM_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FOBJ_MNXFR_ELIM_NM)
VALUES ('M','10253E9DB8CA7EBEE043814FD8817EBE',1.0,'Y','MANDATORY TRANSFER OBJECT')
/
INSERT INTO CA_MNXFR_ELIM_T (FOBJ_MNXFR_ELIM_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FOBJ_MNXFR_ELIM_NM)
VALUES ('N','0CFF4715AAFACB80E043814FD881CB80',1.0,'Y','NEITHER')
/