• Home
• org.kuali.ole
• ole-master-sql
• 1.6.2
• source code
• FP_DV_MLG_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.FP_DV_MLG_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE FP_DV_MLG_T DROP STORAGE
/
INSERT INTO FP_DV_MLG_T (DV_MLG_EFF_DT,DV_MLG_LMT_AMT,OBJ_ID,VER_NBR,DV_MLG_RT)
  VALUES (TO_DATE( '20030701000000', 'YYYYMMDDHH24MISS' ),0.0,'0D9056D0301839FEE043814FD88139FE',1.0,0.375)
/
INSERT INTO FP_DV_MLG_T (DV_MLG_EFF_DT,DV_MLG_LMT_AMT,OBJ_ID,VER_NBR,DV_MLG_RT)
  VALUES (TO_DATE( '20030701000000', 'YYYYMMDDHH24MISS' ),500.0,'0D9056D0301939FEE043814FD88139FE',1.0,0.18)
/
INSERT INTO FP_DV_MLG_T (DV_MLG_EFF_DT,DV_MLG_LMT_AMT,OBJ_ID,VER_NBR,DV_MLG_RT)
  VALUES (TO_DATE( '20030701000000', 'YYYYMMDDHH24MISS' ),3000.0,'0D9056D0301A39FEE043814FD88139FE',1.0,0.0)
/