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 ARP_ADDR_LABEL_PKG

Line 737: 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

733: IS
734: -- start abhaxen modiyied for SQL Performance
735:
736: select cle_fin.id fin_line_id,
737: 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
738: from hz_locations hl,
739: csi_item_instances csi,
740: okc_k_items cim_ib,
741: okc_line_styles_b lse_ib,

Line 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

773: IS
774: -- start abhaxen modiyied for SQL Performance
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,

Line 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

820: CURSOR c_get_new_asset_loc(p_dnz_chr_id number)
821: IS
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,