sql.oracle.CA_BDGT_AGGR_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE CA_BDGT_AGGR_T DROP STORAGE
/
INSERT INTO CA_BDGT_AGGR_T (FOBJ_BDGT_AGGR_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FIN_BDGT_AGGR_NM)
VALUES ('C','DCE60A80C7204D5F9C529A99FFDCE1E8',1.0,'Y','OBJECT CONSOLIDATION')
/
INSERT INTO CA_BDGT_AGGR_T (FOBJ_BDGT_AGGR_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FIN_BDGT_AGGR_NM)
VALUES ('L','C90C8F420CF04342A4E099022762F8F8',1.0,'Y','OBJECT LEVEL')
/
INSERT INTO CA_BDGT_AGGR_T (FOBJ_BDGT_AGGR_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FIN_BDGT_AGGR_NM)
VALUES ('O','F48EAC3E871244678B11854DAE9B1B78',439.0,'Y','OBJECT')
/