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 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
|
(
SELECT
LIVRABLE.LIV_INTITULE,
LIVRABLE.LIV_RISK_PROBA,
LIVRABLE.LIV_RISK_IMPACT,
LIVRABLE.LIV_RISK_CRITICITE,
LIVRABLE.LIV_ID_TENDANCE,
LIVRABLE.LIV_RISK_PILOTE,
BLOB_PROJET1.BLB_CONTENT
FROM
LIVRABLE,
BLOB_PROJET BLOB_PROJET1,
PROJET,
UTIL,
SOUS_PROJET
WHERE
( PROJET.PRJ_ID=SOUS_PROJET.SPJ_ID_PROJET )
AND ( SOUS_PROJET.SPJ_ID=LIVRABLE.LIV_ID_SPJ )
AND ( BLOB_PROJET1.BLB_ID_LIV=LIVRABLE.LIV_ID )
AND
(
LIVRABLE.LIV_RISK_CRITICITE > 6
AND
BLOB_PROJET1.BLB_TABLE = 'LIVRABLE'
AND
BLOB_PROJET1.BLB_COL = 'LIV_RISQUE'
AND
( PROJET.PRJ_TITRE = 'respires'
AND (UTIL.USR_NOM = 'PSI' AND PROJET.PRJ_ID_CP = UTIL.USR_ID ) )
)
UNION
SELECT
LIVRABLE.LIV_INTITULE,
LIVRABLE.LIV_RISK_PROBA,
LIVRABLE.LIV_RISK_IMPACT,
LIVRABLE.LIV_RISK_CRITICITE,
LIVRABLE.LIV_ID_TENDANCE,
LIVRABLE.LIV_RISK_PILOTE,
BLOB_PROJET1.BLB_CONTENT
FROM
LIVRABLE,
BLOB_PROJET BLOB_PROJET1,
PROJET,
UTIL,
POLE,
UTIL ucp,
SOUS_PROJET
WHERE
( PROJET.PRJ_ID=SOUS_PROJET.SPJ_ID_PROJET )
AND ( SOUS_PROJET.SPJ_ID=LIVRABLE.LIV_ID_SPJ )
AND ( BLOB_PROJET1.BLB_ID_LIV=LIVRABLE.LIV_ID )
AND
(
LIVRABLE.LIV_RISK_CRITICITE > 6
AND
BLOB_PROJET1.BLB_TABLE = 'LIVRABLE'
AND
BLOB_PROJET1.BLB_COL = 'LIV_RISQUE'
AND
( PROJET.prj_titre = 'respires'
AND ucp.usr_nom = 'PSI'
AND POLE.pol_id_resp = ucp.usr_id
AND ucp.usr_id_pole = POLE.pol_id
AND (UTIL.usr_id = PROJET.prj_id_cp AND POLE.pol_id = UTIL.usr_id_pole )
)
)
UNION
SELECT
LIVRABLE.LIV_INTITULE,
LIVRABLE.LIV_RISK_PROBA,
LIVRABLE.LIV_RISK_IMPACT,
LIVRABLE.LIV_RISK_CRITICITE,
LIVRABLE.LIV_ID_TENDANCE,
LIVRABLE.LIV_RISK_PILOTE,
BLOB_PROJET1.BLB_CONTENT
FROM
LIVRABLE,
BLOB_PROJET BLOB_PROJET1,
PROJET,
UTIL,
PROGRAMME,
SOUS_PROJET
WHERE
( PROJET.PRJ_ID=SOUS_PROJET.SPJ_ID_PROJET )
AND ( SOUS_PROJET.SPJ_ID=LIVRABLE.LIV_ID_SPJ )
AND ( PROJET.PRJ_ID_PROG=PROGRAMME.PRG_ID )
AND ( BLOB_PROJET1.BLB_ID_LIV=LIVRABLE.LIV_ID )
AND
(
LIVRABLE.LIV_RISK_CRITICITE > 6
AND
BLOB_PROJET1.BLB_TABLE = 'LIVRABLE'
AND
BLOB_PROJET1.BLB_COL = 'LIV_RISQUE'
AND
( PROJET.PRJ_TITRE = 'respires'
AND UTIL.USR_NOM='PSI'
AND PROGRAMME.PRG_ID_RESP = UTIL.USR_ID
AND PROGRAMME.PRG_ID=PROJET.PRJ_ID_PROG )
)
) |
Partager