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_FI_1098T_EXTRACT_DATA dependencies on HZ_PARTY_SITES

Line 2033: hz_party_sites ps,

2029: SELECT ps.location_id,
2030: ps.identifying_address_flag,
2031: ps.status
2032: FROM hz_party_site_uses hps,
2033: hz_party_sites ps,
2034: igs_pe_hz_pty_sites igsps
2035: WHERE ps.party_id = cp_n_person_id
2036: AND ps.party_site_id = hps.party_site_id
2037: AND hps.site_use_type = cp_v_party_site_use_code

Line 2044: CURSOR cur_locations(cp_location_id hz_party_sites.location_id%TYPE) IS

2040: AND TRUNC(sysdate)
2041: BETWEEN TRUNC(NVL(igsps.start_date,sysdate))
2042: AND TRUNC(NVL(igsps.end_date,sysdate));
2043:
2044: CURSOR cur_locations(cp_location_id hz_party_sites.location_id%TYPE) IS
2045: SELECT loc.address1,
2046: loc.address2,
2047: loc.address3,
2048: loc.address4,