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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| SELECT DISTINCT
TRIM(O_AFFECTATION.ANNEE),
TRIM(O_AFFECTATION.TYBUDGET),
C_CREDIText.CDCRDTSSCH,
O_COMMANDE.CDBONCDE,
O_OPERATION.NUOPER,
O_COMMANDE.LBCMD,
PF_EQLOCALISATION.CDCOIM,
PP_COMPLEXE_UGF.NMCOIM,
O_OPERATION.nuopersuipar,
F_PERSO_SUIVI_OPERATION.NMPERS,
F_PERSO_SUIVI_OPERATION.NUATEL,
O_COMMANDE.MTATTRIB,
O_COMMANDE.NUFOUR,
F_SOUS_TRAITANT.RSFOUR,
O_INTERVENTION.NUOPER + '-' + O_INTERVENTION.NUINTE,
O_INTERVENTION.DTINTESAIS,
O_COMMANDE.DTEMISSBC,
O_INTERVENTION.NUINTESUIPAR,
F_PERSONNEL_SPint.NUATEL,
F_PERSONNEL_SPint.NMPERS+' '+F_PERSONNEL_SPint.PNPERS,
O_COMMANDE.NUENGAG,
O_INTERVENTION.TYINTE,
O_INTERVENTION.TYCRDT,
O_COMMANDE.FGETAT,
O_AFFECTATION.TYCRDT,
N_CREDIT_NATUREext.CDNATURECRDT,
O_AFFECTATION.CDVERSION
FROM
O_INTERVENTION,
O_OPERATION,
PF_EQLOCALISATION,
F_EQUIPEMENT,
O_COMMANDE,
O_AFFECTATION,
PP_COMPLEXE PP_COMPLEXE_UGF,
F_FOURNISSEUR F_SOUS_TRAITANT,
C_CREDIT C_CREDIText,
C_CREDIT_VALIDE C_CREDIT_VALIDEext,
F_PERSONNEL F_PERSO_SUIVI_OPERATION,
F_PERSONNEL F_PERSONNEL_SPint,
N_CREDIT_NATURE N_CREDIT_NATUREext
WHERE
( O_INTERVENTION.NUOPER=O_OPERATION.NUOPER )
AND ( F_EQUIPEMENT.NUEQUI=O_OPERATION.NUEQUI and F_EQUIPEMENT.TYEQUI=O_OPERATION.TYEQUI )
AND ( O_INTERVENTION.NUINTE=O_COMMANDE.NUINTE and O_INTERVENTION.NUOPER=O_COMMANDE.NUOPER )
AND ( O_AFFECTATION.NUOPER=O_COMMANDE.NUOPER and O_AFFECTATION.NUINTE=O_COMMANDE.NUINTE )
AND ( PP_COMPLEXE_UGF.CDCOIM=PF_EQLOCALISATION.CDCOIM )
AND ( PF_EQLOCALISATION.TYEQUI=F_EQUIPEMENT.TYEQUI and PF_EQLOCALISATION.CDEQUI=F_EQUIPEMENT.NUEQUI )
AND ( F_SOUS_TRAITANT.NUFOUR=O_COMMANDE.NUFOUR )
AND ( C_CREDIT_VALIDEext.NUDRGE=C_CREDIText.NUDRGE and C_CREDIT_VALIDEext.NUSDRG=C_CREDIText.NUSDRG and C_CREDIT_VALIDEext.CDARTB=C_CREDIText.CDARTB and C_CREDIT_VALIDEext.TYBUDGET=C_CREDIText.TYBUDGET and C_CREDIT_VALIDEext.CDVERSION=C_CREDIText.CDVERSION and C_CREDIT_VALIDEext.ANCRDV=C_CREDIText.ANCRDT )
AND ( C_CREDIT_VALIDEext.CDARTB=O_AFFECTATION.CDARTB and C_CREDIT_VALIDEext.CDVERSION=O_AFFECTATION.CDVERSION and C_CREDIT_VALIDEext.NUDRGE=O_AFFECTATION.NUDRGE and C_CREDIT_VALIDEext.NUSDRG=O_AFFECTATION.NUSDRG and C_CREDIT_VALIDEext.TYBUDGET=O_AFFECTATION.TYBUDGET and C_CREDIT_VALIDEext.ANCRDV=O_AFFECTATION.ANNEE )
AND ( O_OPERATION.nuopersuipar=F_PERSO_SUIVI_OPERATION.NUPERS )
AND ( O_INTERVENTION.NUINTESUIPAR=F_PERSONNEL_SPint.NUPERS )
AND ( C_CREDIText.CDNATURECRDT=N_CREDIT_NATUREext.CDNATURECRDT )
AND
(
O_OPERATION.DTOPERDEBO >= @prompt('EntréeDATE PREVISION DEBUT:','D','OPERATION\DATE PREVISION DEBUT',Mono,Free,Persistent,,User:0)
AND
O_INTERVENTION.TYINTE = 'S'
AND
O_INTERVENTION.TYCRDT = 'F'
AND
O_COMMANDE.FGETAT IN ( 'M','I','V','A','R' )
) |
Partager