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_BILL_EXTRACT dependencies on IGS_PE_PARTYSITEUSE_V

Line 183: igs_pe_partysiteuse_v ppv

179: SELECT 'Y' found_remit_addr
180: FROM igs_or_inst_org_base_v oi,
181: hz_party_sites ps,
182: igs_pe_hz_pty_sites igsps,
183: igs_pe_partysiteuse_v ppv
184: WHERE ps.party_site_id = cp_n_remit_prty_site_id
185: AND ps.party_site_id = ppv.party_site_id
186: AND oi.oi_local_institution_ind = 'Y'
187: AND oi.party_id = ps.party_id

Line 488: igs_pe_partysiteuse_v ppv

484: pav.country,
485: pav.postal_code,
486: pav.delivery_point_code
487: FROM igs_pe_addr_v pav,
488: igs_pe_partysiteuse_v ppv
489: WHERE pav.person_id = p_n_person_id
490: AND pav.party_site_id = ppv.party_site_id
491: AND ppv.site_use_type IN (cp_c_site_usg_type_cd_1,cp_c_site_usg_type_cd_2,cp_c_site_usg_type_cd_3)
492: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(pav.start_dt,SYSDATE))