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:
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
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: