1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| select contratave1_.CONTRACTNUMBER as x0_0_
from V_CONTRAT_AVEC_AVENANTS_ETT contratave1_, ASSIGNMENTS sidesassig0_
where (sidesassig0_.ORG_ID_ETT = contratave1_.ORG_ID_ETT)
and (sidesassig0_.ASS_CONTRACTNUMBER = contratave1_.CONTRACTNUMBER)
and (sidesassig0_.ORG_ID_ETT = 191)
and (sidesassig0_.ASS_CONTRACTNUMBER in
('000000a', '00000a', '0000a', '0000ano', '0000ano', '0001o', '00a',
'0_contrat', '12121', '1232', '123456', '123456', '124587895632',
'2094giga', '2094num', '2203023202telys', '2439', '2439_12',
'2439_14', '2439_15', '2439_16', '2439_17', '2439_26', '2439_27',
'2439_28', '2439_29', '2439_30', '2439_31', '2439_32', '2439_33',
'2439_37', '2439_39', '2439_40', '2439_41', '2439_42', '2439_43',
'2439_44', '2439_5', '2439_50', '2439_53', '2439_54', '2439_57',
'2439_58', '2439_60', '2439_62', '2439_63', '2439_65', '2505',
'564654', '7894894')) |
Partager