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_DEAL_ASSET_PVT dependencies on CSI_ITEM_INSTANCES

Line 766: -- This cursor is used to get Install Site from CSI_ITEM_INSTANCES for Active Contract

762:
763: l_party_site_name VARCHAR2(80);
764:
765: -- gboomina added - Start
766: -- This cursor is used to get Install Site from CSI_ITEM_INSTANCES for Active Contract
767: CURSOR c_install_site_active(p_chr_id NUMBER) IS
768: select cle_ib.id clev_ib_id,
769: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,
770: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,

Line 775: csi_item_instances csi,

771: hl.postal_code,null,hl.country,null, null,null,null,null,null,
772: null,'n','n',80,1,1),1,80) party_site_name
773: from hz_locations hl,
774: hz_party_sites hps,
775: csi_item_instances csi,
776: okc_k_items cim_ib,
777: okc_line_styles_b lse_ib,
778: okc_k_lines_b cle_ib,
779: okc_line_styles_b lse_inst,