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.OKL_OPI_PVT dependencies on HZ_PARTY_SITES

Line 913: ,hz_party_sites hps

909: ,hl.room
910: ,hl.postal_plus4_code
911: FROM okc_k_party_roles_b opr
912: ,hz_parties hp
913: ,hz_party_sites hps
914: ,hz_locations hl
915: ,hz_party_site_uses hpsu
916: WHERE opr.dnz_chr_id = cp_contract_id
917: AND opr.rle_code = 'GUARANTOR'

Line 1376: FROM hz_party_sites

1372: ,hl.room
1373: ,hl.postal_plus4_code
1374: FROM hz_locations hl
1375: ,(SELECT location_id
1376: FROM hz_party_sites
1377: WHERE party_site_id = cp_location_id) hps
1378: WHERE hl.location_id = hps.location_id;
1379: BEGIN
1380: x_oiav_tbl.delete;