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 807: hz_party_sites hps,

803:
804: select cle_fin.id fin_line_id,
805: 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
806: from hz_locations hl,
807: hz_party_sites hps,
808: --Bug# 3569441 :
809: --hz_party_site_uses hpsu,
810: csi_item_instances csi,
811: okc_k_items cim_ib,

Line 838: and csi.install_location_type_code = 'HZ_PARTY_SITES'

834: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
835: --Bug# 3569441 :
836: --and csi.install_location_id = hpsu.party_site_use_id
837: and csi.install_location_id = hps.party_site_id
838: and csi.install_location_type_code = 'HZ_PARTY_SITES'
839: --and hpsu.site_use_type = 'INSTALL_AT'
840: --and hpsu.party_site_id = hps.party_site_id
841: and hps.location_id = hl.location_id
842: and cle_fin.dnz_chr_id = p_dnz_chr_id

Line 854: hz_party_sites hps,

850: -- start abhaxen modiyied for SQL Performance
851: select cle_fin.id fin_line_id,
852: 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
853: from hz_locations hl,
854: hz_party_sites hps,
855: hz_party_site_uses hpsu,
856: okl_txl_itm_insts iti,
857: okc_line_styles_b lse_ib,
858: okc_k_lines_b cle_ib,