## RVY_SEANCES

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
TEXT_LENGTH | 415
TEXT | SELECT DISTINCT C.NUM AS NUM_CRENEAU, E.NUM AS NUM_ETUDIANT, ST.ABSENT FROM RVY_ETUDIANTS E INNER JOIN RVY_ETUDIANTS_GROUPES EG ON E.NUM=EG.NUM_ETUDIANT INNER JOIN RVY_CRENEAUX C ON C.NUM_GROUPE=EG.NUM_GROUPE INNER JOIN RVY_MATIERES M ON C.NUM_MATIERE=M.NUM LEFT JOIN RVY_SEANCES_TMP ST ON (ST.NUM_ETUDIANT=E.NUM AND ST.NUM_CRENEAU=C.NUM) WHERE C.NUM_PROMO=E.NUM_PROMO WITH CHECK OPTION
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