• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• CA_BDGT_REC_LVL_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.oracle.CA_BDGT_REC_LVL_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE CA_BDGT_REC_LVL_T DROP STORAGE
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('A','3C4DCACBEA9130FEE043814FD88130FE',1.0,'Account','Y')
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('C','3C4DCACBEA9230FEE043814FD88130FE',1.0,'Consolidation','Y')
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('L','3C4DCACBEA9330FEE043814FD88130FE',1.0,'Level','Y')
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('M','3C4DCACBEA9430FEE043814FD88130FE',1.0,'Mixed','Y')
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('N','3C4DCACBEA9530FEE043814FD88130FE',1.0,'No Budget','Y')
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('O','3C4DCACBEA9630FEE043814FD88130FE',1.0,'Object Code','Y')
/
INSERT INTO CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD,OBJ_ID,VER_NBR,BDGT_REC_LVL_NM,ROW_ACTV_IND)
  VALUES ('S','3C4DCACBEA9730FEE043814FD88130FE',1.0,'Sub-Account','Y')
/