Consultation
N_CPC_FORMATION_DIPLOME
(exécution d'une requête)
Données
Requête
Documentation
STATUT ID
N
CPC FORMATION DIPLOME
CPC
FORMATION
DIPLOME
CPC
GESTIONNAIRE
CPC ETAT
DATE
OUVERTURE
DATE
FERMETURE
DATE
INTERVENTION
NUMERO
COMPTE
GESTION
DIFFUSION
ID
CREATED AT
UPDATED AT
N COMMENTAIRE
DATE
STATUT
1
538
05A
40023001
Rénovation
16/03/2005
16/03/2005
BCNCPC1
02
169
06/07/2021
1
1890
05E
40023001
Remplacé par le n° 40023002
31/08/2006
26/01/2007
BCNCPC1
02
2117
06/07/2021
2 LIGNES TROUVÉES
Nombre de lignes par page :
20
50
100
Voir la requête générée ↓
SELECT
N_CPC_FORMATION_DIPLOME
.
STATUT_ID
AS
A0_STATUT_ID
,
N_CPC_FORMATION_DIPLOME
.
N_CPC_FORMATION_DIPLOME
AS
A0_N_CPC_FORMATION_DIPLOME
,
N_CPC_FORMATION_DIPLOME
.
CPC
AS
A0_CPC
,
N_CPC_FORMATION_DIPLOME
.
FORMATION_DIPLOME
AS
A0_FORMATION_DIPLOME
,
N_CPC_FORMATION_DIPLOME
.
CPC_GESTIONNAIRE
AS
A0_CPC_GESTIONNAIRE
,
N_CPC_FORMATION_DIPLOME
.
CPC_ETAT
AS
A0_CPC_ETAT
,
N_CPC_FORMATION_DIPLOME
.
DATE_OUVERTURE
AS
A0_DATE_OUVERTURE
,
N_CPC_FORMATION_DIPLOME
.
DATE_FERMETURE
AS
A0_DATE_FERMETURE
,
N_CPC_FORMATION_DIPLOME
.
DATE_INTERVENTION
AS
A0_DATE_INTERVENTION
,
N_CPC_FORMATION_DIPLOME
.
NUMERO_COMPTE
AS
A0_NUMERO_COMPTE
,
N_CPC_FORMATION_DIPLOME
.
GESTION_DIFFUSION
AS
A0_GESTION_DIFFUSION
,
N_CPC_FORMATION_DIPLOME
.
ID
AS
A0_ID
,
N_CPC_FORMATION_DIPLOME
.
CREATED_AT
AS
A0_CREATED_AT
,
N_CPC_FORMATION_DIPLOME
.
UPDATED_AT
AS
A0_UPDATED_AT
,
N_CPC_FORMATION_DIPLOME
.
N_COMMENTAIRE
AS
A0_N_COMMENTAIRE
,
N_CPC_FORMATION_DIPLOME
.
DATE_STATUT
AS
A0_DATE_STATUT
FROM
N_CPC_FORMATION_DIPLOME
WHERE
N_CPC_FORMATION_DIPLOME
.
FORMATION_DIPLOME
=
'40023001'
Exporter les données
: Avec clés étrangères
Séparateurs
;
,
|
/bcn/index.php/aide/popup/mod/workspace/act/viewTableQuery
