1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
UPDATE COMPTES C
SET C.valeur = (SELECT MIN(AFF.valeur) KEEP(DENSE_RANK FIRST ORDER BY AFF.no_seq)
FROM REF_IMM_T RIT,
SITE STE,
AGENCE AGC,
AFFECTA AFF
WHERE
C.no_ref = RIT.no_ref
AND C.cd_ss = RIT.cd_ss
AND RIT.cd_mm = NVL(AFF.cd_mm, RIT.cd_mm)
AND C.no_ref = STE.no_ref
AND C.cd_site = STE.cd_site
AND AGC.no_ref = 800
AND C.no_ref = AGC.no_ref
AND C.code_RIT = AGC.code_RIT
AND C.indic = NVL(AFF.indic, C.indic)
AND RIT.status = 'A'
)
WHERE
C.no_ref = 800
and C.status = 'B' ; |
Partager