Facebook
From Emerald Parakeet, 1 Year ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 92
  1. CREATE OR REPLACE FORCE VIEW AD_TGFHISLOC
  2. AS
  3. SELECT
  4.     ROW_NUMBER()OVER(ORDER BY CAB.NUNOTA) AS SEQUENCIA,
  5.         ITE.AD_NUEQP AS NUEQP,
  6.         CAB.NUNOTA,
  7.         CAB.CODPARC,
  8.         ITE.AD_DTPREVDEV AS DTPREVDEV,
  9.         CAB.DTNEG AS DTRETIRADA,
  10.         ITE.AD_DTDEVREAL AS DTDEVREAL,
  11.             ITE.AD_DTDEVREAL - ITE.AD_DTPREVDEV AS QTDDIASVENC,
  12.             ((ITE.AD_DTDEVREAL - ITE.AD_DTPREVDEV) * ITE.VLRUNIT) + ITE.VLRTOT AS TOTALMULTA,
  13.              ((ITE.AD_DTDEVREAL - ITE.AD_DTPREVDEV) * ITE.VLRUNIT) AS VLRMULTA,
  14.             ITE.VLRTOT
  15. FROM
  16.     TGFCAB CAB
  17.     INNER JOIN TGFITE ITE ON CAB.NUNOTA = ITE.NUNOTA
  18. WHERE
  19.     CAB.CODTIPOPER = 604
  20.     AND CAB.STATUSNOTA = 'A'
  21.     AND ITE.AD_NUEQP IS NOT NULL
  22. ORDER BY
  23.     CAB.NUNOTA
  24.