1084: || ra_cont.first_name contact_name
1085: FROM ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1086: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1087: SUBSTRB(PARTY.person_first_name,1,40) first_name
1088: FROM hz_cust_account_roles ACCT_ROLE,
1089: hz_parties PARTY,
1090: hz_relationships REL,
1091: hz_cust_accounts ROLE_ACCT
1092: WHERE