sql.mysql.PUR_PO_CST_SRC_T.sql Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of ole-master-sql
The newest version!
TRUNCATE TABLE PUR_PO_CST_SRC_T
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND,ITM_UNIT_PRC_UPR_VAR_PCT,ITM_UNIT_PRC_LWR_VAR_PCT)
  VALUES ('CON','636024D36C5F8EC6E0404F8189D80405',1.0,'PRICING AGREEMENT FIRM','Y',0.0,0.0)
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND,ITM_UNIT_PRC_UPR_VAR_PCT,ITM_UNIT_PRC_LWR_VAR_PCT)
  VALUES ('COOP','636024D36C608EC6E0404F8189D80405',1.0,'COOPERATIVE AGREEMENT','Y',0.0,0.0)
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND,ITM_UNIT_PRC_UPR_VAR_PCT,ITM_UNIT_PRC_LWR_VAR_PCT)
  VALUES ('EST','636024D36C628EC6E0404F8189D80405',1.0,'ESTIMATE','Y',10.0,50.0)
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('GSA','636024D36C638EC6E0404F8189D80405',1.0,'GSA','Y')
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('QUOT','636024D36C6A8EC6E0404F8189D80405',1.0,'QUOTE','Y')
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND,ITM_UNIT_PRC_UPR_VAR_PCT,ITM_UNIT_PRC_LWR_VAR_PCT)
  VALUES ('UTIL','636024D36C6E8EC6E0404F8189D80405',1.0,'UTILITY','Y',50.0,50.0)
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND,ITM_UNIT_PRC_UPR_VAR_PCT,ITM_UNIT_PRC_LWR_VAR_PCT)
  VALUES ('VAR','636024D36C6F8EC6E0404F8189D80405',1.0,'PRICING AGREEMENT VARIABLE','Y',20.0,50.0)
/
INSERT INTO PUR_PO_CST_SRC_T (PO_CST_SRC_CD,OBJ_ID,VER_NBR,PO_CST_SRC_DESC,DOBJ_MAINT_CD_ACTV_IND)
  VALUES ('VEN','636024D36C708EC6E0404F8189D80405',1.0,'VENDOR PRICE','Y')
/