APPS.WSH_ECE_VIEWS_DEF dependencies on HZ_ORG_CONTACTS

Line 976: HZ_ORG_CONTACTS ORG_CONT,

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
980: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'