Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. RTRIM(TO_CHAR(SUM(DECODE(TO_CHAR(TNFS_SAIDA.DT_EMIS,'RRRR'),TO_CHAR(TRUNC(SYSDATE,'YEAR'),'RRRR'),(TITENS_NFS.VLR_LIQ - TITENS_NFS.VLR_DESC_ZF - TITENS_NFS.VLR_DESC + TITENS_NFS.VLR_FRETE),0)),'FM99999999990D99','NLS_NUMERIC_CHARACTERS=''.,'''),'.')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement