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

Line 779: hz_party_sites hps,

775:
776: select cle_fin.id fin_line_id,
777: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80) location_id
778: from hz_locations hl,
779: hz_party_sites hps,
780: --Bug# 3569441 :
781: --hz_party_site_uses hpsu,
782: csi_item_instances csi,
783: okc_k_items cim_ib,

Line 810: and csi.install_location_type_code = 'HZ_PARTY_SITES'

806: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
807: --Bug# 3569441 :
808: --and csi.install_location_id = hpsu.party_site_use_id
809: and csi.install_location_id = hps.party_site_id
810: and csi.install_location_type_code = 'HZ_PARTY_SITES'
811: --and hpsu.site_use_type = 'INSTALL_AT'
812: --and hpsu.party_site_id = hps.party_site_id
813: and hps.location_id = hl.location_id
814: and cle_fin.dnz_chr_id = p_dnz_chr_id

Line 826: hz_party_sites hps,

822: -- start abhaxen modiyied for SQL Performance
823: select cle_fin.id fin_line_id,
824: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80) location_id
825: from hz_locations hl,
826: hz_party_sites hps,
827: hz_party_site_uses hpsu,
828: okl_txl_itm_insts iti,
829: okc_line_styles_b lse_ib,
830: okc_k_lines_b cle_ib,