APPS.WSH_ECE_VIEWS_DEF dependencies on HZ_CUST_ACCOUNT_ROLES

Line 43: HZ_CUST_ACCOUNT_ROLES acct_roles

39: INTO
40: cont_area_code_x,
41: WSH_ECE_VIEWS_DEF.cont_phone_number_x
42: FROM HZ_CONTACT_POINTS contact,
43: HZ_CUST_ACCOUNT_ROLES acct_roles
44: WHERE acct_roles.CUST_ACCOUNT_ROLE_ID = contact_id_in
45: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'
46: AND acct_roles.PARTY_ID = contact.owner_table_id(+)
47: AND contact.CONTACT_POINT_TYPE IN ( 'PHONE', 'FAX', 'TELEX')

Line 124: HZ_CUST_ACCOUNT_ROLES hcar

120: contact.PHONE_AREA_CODE Area_Code,
121: contact.PHONE_NUMBER Phone_Number,
122: hcar.cust_acct_site_id acct_site_id
123: FROM HZ_CONTACT_POINTS contact,
124: HZ_CUST_ACCOUNT_ROLES hcar
125: WHERE hcar.CUST_ACCOUNT_ID = p_customer_id
126: AND contact.CONTACT_POINT_TYPE = 'PHONE'
127: AND contact.PRIMARY_FLAG = 'Y'
128: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 954: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

950: cursor l_dlvy_dest_cont_csr (p_contact_id IN NUMBER ) is
951: select substrb( REL_PARTY.PERSON_LAST_NAME,1,50) ,
952: substrb( REL_PARTY.PERSON_FIRST_NAME,1,40),
953: ORG_CONT.JOB_TITLE
954: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
955: HZ_RELATIONSHIPS REL,
956: HZ_ORG_CONTACTS ORG_CONT,
957: HZ_PARTIES REL_PARTY
958: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id