DBA Data[Home] [Help]

APPS.ARW_SEARCH_CUSTOMERS dependencies on HZ_LOCATIONS

Line 53: HZ_LOCATIONS LOC ,

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,
55: HZ_CUST_ACCOUNTS HCA,
56: HZ_PARTIES HP
57: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 157: HZ_LOCATIONS LOC ,

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,
160: HZ_PARTIES HP
161: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 192: HZ_LOCATIONS LOC ,

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,
195: HZ_PARTIES HP
196: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID