APPS.WSH_ECE_VIEWS_DEF dependencies on HZ_RELATIONSHIPS

Line 975: HZ_RELATIONSHIPS REL,

971: select substrb( REL_PARTY.PERSON_LAST_NAME,1,50) ,
972: substrb( REL_PARTY.PERSON_FIRST_NAME,1,40),
973: ORG_CONT.JOB_TITLE
974: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
975: HZ_RELATIONSHIPS REL,
976: HZ_ORG_CONTACTS ORG_CONT,
977: HZ_PARTIES REL_PARTY
978: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
979: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID