329: country,
330: province,
331: county,
332: zip,
333: hz_utility_v2pub.created_by,
334: hz_utility_v2pub.creation_date,
335: hz_utility_v2pub.last_updated_by,
336: hz_utility_v2pub.last_update_date,
337: hz_utility_v2pub.last_update_login,
330: province,
331: county,
332: zip,
333: hz_utility_v2pub.created_by,
334: hz_utility_v2pub.creation_date,
335: hz_utility_v2pub.last_updated_by,
336: hz_utility_v2pub.last_update_date,
337: hz_utility_v2pub.last_update_login,
338: LANG.LANGUAGE_CODE,
331: county,
332: zip,
333: hz_utility_v2pub.created_by,
334: hz_utility_v2pub.creation_date,
335: hz_utility_v2pub.last_updated_by,
336: hz_utility_v2pub.last_update_date,
337: hz_utility_v2pub.last_update_login,
338: LANG.LANGUAGE_CODE,
339: party_id,
332: zip,
333: hz_utility_v2pub.created_by,
334: hz_utility_v2pub.creation_date,
335: hz_utility_v2pub.last_updated_by,
336: hz_utility_v2pub.last_update_date,
337: hz_utility_v2pub.last_update_login,
338: LANG.LANGUAGE_CODE,
339: party_id,
340: dense_rank() over(PARTITION BY sdh_batch_id, party_site_orig_system, party_site_orig_sys_reference, party_id ORDER BY SUPP.ROWID) rnk
333: hz_utility_v2pub.created_by,
334: hz_utility_v2pub.creation_date,
335: hz_utility_v2pub.last_updated_by,
336: hz_utility_v2pub.last_update_date,
337: hz_utility_v2pub.last_update_login,
338: LANG.LANGUAGE_CODE,
339: party_id,
340: dense_rank() over(PARTITION BY sdh_batch_id, party_site_orig_system, party_site_orig_sys_reference, party_id ORDER BY SUPP.ROWID) rnk
341: FROM ap_supplier_sites_int supp, FND_LANGUAGES LANG