DBA Data[Home] [Help]

APPS.ARW_SEARCH_CUSTOMERS dependencies on ARI_CUSTOMER_SEARCH_V

Line 30: ari_customer_search_v cus

26: cus.ORG_ID,
27: 'N' selected,
28: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
29: FROM
30: ari_customer_search_v cus
31: WHERE
32: cus.customer_id = p_customer_id
33: ORDER BY DETAILS_LEVEL DESC, cus.address_id;
34:

Line 77: ari_customer_search_v cus

73: cus.ORG_ID,
74: 'N' selected,
75: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
76: FROM
77: ari_customer_search_v cus
78: WHERE
79: cus.CUSTOMER_NUMBER like p_customer_name_number
80: UNION
81: SELECT

Line 96: ari_customer_search_v cus

92: cus.ORG_ID,
93: 'N' selected,
94: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
95: FROM
96: ari_customer_search_v cus
97: WHERE
98: cus.customer_name like p_customer_name_number
99: ORDER BY 2 DESC, 5;
100: