APPS.ARW_SEARCH_CUSTOMERS dependencies on HZ_CUST_ACCOUNTS

Line 52: hz_cust_accounts cus,

48: cus.org_id,
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

Line 108: -- modified for tca uptake. replaced ra_customers with hz_cust_accounts and

104: -- Get ALL matching addresses returned by the context search
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

Line 119: hz_cust_accounts cus,

115: -- the order by score since this is necessary to get the high score results
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

Line 788: hz_cust_accounts Cust,

784: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
785: FROM
786: hz_cust_acct_sites acct_sites,
787: hz_party_sites party_sites,
788: hz_cust_accounts Cust,
789: ar_sites_assigned_v Sites_assigned
790: WHERE Sites_assigned.party_id = p_party_id
791: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
792: AND cust.cust_account_id = Sites_assigned.cust_account_id

Line 921: hz_cust_accounts Cust,

917: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
918: FROM
919: hz_cust_acct_sites acct_sites,
920: hz_party_sites party_sites,
921: hz_cust_accounts Cust,
922: ar_sites_assigned_v Sites_assigned
923: WHERE -- Sites_assigned.party_id = p_party_id AND
924: Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
925: AND cust.cust_account_id = Sites_assigned.cust_account_id

Line 1043: hz_cust_accounts Cust,

1039: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1040: FROM
1041: hz_cust_acct_sites acct_sites,
1042: hz_party_sites party_sites,
1043: hz_cust_accounts Cust,
1044: ar_sites_assigned_v Sites_assigned
1045: WHERE Sites_assigned.party_id = p_party_id
1046: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
1047: AND cust.cust_account_id = Sites_assigned.cust_account_id