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' ; |
