APPS.HZ_CUSTOMER_INT dependencies on HZ_PARTY_SITES

Line 1982: FROM hz_party_sites site, hz_cust_acct_sites_all cust_site -- bug 4454799

1978:
1979:
1980: CURSOR c IS -- Check if the party_site_number already exists
1981: SELECT decode(cust_site.orig_system_reference,p_orig_system_address_ref,'','Y6,')
1982: FROM hz_party_sites site, hz_cust_acct_sites_all cust_site -- bug 4454799
1983: WHERE site.party_site_number = p_party_site_number
1984: AND cust_site.org_id = p_org_id -- bug 4454799
1985: AND site.party_site_id = cust_site.party_site_id;
1986:

Line 2087: hz_party_sites ps,

2083: CURSOR C1 IS
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

Line 2116: FROM hz_party_sites ps

2112: SELECT 'Y'
2113: INTO l_is_remit_to_location
2114: FROM DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM hz_party_sites ps
2117: WHERE ps.location_id = l_location_id
2118: AND ps.party_id = -1
2119: );
2120: EXCEPTION

Line 3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131

3313: FND_GLOBAL.User_ID CREATED_BY,
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

Line 3798: ' FROM HZ_PARTY_SITES ps, ra_customers_interface rci'||

3794: ' UNION ALL ' ||
3795: '(SELECT ps.party_site_id as party_id, ''THIRD_PARTY_SITE'' as party_type_code'||
3796: ', NVL(rci.orig_system_party_ref, rci.orig_system_customer_ref) as intf_party_reference'||
3797: ',ps.orig_system_reference as intf_party_site_reference'||
3798: ' FROM HZ_PARTY_SITES ps, ra_customers_interface rci'||
3799: ' WHERE ps.orig_system_reference = rci.orig_system_address_ref'||
3800: ' AND ps.request_id = rci.request_id'||
3801: ' AND rci.interface_status is null' ||
3802: ' AND rci.insert_update_flag = ''I'''||

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' ||