## RVY_CRENEAUX

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_CRENEAUX
TEXT_LENGTH | 336
TEXT | SELECT CF.NUM, CF.NUM_MATIERE, CF.NUM_GROUPE, CF.NUM_PROMO, CF.DEBUT, CF.FIN, (CASE WHEN EXISTS(SELECT * FROM ETUDIANTS_ABSENCES EA WHERE EA.PF_EDT=CF.NUM) THEN 1 ELSE 0 END) AS BLOQUE FROM RVY_CRENEAUX_FULL CF WHERE UPPER(CF.LOGIN)=(SELECT sys_context('USERENV','SESSION_USER') FROM DUAL) 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