SELECT 'CODICE'
|| CHR (9)
|| 'CODICE_FISCALE'
|| CHR (9)
|| 'DATA_IMMATRICOLAZIONE'
FROM DUAL
UNION ALL
SELECT (SELECT D.NUM_COMPITO
FROM P03_IMP_GRA_WS_TST t
JOIN
P03_IMP_GRA_WS_DETT d
ON T.ID = D.IMP_GRA_WS_TST_ID
WHERE t.aa_id = ac.aa_id
AND t.test_id = ac.test_id
AND D.COD_FIS = a.cod_fis
AND ROWNUM = 1)
|| CHR (9)
|| a.cod_fis
|| CHR (9)
|| TO_CHAR (m.data_iscr, 'DD/MM/YYYY')
FROM p01_anaper a
JOIN p03_amm_conc ac
ON a.pers_id = ac.pers_id
JOIN p03_righe_grad r
ON ac.pers_id = r.pers_id AND ac.pos_id = r.pos_id
JOIN p04_mat m
ON m.righe_grad_id = r.righe_grad_id
JOIN p01_stu s
ON m.stu_id = s.stu_id
WHERE r.stato_cod IN ('IM', 'PI')
AND ac.rinuncia_flg = 0
AND ac.aa_id = :
AND ac.test_id IN (:, :)
AND ( ac.tipo_cat_amm_id IS NULL
OR ac.tipo_cat_amm_id =
DECODE (:,
'*', ac.tipo_cat_amm_id,
:))