DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on HZ_RELATIONSHIPS

Line 1188: hz_relationships REL,

1184: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1185: SUBSTRB(PARTY.person_first_name,1,40) first_name
1186: FROM hz_cust_account_roles ACCT_ROLE,
1187: hz_parties PARTY,
1188: hz_relationships REL,
1189: hz_cust_accounts ROLE_ACCT
1190: WHERE
1191: ACCT_ROLE.party_id = REL.party_id
1192: AND ACCT_ROLE.role_type = 'CONTACT'