APPS.ARW_SEARCH_CUSTOMERS dependencies on HZ_CUST_ACCT_SITES

Line 16: customer_id hz_cust_acct_sites.cust_account_id%TYPE,

12: addr_cnt BINARY_INTEGER := 0
13: );
14:
15: TYPE addr_rec IS RECORD (
16: customer_id hz_cust_acct_sites.cust_account_id%TYPE,
17: addr_seq_num BINARY_INTEGER := 0,
18: total_score NUMBER(15) := 0
19: );
20:

Line 26: ADDRESS_ID hz_cust_acct_sites.cust_acct_site_id%TYPE,

22: customer_id ari_customer_search_v.customer_id%TYPE,
23: DETAILS_LEVEL ari_customer_search_v.DETAILS_LEVEL%TYPE,
24: CUSTOMER_NUMBER ari_customer_search_v.CUSTOMER_NUMBER%TYPE,
25: CUSTOMER_NAME ari_customer_search_v.CUSTOMER_NAME%TYPE,
26: ADDRESS_ID hz_cust_acct_sites.cust_acct_site_id%TYPE,
27: CONCATENATED_ADDRESS ari_customer_search_v.CONCATENATED_ADDRESS%TYPE,
28: CONTACT_NAME ar_cust_search_gt.CONTACT_NAME%TYPE,
29: CONTACT_PHONE ar_cust_search_gt.CONTACT_PHONE%TYPE,
30: BILL_TO_SITE_USE_ID hz_cust_site_uses.SITE_USE_ID%type,