eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARW_SEARCH_CUSTOMERS dependencies on CONTAINS

Line 122: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

118: FROM hz_cust_acct_sites_all adr,
119: hz_cust_accounts cus,
120: hz_parties party,
121: ar_system_parameters_all sys
122: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0
123: AND adr.cust_account_id = cus.cust_account_id
124: AND cus.party_id = party.party_id
125: AND adr.org_id = sys.org_id ;
126: ORDER BY score(1) desc, cus.cust_account_id,

Line 133: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

129: /* Bug2288089: Removed _all for hz_cust_acct_sites */
130: CURSOR ctx_cur (p_keyword VARCHAR2) IS
131: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
132: FROM hz_cust_acct_sites adr
133: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0
134: ORDER BY score(1) desc;
135:
136: l_cust_tab cust_tab;
137: l_rev_cust_tab rev_cust_tab;