Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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