1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
SELECT UTILISTAEUR,
NUMERO_FICHE,
LE_CODE_ARTICLE,
LE_STATUT,
DATE_STATUT,
MNT_AVOIR,
SOUS_TRAITANT
FROM (SELECT
USERS.NOM UTILISTAEUR,
SAVENTETE.NUMERO NUMERO_FICHE,
SAVENTETEMAT.LIBELLE1_MODELE LE_CODE_ARTICLE,
STATUTS.LIBELLE LE_STATUT,
HISTSTATUT.DATE_MODIF DATE_STATUT,
HISTSTATUT.STATUS_COMMENT MNT_AVOIR,
FOURNISSEURS.NOM SOUS_TRAITANT,
row_number() over(partition by USERS.NOM order by HISTSTATUT.DATE_MODIF desc) rn
FROM HISTSTATUT,STATUTS,USERS,SAVENTETE,FOURNISSEURS,SAVSTAT,SAVENTETEMAT
WHERE HISTSTATUT.ID_STATUT = 4710337
AND SAVSTAT.ID_SIGLNUM_SAVENTETE=HISTSTATUT.ID_SIGLNUM
AND HISTSTATUT.ID_STATUT=STATUTS.ID_STATUT
AND HISTSTATUT.ID_USER=USERS.ID_USER
AND SAVENTETE.ID_SIGLNUM=HISTSTATUT.ID_SIGLNUM
AND SAVENTETEMAT.ID_SIGLNUM=HISTSTATUT.ID_SIGLNUM
AND FOURNISSEURS.ID_FOURNISSEUR=SAVSTAT.ID_ST
AND SAVSTAT.FDATE_CLOT IS NOT NULL
AND HISTSTATUT.DATE_MODIF >=to_date('01/01/20080000','DD/MM/YYYYHH24MI')
AND HISTSTATUT.DATE_MODIF <=to_date('30/06/20080000','DD/MM/YYYYHH24MI'))
where rn =1 |
Partager