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 HZ_PARTIES

Line 53: hz_parties party,

49: 'N' selected,
50: '' location
51: FROM
52: hz_cust_accounts cus,
53: hz_parties party,
54: ra_customer_trx ct
55: WHERE
56: ct.trx_number = p_search_criteria
57: and ct.bill_to_customer_id = cus.cust_account_id

Line 109: -- hz_parties.

105: --
106: -- srajasek 06-APR-00 Changed ra_addresses_all to hz_cust_acct_sites_all because of tca changes in 11.5.1
107:
108: -- modified for tca uptake. replaced ra_customers with hz_cust_accounts and
109: -- hz_parties.
110:
111: -- Bug 2094233
112: -- krmenon 28 Dec 2001 Removed the order by clause for performance issues
113: /*--

Line 120: hz_parties party,

116: CURSOR ctx_cur (p_keyword VARCHAR2) IS
117: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
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