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

TRUNCATE TABLE PUR_VNDR_INACTV_REAS_T DROP STORAGE
/
INSERT INTO PUR_VNDR_INACTV_REAS_T (VNDR_INACTV_REAS_CD,OBJ_ID,VER_NBR,VNDR_INACTV_REAS_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('ME','17D43179-0F73-BD17-1386-CDD214F9134F',1.0,'MERGED','Y')
/
INSERT INTO PUR_VNDR_INACTV_REAS_T (VNDR_INACTV_REAS_CD,OBJ_ID,VER_NBR,VNDR_INACTV_REAS_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('OB','922043E0-B0C7-21E1-235F-B95391017119',1.0,'OUT OF BUSINESS','Y')
/
INSERT INTO PUR_VNDR_INACTV_REAS_T (VNDR_INACTV_REAS_CD,OBJ_ID,VER_NBR,VNDR_INACTV_REAS_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('SO','9BFCF4E2-C8B0-77DC-F7B5-02D0FF336B7F',1.0,'SOLD','Y')
/