APPS.HZ_CUSTOMER_INT dependencies on HZ_LOCATIONS

Line 2088: hz_locations loc

2084: SELECT loc.location_id,loc.country,loc.city, loc.state,
2085: loc.county, loc.province, loc.postal_code
2086: FROM hz_cust_acct_sites_all cs, -- bug 4454799
2087: hz_party_sites ps,
2088: hz_locations loc
2089: WHERE cs.orig_system_reference = p_orig_system_address_ref
2090: AND cs.org_id = p_org_id -- bug 4454799
2091: AND ps.party_site_id = cs.party_site_id
2092: AND ps.location_id = loc.location_id;

Line 3318: HZ_LOCATIONS loc --4742586

3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3318: HZ_LOCATIONS loc --4742586
3319: WHERE ps.orig_system_reference = rci.orig_system_address_ref
3320: AND loc.location_id = ps.location_id --4742586
3321: AND ps.request_id = p_request_id
3322: AND rci.interface_status is null

Line 3835: ' FROM HZ_PARTY_SITES ps, ra_customers_interface rci, HZ_LOCATIONS loc '||

3831: ' AND i2.insert_update_flag = ''I''))'||
3832: ' AND (hz_insert.party_type =''ORGANIZATION'' OR hz_insert.party_type =''PERSON''))'||
3833: ' UNION ALL ' ||
3834: '(SELECT ps.party_site_id as party_id, ''THIRD_PARTY_SITE'' as party_type_code, loc.country'||
3835: ' FROM HZ_PARTY_SITES ps, ra_customers_interface rci, HZ_LOCATIONS loc '||
3836: ' WHERE ps.orig_system_reference = rci.orig_system_address_ref'||
3837: ' AND loc.location_id = ps.location_id '||
3838: ' AND ps.request_id = rci.request_id'||
3839: ' AND rci.interface_status is null' ||