## V_ACTEURS

Columns
Grants
Dependencies
Details
Triggers

Name | Value
--- | ---
CREATED | 2011-09-02 09:27:10.0
LAST_DDL_TIME | 2011-09-02 09:27:10.0
OWNER | AREL
VIEW_NAME | V_ACTEURS
TEXT_LENGTH | 1081
TEXT | SELECT g_acteur.p_id AS id, login, nom, prenom, s.libelle AS statut, g_acteur.libelle AS affichage, langue, email, photo, accueil, g_site.libelle AS site, (SELECT g_groupe.libelle FROM groupes g_groupe INNER JOIN groupes_parentes gp_groupe ON g_groupe.p_id = gp_groupe.pf_pere WHERE g_groupe.libelle IN ('A', 'B', 'C', 'D', 'E', 'F') AND gp_groupe.pf_fils = g_acteur.p_id) AS groupe, (SELECT g_admin.libelle FROM groupes g_admin INNER JOIN groupes_parentes gp_admin ON g_admin.p_id = gp_admin.pf_pere INNER JOIN types_groupes tg_admin ON (g_admin.f_type = tg_admin.p_id AND tg_admin.libelle = 'statut') WHERE g_admin.libelle = 'admin' AND gp_admin.pf_fils = g_acteur.p_id) AS admin FROM acteurs a INNER JOIN groupes g_acteur ON a.pf_groupe = g_acteur.p_id INNER JOIN statuts s ON a.f_statut = s.p_id INNER JOIN groupes_parentes gp_site ON g_acteur.p_id = gp_site.pf_fils INNER JOIN groupes g_site ON gp_site.pf_pere = g_site.p_id INNER JOIN types_groupes tg_site ON (g_site.f_type = tg_site.p_id AND tg_site.libelle = 'site')
TYPE_TEXT_LENGTH | null
TYPE_TEXT | null
OID_TEXT_LENGTH | null
OID_TEXT | null
VIEW_TYPE_OWNER | null
VIEW_TYPE | null
SUPERVIEW_NAME | null