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 = :<AA_ID/>
       AND ac.test_id IN (:<TEST_ID/>, :<TEST_ID_ESTERNI/>)
       AND (   ac.tipo_cat_amm_id IS NULL
            OR ac.tipo_cat_amm_id =
                  DECODE (:<TIPO_CAT_AMM_ID/>,
                          '*', ac.tipo_cat_amm_id,
                         :<TIPO_CAT_AMM_ID/>))