## VUE_QCMS_RESULTATS

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_QCMS_RESULTATS
TEXT_LENGTH | 732
TEXT | select qcm.pf_id pf_id_qcm, act.pf_groupe pf_id_repondant, act.nom nom_repondant, act.prenom prenom_repondant, g.libelle libelle_site,que.p_id pf_id_question,que.libelle libelle_question,que.rang rang_question, rep.p_id pf_id_reponse, rep.libelle libelle_reponse, rep.rang rang_reponse from acteurs act, qcms qcm,qcms_reponses rep,qcms_rendus ren,qcms_choix_reponses cho_rep,qcms_questions que, groupes g,groupes_parentes gp, types_groupes tg where cho_rep.pf_rendu = ren.p_id and cho_rep.pf_reponse = rep.p_id and ren.f_groupe = act.pf_groupe and que.f_qcm = qcm.pf_id and rep.f_question = que.p_id and ren.f_qcm = qcm.pf_id and tg.p_id = g.f_type and tg.libelle = 'site' and g.p_id = gp.pf_pere and gp.pf_fils = act.pf_groupe
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