sql.mysql.PUR_RCVNG_LN_STAT_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE PUR_RCVNG_LN_STAT_T
/
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')
/