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