Skip to content
Snippets Groups Projects
Select Git revision
  • efa7f7b0aa47e11d10f71db34444c9677bc96219
  • master default protected
  • release_3.0.0
  • test
  • feature_pre_sql
  • develop
  • 3.0.1
  • 3.0.0
  • 2.3.0
  • 2.2.0
  • 2.1.0
  • 2.0.0
  • 1.3.7
  • 1.3.6
  • 1.3.5
  • 1.3.4
  • 1.3.3
  • 1.3.2
  • 1.3.1
  • 1.3.0
  • 1.2.6
  • 1.2.5
  • 1.2.4
  • 1.2.3
  • 1.2.2
  • 1.2.1
26 results

composer.lock

Blame
    • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    SRC_CORPS.sql 408 B 
    CREATE
OR REPLACE FORCE VIEW SRC_CORPS AS
SELECT c.lib_long  libelle_long,
       c.lib_court libelle_court,
       s.id        source_id,
       c.c_corps   source_code
FROM corps@octoprod c
         JOIN source s
              ON s.code = 'Octopus'
WHERE SYSDATE BETWEEN COALESCE(c.d_ouverture, SYSDATE) AND COALESCE(c.d_fermeture + 1, SYSDATE) and c.d_fermeture IS NOT NULL and c.histo_destruction IS NULL