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

TRUNCATE TABLE PUR_RCVNG_LN_STAT_T DROP STORAGE
/
INSERT INTO PUR_RCVNG_LN_STAT_T (RCVNG_LN_STAT_CD,OBJ_ID,VER_NBR,RCVNG_LN_STAT_DESC)
  VALUES ('APOO','60A6B6F3F0FBFF46E0404F8189D87ACD',1.0,'Awaiting Purchase Order Open Status')
/
INSERT INTO PUR_RCVNG_LN_STAT_T (RCVNG_LN_STAT_CD,OBJ_ID,VER_NBR,RCVNG_LN_STAT_DESC)
  VALUES ('CANC','6224502233A93004E0404F8189D8236B',1.0,'Cancelled')
/
INSERT INTO PUR_RCVNG_LN_STAT_T (RCVNG_LN_STAT_CD,OBJ_ID,VER_NBR,RCVNG_LN_STAT_DESC)
  VALUES ('CMPT','60A6B6F3F0FCFF46E0404F8189D87ACD',1.0,'Complete')
/
INSERT INTO PUR_RCVNG_LN_STAT_T (RCVNG_LN_STAT_CD,OBJ_ID,VER_NBR,RCVNG_LN_STAT_DESC)
  VALUES ('INPR','60A6B6F3F0FAFF46E0404F8189D87ACD',1.0,'In Process')
/