| ... | ... | @@ -97,7 +97,7 @@ actions as ( -- filtre sur nos actions |
|
|
|
)
|
|
|
|
, id_object_lists AS ( -- recuperation de la liste des id_object liés aux actions selectionnées
|
|
|
|
SELECT
|
|
|
|
a.sysma_action_id
|
|
|
|
a.sysma_action_id
|
|
|
|
, a.sysma_action
|
|
|
|
, a.sysma_action_type_id
|
|
|
|
, a.program_year
|
| ... | ... | |
