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_PARTY_SITES

Line 50: HZ_PARTY_SITES PARTY_SITE ,

46: ACCT_SITE.org_id,
47: 'N' selected,
48: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
49: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
50: HZ_PARTY_SITES PARTY_SITE ,
51: -- For Bug# 13688313
52: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
53: HZ_LOCATIONS LOC ,
54: FND_TERRITORIES_VL T,

Line 155: HZ_PARTY_SITES PARTY_SITE ,

151: ACCT_SITE.org_id,
152: 'N' selected,
153: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
154: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
155: HZ_PARTY_SITES PARTY_SITE ,
156: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
157: HZ_LOCATIONS LOC ,
158: FND_TERRITORIES_VL T,
159: HZ_CUST_ACCOUNTS HCA,

Line 190: HZ_PARTY_SITES PARTY_SITE ,

186: ACCT_SITE.org_id,
187: 'N' selected,
188: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
189: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
190: HZ_PARTY_SITES PARTY_SITE ,
191: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
192: HZ_LOCATIONS LOC ,
193: FND_TERRITORIES_VL T,
194: HZ_CUST_ACCOUNTS HCA,

Line 923: hz_party_sites party_sites,

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

Line 1123: hz_party_sites party_sites,

1119: SELECT
1120: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1121: FROM
1122: hz_cust_acct_sites acct_sites,
1123: hz_party_sites party_sites,
1124: hz_cust_accounts Cust,
1125: ar_sites_assigned_v Sites_assigned
1126: WHERE -- Sites_assigned.party_id = p_party_id AND
1127: Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)

Line 1257: hz_party_sites party_sites,

1253: SELECT
1254: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1255: FROM
1256: hz_cust_acct_sites acct_sites,
1257: hz_party_sites party_sites,
1258: hz_cust_accounts Cust,
1259: ar_sites_assigned_v Sites_assigned
1260: WHERE Sites_assigned.party_id = p_party_id
1261: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)