You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
964 B
21 lines
964 B
src: |
|
|
SELECT p_indicateur_externe.import_id,
|
|
p_indicateur_externe.indicateur_code,
|
|
p_indicateur_externe.finess_id,
|
|
t_finess.code AS finess_code,
|
|
t_finess.texte AS finess_texte,
|
|
t_finess.section_id AS finess_section_id,
|
|
t_finess.section_code AS finess_section_code,
|
|
t_finess.section_texte AS finess_section_texte,
|
|
p_indicateur_externe.pole_id AS rhp_pole_id,
|
|
p_indicateur_externe.service_id,
|
|
t_services.code AS services_code,
|
|
t_services.texte AS services_texte,
|
|
t_services.section_id AS services_section_id,
|
|
t_services.section_code AS services_section_code,
|
|
t_services.section_texte AS services_section_texte,
|
|
p_indicateur_externe.date_reference,
|
|
p_indicateur_externe.value
|
|
FROM rh.p_indicateur_externe
|
|
JOIN rh.t_services ON p_indicateur_externe.service_id = t_services.oid
|
|
LEFT JOIN base.t_finess ON p_indicateur_externe.finess_id = t_finess.oid;
|