oracle - pls-00402 alias required in select list of cursor to avoid duplicate column names -

my cursor :

  select xzis.msisdn msisdn, xzis.in_account_number in_account_number     xxobw_zte_in_sync xzis    not exists                     (select 1                        hz_contact_points hcp, hz_cust_accounts hca                       hcp.owner_table_id = hca.party_id                             , hcp.owner_table_name = 'hz_parties'                             , hcp.phone_number =                                    substr (xzis.msisdn, -8)                             , nvl (hca.attribute12, 'nil') =                                    xzis.in_account_number); 

i have given alias columns, still facing issue. suggestions?

it's cursor. 1 has no such problems. problem is, when you're joining 2 tables, or apply wrong aliases in subselect, cursor may @ end return 2 columns same name/alias.

the problem not need alias, no 2 columns can have same alias (the name counting alias, when no alias given). apparently has happened, far can tell, it's not in one.