All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.oracle.PUR_SUPP_DVRST_T.sql Maven / Gradle / Ivy

There is a newer version: 1.6.2
Show newest version
TRUNCATE TABLE PUR_SUPP_DVRST_T DROP STORAGE
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('8A','0C41E10B-BF92-26F7-FB83-2391BCCA13BF',1.0,'8(A)','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('DB','827271CE-0830-C915-7F36-DF531602653F',1.0,'DISABLED','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('DV','93F8D388-4FCB-26C8-3FF7-6C18D02EB702',1.0,'DISABLED VETERAN OWNED','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('HZ','CDFA83AC-514C-B88F-C1EF-EF19434928D0',1.0,'HUBZONE','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('MI','A887BD03-79BB-9870-1C75-041702D0366D',1.0,'MBE','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('SB','DEF98788-5BE8-6679-001E-329A1AA59AC7',1.0,'SMALL BUSINESS','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('SD','4C24882F-2A1B-AC17-72F4-3184246DA049',1.0,'SMALL DISADVANTAGED BUSINESS','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('VE','4B3149CA-5989-0962-8EA9-4A2CE489B526',1.0,'VETERAN OWNED','Y')
/
INSERT INTO PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD,OBJ_ID,VER_NBR,VNDR_SUPP_DVRST_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('WO','708CF382-CF52-6978-6EE6-566DB626A6E7',1.0,'WOMAN OWNED BUSINESS','Y')
/




© 2015 - 2024 Weber Informatics LLC | Privacy Policy