APPS.ARW_SEARCH_CUSTOMERS dependencies on ARI_CUSTOMER_SEARCH_V

Line 22: customer_id ari_customer_search_v.customer_id%TYPE,

18: total_score NUMBER(15) := 0
19: );
20:
21: TYPE customer_rectype IS RECORD (
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,

Line 23: DETAILS_LEVEL ari_customer_search_v.DETAILS_LEVEL%TYPE,

19: );
20:
21: TYPE customer_rectype IS RECORD (
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,

Line 24: CUSTOMER_NUMBER ari_customer_search_v.CUSTOMER_NUMBER%TYPE,

20:
21: TYPE customer_rectype IS RECORD (
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,

Line 25: CUSTOMER_NAME ari_customer_search_v.CUSTOMER_NAME%TYPE,

21: TYPE customer_rectype IS RECORD (
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,

Line 27: CONCATENATED_ADDRESS ari_customer_search_v.CONCATENATED_ADDRESS%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,
31: SITE_USES ar_cust_search_gt.SITE_USES%TYPE,

Line 32: ORG_ID ari_customer_search_v.ORG_ID%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,
31: SITE_USES ar_cust_search_gt.SITE_USES%TYPE,
32: ORG_ID ari_customer_search_v.ORG_ID%TYPE,
33: SELECTED VARCHAR2(2),
34: LOCATION VARCHAR2(4000)
35: );
36: