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
| SELECT
"DT_CALENDRIERS_TARIFS"."CAL_COD_BASE_TAR"
FROM
"RESERVADM"."DT_LIBELLES_TARIFS" "DT_LIBELLES_TARIFS",
"RESERVADM"."DT_MEDIA" "DT_MEDIA",
"RESERVADM"."DT_LIBEL_CODE_TAR" "DT_LIBEL_CODE_TAR",
"RESERVADM"."DT_LANGUE" "DT_LANGUE",
"RESERVADM"."DT_JOUR_SEMAINE" "DT_JOUR_SEMAINE",
"RESERVADM"."DT_TYP_USER" "DT_TYP_USER",
"RESERVADM"."DT_SAISON" "DT_SAISON",
"RESERVADM"."DT_SAISON_RESIDENCE" "DT_SAISON_RESIDENCE",
"RESERVADM"."VUE_ANNEE_RESIDENCE" "VUE_ANNEE_RESIDENCE",
"RESERVADM"."DT_RESIDENCE" "DT_RESIDENCE",
"RESERVADM"."DT_CATEGORIE" "DT_CATEGORIE",
"RESERVADM"."DT_CALENDRIERS_TARIFS" "DT_CALENDRIERS_TARIFS",
"RESERVADM"."VUE_TARIFS_HEBERGEMENT_GROUPE" "VUE_TARIFS_HEBERGEMENT_GROUPE",
"RESERVADM"."DT_DEVISE" "DT_DEVISE",
"RESERVADM"."DT_LIBEL_BASE_TAR" "DT_LIBEL_BASE_TAR"
WHERE
("DT_SAISON"."NO_SAISON"="DT_SAISON_RESIDENCE"."NO_SAI")
AND ("VUE_ANNEE_RESIDENCE"."CODE_RESIDENCE"="DT_RESIDENCE"."COD_RSD")
AND ("DT_SAISON_RESIDENCE"."COD_RESID_SAI"="DT_RESIDENCE"."COD_RSD")
AND ("DT_RESIDENCE"."CAT_RSD"="DT_CATEGORIE"."COD_CATEGORIE")
AND ("DT_RESIDENCE"."COD_RSD"="DT_CALENDRIERS_TARIFS"."CAL_COD_RSD")
AND ("DT_TYP_USER"."IDTYPEUSER"="DT_CALENDRIERS_TARIFS"."CAL_IDTYPUSER")
AND ("DT_JOUR_SEMAINE"."JRS_ID" (+)="DT_CALENDRIERS_TARIFS"."CAL_JRS_ID")
AND ("DT_LANGUE"."COD_LANGUE"="DT_CALENDRIERS_TARIFS"."CAL_COD_LANGUE")
AND ("DT_LIBEL_CODE_TAR"."COD_CODE_TAR"="DT_CALENDRIERS_TARIFS"."CAL_CODE_TAR")
AND ("DT_MEDIA"."COD_MEDIA" (+)="DT_CALENDRIERS_TARIFS"."CAL_COD_MEDIA")
AND ("DT_LIBELLES_TARIFS"."LIT_CAL_ID"="DT_CALENDRIERS_TARIFS"."CAL_ID")
AND ("DT_LIBELLES_TARIFS"."LIT_ID"="VUE_TARIFS_HEBERGEMENT_GROUPE"."LIT_ID")
AND ("DT_CALENDRIERS_TARIFS"."CAL_COD_DEVISE"="DT_DEVISE"."COD_DEVISE")
AND ("DT_CALENDRIERS_TARIFS"."CAL_COD_BASE_TAR"="DT_LIBEL_BASE_TAR"."COD_BASE_TAR")
AND "DT_CALENDRIERS_TARIFS"."CAL_COD_DEVISE"='E'
AND "DT_CALENDRIERS_TARIFS"."CAL_COD_LANGUE"='F'
AND "DT_CALENDRIERS_TARIFS"."CAL_DUREE_MIN">=4
AND "DT_CALENDRIERS_TARIFS"."CAL_DUREE_MAX"<=999
AND "VUE_ANNEE_RESIDENCE"."ANNEE_COMMERCIALE"='2009'
AND "VUE_ANNEE_RESIDENCE"."DATE_DEBUT"<"DT_CALENDRIERS_TARIFS"."CAL_DATE_FIN_PERIODE"
AND "VUE_ANNEE_RESIDENCE"."DATE_FIN">"DT_CALENDRIERS_TARIFS"."CAL_DATE_DEBUT_PERIODE"
ORDER BY "DT_CALENDRIERS_TARIFS"."CAL_COD_BASE_TAR" |
Partager