sql.oracle.PUR_ITM_REAS_ADD_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE PUR_ITM_REAS_ADD_T DROP STORAGE
/
INSERT INTO PUR_ITM_REAS_ADD_T (ITM_REAS_ADD_CD,OBJ_ID,VER_NBR,ITM_REAS_ADD_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('NTOR','4A9AB8C8A74F6B33E0404F8189D86C69',1.0,'Not on Order','Y')
/
INSERT INTO PUR_ITM_REAS_ADD_T (ITM_REAS_ADD_CD,OBJ_ID,VER_NBR,ITM_REAS_ADD_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('SUBS','4A9AB8C8A7506B33E0404F8189D86C69',1.0,'Substitution','Y')
/