## RVY_SEANCES_TMP

Colonnes
Droits
Dépendances
Détails
Déclencheurs

Name | Value
--- | ---
CREATED | 29/09/12
LAST_DDL_TIME | 29/09/12
OWNER | ARELV3
VIEW_NAME | RVY_SEANCES_TMP
TEXT_LENGTH | 420
TEXT | SELECT A.NUM_CRENEAU, A.NUM_ETUDIANT, MIN(A.ABSENT) ABSENT FROM ( SELECT EA.PF_EDT NUM_CRENEAU, EA.PF_GROUPE NUM_ETUDIANT, EA.JUSTIFICATION ABSENT FROM ETUDIANTS_ABSENCES EA UNION SELECT C.NUM NUM_CRENEAU, SB.NUM_ETUDIANT, 'anj' ABSENT FROM RVY_SEANCES_BACKUP SB NATURAL JOIN RVY_CRENEAUX C ) A GROUP BY A.NUM_CRENEAU, A.NUM_ETUDIANT
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