• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• CG_LTRCR_FNDGRP_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.CG_LTRCR_FNDGRP_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE CG_LTRCR_FNDGRP_T DROP STORAGE
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('CNCS','12D4ED2159FBEF34E043814FD881EF34',1.0,'Corp. for Nat''l & Comm. Serv.','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('DHHS','12D4ED2159FCEF34E043814FD881EF34',1.0,'United States Department of Health & Hum','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('DOC','12D4ED2159FDEF34E043814FD881EF34',1.0,'United States Department of Commerce','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('DOEC','12D4ED2159FEEF34E043814FD881EF34',1.0,'United States Department of Energy - Chi','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('DOEO','12D4ED2159FFEF34E043814FD881EF34',1.0,'United States Department of Energy - Oak','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('DOJ','12D4ED215A00EF34E043814FD881EF34',1.0,'United States Department of Justice','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('EPA','12D4ED215A01EF34E043814FD881EF34',1.0,'United States Environmental Protection A','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('GSFC','12D4ED215A02EF34E043814FD881EF34',1.0,'Goddard Space Flight Center','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('HRL','12D4ED215A24EF34E043814FD881EF34',1.0,'Human Rights and Labor','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('HUD','12D4ED215A03EF34E043814FD881EF34',1.0,'Housing and Urban Development','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('JSC','12D4ED215A04EF34E043814FD881EF34',1.0,'Johnson Space Center','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('NASA','12D4ED215A05EF34E043814FD881EF34',1.0,'National Aeronautics and Space Administr','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('NEH','12D4ED215A06EF34E043814FD881EF34',1.0,'National Endowment for the Humanities','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('NOAA','12D4ED215A1DEF34E043814FD881EF34',1.0,'National Oceanic & Atmospheric Admin.','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('NSF','12D4ED215A07EF34E043814FD881EF34',1.0,'National Science Foundation','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('UAID','12D4ED215A08EF34E043814FD881EF34',1.0,'United States Agency for Intntl Develop.','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('USDA','12D4ED215A09EF34E043814FD881EF34',1.0,'United States Department of Agriculture','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('USDE','12D4ED215A0AEF34E043814FD881EF34',1.0,'United States Department of Education','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('USDL','12D4ED215A20EF34E043814FD881EF34',1.0,'U.S. Department of Labor','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('USFS','12D4ED215A0BEF34E043814FD881EF34',1.0,'USDA Forest Service','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('USGS','12D4ED215A1CEF34E043814FD881EF34',1.0,'United States Geological Survey','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('USIA','12D4ED215A0CEF34E043814FD881EF34',1.0,'United States Department of State','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XDEC','12D4ED215A0DEF34E043814FD881EF34',1.0,'Exp U.S. Department of Energy-Chicago','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XDEO','12D4ED215A0EEF34E043814FD881EF34',1.0,'Exp U.S. Department of Energy-Oakridge','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XDOC','12D4ED215A0FEF34E043814FD881EF34',1.0,'Exp United Stated Department of Commerce','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XDOJ','12D4ED215A10EF34E043814FD881EF34',1.0,'Exp U.S. Department of Justice','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XEPA','12D4ED215A11EF34E043814FD881EF34',1.0,'Exp U.S. Environ. Protection Agency','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XGSF','12D4ED215A1BEF34E043814FD881EF34',1.0,'Exp Goddard Space Flight Center','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XHHS','12D4ED215A12EF34E043814FD881EF34',1.0,'Exp United States Dept of Health & Human','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XHRL','12D4ED215A25EF34E043814FD881EF34',1.0,'Expired Human Rights and Labor','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XHUD','12D4ED215A1FEF34E043814FD881EF34',1.0,'Exp Housing and Urban Development','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XNAS','12D4ED215A13EF34E043814FD881EF34',1.0,'Exp Natl. Aeronautics and Space Admin.','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XNEH','12D4ED215A14EF34E043814FD881EF34',1.0,'Exp Nat''l Endowment for the Humanities','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XNOA','12D4ED215A1EEF34E043814FD881EF34',1.0,'Exp National Oceanic & Atmospheric Admin','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XNSF','12D4ED215A15EF34E043814FD881EF34',1.0,'Exp National Science Foundation','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUAG','12D4ED215A22EF34E043814FD881EF34',1.0,'Exp U.S. Dept of Agriculture','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUAI','12D4ED215A16EF34E043814FD881EF34',1.0,'Exp U.S. Agency for Intntl Dev','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUSD','12D4ED215A17EF34E043814FD881EF34',1.0,'Exp U.S. Dept of Agriculture','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUSE','12D4ED215A18EF34E043814FD881EF34',1.0,'Exp United States Department of Educ','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUSG','12D4ED215A1AEF34E043814FD881EF34',1.0,'Exp U.S. Geological Survey','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUSI','12D4ED215A19EF34E043814FD881EF34',1.0,'Exp U.S. Department of State','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUSL','12D4ED215A21EF34E043814FD881EF34',1.0,'Expired U.S. Department of Labor','Y')
/
INSERT INTO CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD,OBJ_ID,VER_NBR,LTRCR_FNDGRP_DESC,ROW_ACTV_IND)
  VALUES ('XUSS','12D4ED215A23EF34E043814FD881EF34',1.0,'Exp U.S. Department of State','Y')
/