1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
| SELECT
TRS_FICHE_DPLT.IDFICHE_DPLT AS IDFICHE_DPLT,
TRS_FICHE_DPLT.NUM_FICHE AS NUM_FICHE,
TRS_FICHE_DPLT.NMAT AS NMAT,
TRS_FICHE_DPLT.NOM_PRE AS NOM_PRE,
TRS_FICHE_DPLT.FONC AS FONC,
TRS_FICHE_DPLT.CLASSE_AGENT AS CLASSE_AGENT,
TRS_FICHE_DPLT.UNITE AS UNITE,
TRS_FICHE_DPLT.DIRECTION AS DIRECTION,
TRS_FICHE_DPLT.REGION AS REGION,
TRS_FICHE_DPLT.OBJET_DPLT AS OBJET_DPLT,
TRS_FICHE_DPLT.DATE_DP_PRE AS DATE_DP_PRE,
TRS_FICHE_DPLT.DATE_RT_PRE AS DATE_RT_PRE,
TRS_FICHE_DPLT.DATE_DP AS DATE_DP,
TRS_FICHE_DPLT.DATE_RT AS DATE_RT,
TRS_FICHE_DPLT.TOTAL_PR_DPLT AS TOTAL_PR_DPLT,
TRS_FICHE_DPLT.TOTAL_DPLT AS TOTAL_DPLT,
TRS_FICHE_DPLT.USER_CRE AS USER_CRE,
TRS_FICHE_DPLT.DATE_CRE AS DATE_CRE,
TRS_FICHE_DPLT.USER_MOD AS USER_MOD,
TRS_FICHE_DPLT.DATE_MOD AS DATE_MOD,
TRS_FICHE_DPLT.USER_DEL AS USER_DEL,
TRS_FICHE_DPLT.DATE_DEL AS DATE_DEL,
TRS_FICHE_DPLT.FORFAIT AS FORFAIT,
TRS_FICHE_DPLT.IDLOCALITE_DEPART AS IDLOCALITE_DEPART,
TRS_FICHE_DPLT.IDLOCALITE_DESTINATION AS IDLOCALITE_DESTINATION,
TRS_FICHE_DPLT.IDCPT_DPLT AS IDCPT_DPLT,
TRS_FICHE_DPLT.IDTYPE_DPLT AS IDTYPE_DPLT,
TRS_LOCALITE.IDLOCALITE AS IDLOCALITE,
TRS_LOCALITE.CODE_LOCALITE AS CODE_LOCALITE,
TRS_LOCALITE.LIB_LOCALITE AS LIB_LOCALITE,
TRS_LOCALITE.IDREGION AS IDREGION,
TRS_LOCALITE.COMPLEXE AS COMPLEXE,
TRS_LOCALITE.ETAT AS ETAT_LO,
dest.IDLOCALITE AS dest_IDLOCALITE,
dest.CODE_LOCALITE AS dest_CODE_LOCALITE,
dest.LIB_LOCALITE AS dest_LIB_LOCALITE,
dest.IDREGION AS dest_IDREGION,
dest.COMPLEXE AS dest_COMPLEXE,
dest.ETAT AS dest_ETAT_LO,
res.LIB_LOCALITE AS res_LIB_LOCALITE,
TRS_CMR_CLASSE.IDCMR_CLASSE AS IDCMR_CLASSE,
TRS_CMR_CLASSE.CODE_CLASSE AS CODE_CLASSE,
TRS_CMR_CLASSE.LIB_CLASSE AS LIB_CLASSE,
TRS_TYPE_DPLT.IDTYPE_DPLT AS IDTYPE_DPLT_TY,
TRS_TYPE_DPLT.CODE_DPLT AS CODE_DPLT,
TRS_TYPE_DPLT.LIB_DPLT AS LIB_DPLT,
TRS_TYPE_DPLT.IDTYPE_DECOMPTE AS IDTYPE_DECOMPTE,
TRS_CPT_DPLT.IDCPT_DPLT AS IDCPT_DPLT_CP,
TRS_CPT_DPLT.CODE_CPT AS CODE_CPT,
TRS_CPT_DPLT.LIB_CPT AS LIB_CPT,
TRS_ETAT.LIB_ETAT AS ETAT,
TRS_TYPE_DECOMPTE.CODE_DECOMPTE AS CODE_DECOMPTE
FROM
TRS_CPT_DPLT,
TRS_FICHE_DPLT,
TRS_TYPE_DPLT,
TRS_LOCALITE,
TRS_LOCALITE dest,
TRS_LOCALITE res,
TRS_CMR_CLASSE,
TRS_ETAT,
TRS_TYPE_DECOMPTE
WHERE
TRS_CPT_DPLT.IDCPT_DPLT(+) = TRS_FICHE_DPLT.IDCPT_DPLT
AND TRS_TYPE_DPLT.IDTYPE_DPLT(+) = TRS_FICHE_DPLT.IDTYPE_DPLT
AND TRS_LOCALITE.IDLOCALITE(+) = TRS_FICHE_DPLT.IDLOCALITE_DEPART
AND dest.IDLOCALITE(+) = TRS_FICHE_DPLT.IDLOCALITE_DESTINATION
AND res.IDLOCALITE(+) = TRS_FICHE_DPLT.IDLOCALITE_RESIDENCE
AND TRS_CMR_CLASSE.IDCMR_CLASSE(+) = TRS_FICHE_DPLT.CLASSE_AGENT
AND TRS_ETAT.IDETAT(+) = TRS_FICHE_DPLT.ETAT
AND TRS_TYPE_DPLT.IDTYPE_DECOMPTE = TRS_TYPE_DECOMPTE.IDTYPE_DECOMPTE
AND
(
TRS_FICHE_DPLT.IDFICHE_DPLT IN ({liste_fiche})
) |
Partager