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.IGS_AD_IMP_026 dependencies on HZ_LOCATIONS

Line 3000: FROM hz_locations, hz_party_sites

2996:
2997: CURSOR check_dup_addr(cp_x_value VARCHAR2,
2998: cp_addr_rec addr_cur%ROWTYPE) IS
2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))

Line 3002: AND hz_party_sites.location_id = hz_locations.location_id

2998: cp_addr_rec addr_cur%ROWTYPE) IS
2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))

Line 3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))

2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))

Line 3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))

3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))

Line 3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))

3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country

Line 3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))

3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country
3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))

Line 3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))

3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country
3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))
3011: AND UPPER(NVL(hz_locations.province,cp_x_value)) = UPPER(NVL(cp_addr_rec.province,cp_x_value));

Line 3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))

3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country
3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))
3011: AND UPPER(NVL(hz_locations.province,cp_x_value)) = UPPER(NVL(cp_addr_rec.province,cp_x_value));
3012:

Line 3009: AND hz_locations.country = cp_addr_rec.country

3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country
3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))
3011: AND UPPER(NVL(hz_locations.province,cp_x_value)) = UPPER(NVL(cp_addr_rec.province,cp_x_value));
3012:
3013: l_addr_rec check_dup_addr%ROWTYPE;

Line 3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))

3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))
3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country
3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))
3011: AND UPPER(NVL(hz_locations.province,cp_x_value)) = UPPER(NVL(cp_addr_rec.province,cp_x_value));
3012:
3013: l_addr_rec check_dup_addr%ROWTYPE;
3014:

Line 3011: AND UPPER(NVL(hz_locations.province,cp_x_value)) = UPPER(NVL(cp_addr_rec.province,cp_x_value));

3007: AND UPPER(NVL(hz_locations.city,cp_x_value)) = UPPER(NVL(cp_addr_rec.city,cp_x_value))
3008: AND UPPER(NVL(hz_locations.state,cp_x_value)) = UPPER(NVL(cp_addr_rec.state,cp_x_value))
3009: AND hz_locations.country = cp_addr_rec.country
3010: AND UPPER(NVL(hz_locations.county,cp_x_value)) = UPPER(NVL(cp_addr_rec.county,cp_x_value))
3011: AND UPPER(NVL(hz_locations.province,cp_x_value)) = UPPER(NVL(cp_addr_rec.province,cp_x_value));
3012:
3013: l_addr_rec check_dup_addr%ROWTYPE;
3014:
3015: BEGIN

Line 3057: hz_locations hl

3053: AND STATUS = '2'
3054: AND EXISTS( SELECT hs.rowid
3055: FROM hz_party_sites hs,
3056: igs_ad_interface_all ad,
3057: hz_locations hl
3058: WHERE ad.interface_id = ai.interface_id AND
3059: hs.party_id = ad.person_id AND
3060: hs.location_id = hl.location_id AND
3061: UPPER(NVL(hl.address1,'X')) = UPPER(NVL(ai.addr_line_1,'X')) AND

Line 3094: FROM hz_locations hl,

3090: WHERE interface_run_id=l_interface_run_id
3091: AND status = '2'
3092: AND match_ind IS NULL
3093: AND EXISTS( SELECT hs.rowid
3094: FROM hz_locations hl,
3095: hz_party_sites hs,
3096: igs_ad_interface_all ad
3097: WHERE ad.interface_id = ai.interface_id AND
3098: hs.party_id = ad.person_id AND

Line 3118: hz_locations hl

3114: match_ind='20',
3115: dup_party_site_id = (SELECT hs.party_site_id
3116: FROM hz_party_sites hs,
3117: igs_ad_interface_all ad,
3118: hz_locations hl
3119: WHERE ad.interface_id = ai.interface_id AND
3120: ROWNUM = 1 AND
3121: hs.party_id = ad.person_id AND
3122: hs.location_id = hl.location_id AND

Line 3138: hz_locations hl

3134: match_ind IS NULL AND
3135: EXISTS (SELECT hs.rowid
3136: FROM hz_party_sites hs,
3137: igs_ad_interface_all ad,
3138: hz_locations hl
3139: WHERE ad.interface_id = ai.interface_id AND
3140: hs.party_id = ad.person_id AND
3141: hs.location_id = hl.location_id AND
3142: UPPER(NVL(hl.address1,'X')) = UPPER(NVL(ai.addr_line_1,'X')) AND