1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| WHERE DG_TYPEMARCHECONTRAT = DH_DG_MARCHECONTRAT
AND DG_NUMMARCHECONTRAT = DH_DG_NUMMARCHECONTRAT
AND DH_DG_MARCHECONTRAT = JP_DG_TYPEMARCHECONTRAT
AND DH_DG_NUMMARCHECONTRAT = JP_DG_NUMMARCHECONTRAT
AND DH_NUMLOT = JP_DH_NUMLOT
AND JP_DG_TYPEMARCHECONTRAT = KU_JP_TYPEMARCHECONTRAT
AND JP_DG_NUMMARCHECONTRAT = KU_JP_NUMMARCHECONTRAT
AND JP_DH_NUMLOT = KU_JP_NUMLOT
AND JP_NUMLIGNEFOURNISSEUR = KU_JP_NUMLIGNEFOURNISSEUR
AND CODE_OPERATION = DECODE(KU_KH_CODEOPERATIONSERVICE,
' ',KU_KI_CODEOPERATIONPROGRAMMEE,
KU_KH_CODEOPERATIONSERVICE)
AND qry5.EXERCICE = TO_NUMBER(TO_CHAR(qry5.DATE_DEBUT,'YYYY'))
AND TO_CHAR(qry5.DATE_DEBUT,'YYYY') = TO_CHAR(SYSDATE-1,'YYYY')
AND TO_CHAR(qry5.DATE_FIN,'YYYY') > TO_CHAR(qry5.DATE_DEBUT,'YYYY')
AND qry3.JP_JM_CODETYPEFOURNISSEUR = 'TI'
AND DATE_MAJ >= TO_DATE(DateMinTrav,'DD/MM/YYYY')
AND DATE_MAJ <= TO_DATE(DateMaxTrav,'DD/MM/YYYY')
ORDER BY DG_NUMMARCHECONTRAT ASC |
Partager