APPS.WSH_ECE_VIEWS_DEF dependencies on HZ_CONTACT_POINTS

Line 42: FROM HZ_CONTACT_POINTS contact,

38: contact.PHONE_NUMBER Phone_Number
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(+)

Line 123: FROM HZ_CONTACT_POINTS contact,

119: SELECT DISTINCT
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'