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
|
SELECT *
FROM (SELECT ide_patien1_.pati_id_pati AS x0_0_,
ide_sejour0_.sejo_id_sejo AS x1_0_,
ide_patien1_.pati_nom_usu AS x2_0_,
ide_patien1_.pati_nom_nai AS x3_0_,
ide_patien1_.pati_prenom AS x4_0_,
ide_patien1_.pati_sexe AS x5_0_,
ide_patien1_.pati_nip AS x6_0_,
ide_patien1_.pati_poids AS x7_0_,
ide_patien1_.pati_ind_dec AS x8_0_,
ide_patien1_.pati_nom_usu_maj AS x9_0_,
ide_patien1_.pati_nom_nai_maj AS x10_0_,
ide_patien1_.pati_pre_maj AS x11_0_,
ide_patien1_.pati_dat_nai AS x12_0_,
bas_uf2_.unfo_code AS x13_0_,
bas_uf2_.unfo_libelle AS x14_0_,
bas_etabli3_.etab_lib_etb AS x15_0_,
bas_etabli4_.etab_lib_etb AS x16_0_,
bas_etabli3_.etab_cod_fin AS x17_0_,
bas_etabli4_.etab_cod_fin AS x18_0_,
bas_catalo6_.cape_code AS x19_0_,
bas_catalo6_.cape_libelle AS x20_0_,
ide_sejour0_.sejo_dat_deb AS x21_0_,
ide_sejour0_.sejo_dat_fin AS x22_0_,
ide_sejour0_.sejo_num_sec_soc AS x23_0_,
bas_etabli5_.etab_lib_etb AS x24_0_,
bas_etabli5_.etab_cod_fin AS x25_0_,
ide_sejour0_.sejo_num_sej AS x26_0_,
ide_medeci8_.mede_nom_usu AS x27_0_,
ide_med_ve7_.mese_dat_deb AS x28_0_,
ide_patien1_.pati_dat_dec AS x29_0_,
ide_patien1_.pati_dat_dec AS x30_0_,
ide_sejour0_.sejo_num_arc AS x31_0_,
ide_sejour0_.sejo_statut AS x32_0_
FROM ide_sejour ide_sejour0_,
ide_patient ide_patien1_,
bas_uf bas_uf2_,
bas_etablissement bas_etabli3_,
bas_etablissement bas_etabli4_,
bas_etablissement bas_etabli5_,
bas_catalogue_pers bas_catalo6_,
ide_med_venue ide_med_ve7_,
ide_medecin ide_medeci8_,
ide_adresse ide_adress9_,
bas_type_info bas_type_i11_,
bas_catalogue_gen bas_catalo12_,
bas_type_info bas_type_i13_
WHERE ide_sejour0_.sejo_id_pati = ide_patien1_.pati_id_pati
AND ide_sejour0_.sejo_id_unfo = bas_uf2_.unfo_id_unfo(+)
AND ide_sejour0_.sejo_id_etab_des = bas_etabli3_.etab_id_etab(+)
AND ide_sejour0_.sejo_id_etab_pro = bas_etabli4_.etab_id_etab(+)
AND ide_sejour0_.sejo_id_etab_con = bas_etabli5_.etab_id_etab(+)
AND ide_sejour0_.sejo_id_cape_ven = bas_catalo6_.cape_id_cape(+)
AND ide_sejour0_.sejo_id_sejo = ide_med_ve7_.mese_id_sejo(+)
AND ide_med_ve7_.mese_id_mede = ide_medeci8_.mede_id_mede(+)
AND ( (1 = 1)
AND (ide_patien1_.pati_id_etab = 1059585)
AND (EXISTS (
SELECT pre_prescr10_.prme_id_prme
FROM pre_prescription_liste pre_prescr10_
WHERE (pre_prescr10_.prme_ind_pre_val = '0')
AND ( (pre_prescr10_.prme_ind_pre_val_temp IS NULL
)
OR (pre_prescr10_.prme_ind_pre_val_temp =
'0'
)
)
AND (ide_patien1_.pati_id_pati =
pre_prescr10_.prme_id_pati
))
)
AND (ide_patien1_.pati_id_pati = ide_adress9_.adre_id_obj)
AND ( bas_type_i11_.tyin_code = 'PATIENT'
AND ide_adress9_.adre_id_tyin =
bas_type_i11_.tyin_id_tyin
)
AND ( bas_type_i13_.tyin_code = 'TYPE_ADR_PERS'
AND ide_adress9_.adre_id_cage =
bas_catalo12_.cage_id_cage
AND bas_catalo12_.cage_id_tyin =
bas_type_i13_.tyin_id_tyin
)
AND ( bas_catalo12_.cage_code = 'ADR_PERSO'
AND ide_adress9_.adre_id_cage =
bas_catalo12_.cage_id_cage
)
AND ( bas_etabli5_.etab_id_etab = 1059585
AND ide_sejour0_.sejo_id_etab_con = bas_etabli5_.etab_id_etab(+)
)
AND (ide_sejour0_.sejo_dat_sup IS NULL)
AND (ide_patien1_.pati_dat_sup IS NULL)
AND (ide_patien1_.pati_id_pati_mai IS NULL)
AND (ide_sejour0_.sejo_ind_incomplet = '0')
)
ORDER BY ide_patien1_.pati_nom_usu ASC)
WHERE ROWNUM <= 100 |
Partager