DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on HZ_RELATIONSHIPS

Line 1090: hz_relationships REL,

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
1093: ACCT_ROLE.party_id = REL.party_id
1094: AND ACCT_ROLE.role_type = 'CONTACT'