## VUE_RECAP_ETUDIANTS_ABSENCES

Colonnes
Droits
Dépendances
Détails
Déclencheurs

Name | Value
--- | ---
CREATED | 29/09/12
LAST_DDL_TIME | 29/09/12
OWNER | ARELV3
VIEW_NAME | VUE_RECAP_ETUDIANTS_ABSENCES
TEXT_LENGTH | 630
TEXT | select p.objectif programme_libelle,m.libelle matiere_libelle,a.nom,a.prenom,to_char(date_jour_heure_edt(e.annee_civile,e.semaine-1,e.jour,e.hd),'DD/MM/YYYY HH24:MI') date_debut, to_char(date_jour_heure_edt(e.annee_civile,e.semaine-1,e.jour,e.hf),'DD/MM/YYYY HH24:MI') date_fin from programmes p, rels m, edt e, acteurs a, etudiants_absences ea where p.p_id in (select f_programme from programmes_sessions where p_id = e.f_programme_session and f_semainier in (select p_id from semainiers where date_debut <= sysdate and sysdate <= date_fin)) and a.pf_groupe = ea.pf_groupe and e.p_id = ea.pf_edt and m.p_id = e.f_rel
TYPE_TEXT_LENGTH | null
TYPE_TEXT | null
OID_TEXT_LENGTH | null
OID_TEXT | null
VIEW_TYPE_OWNER | null
VIEW_TYPE | null
SUPERVIEW_NAME | null
EDITIONING_VIEW | N
READ_ONLY | N