APPS.OKL_LA_ASSET_PVT dependencies on HZ_LOCATIONS

Line 766: from hz_locations hl,

762: -- start abhaxen modiyied for SQL Performance
763:
764: select cle_fin.id fin_line_id,
765: 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
766: from hz_locations hl,
767: csi_item_instances csi,
768: okc_k_items cim_ib,
769: okc_line_styles_b lse_ib,
770: okc_k_lines_b cle_ib,

Line 792: -- and csi.location_type_code = 'HZ_LOCATIONS'

788: and cim_ib.dnz_chr_id = cle_ib.dnz_chr_id
789: and cim_ib.object1_id1 = csi.instance_id
790: and cim_ib.object1_id2 = '#'
791: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
792: -- and csi.location_type_code = 'HZ_LOCATIONS'
793: -- and csi.location_id = hl.location_id
794: and csi.install_location_type_code = 'HZ_LOCATIONS' -- cklee
795: and csi.install_location_id = hl.location_id -- cklee
796: and cle_fin.dnz_chr_id = p_dnz_chr_id

Line 794: and csi.install_location_type_code = 'HZ_LOCATIONS' -- cklee

790: and cim_ib.object1_id2 = '#'
791: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
792: -- and csi.location_type_code = 'HZ_LOCATIONS'
793: -- and csi.location_id = hl.location_id
794: and csi.install_location_type_code = 'HZ_LOCATIONS' -- cklee
795: and csi.install_location_id = hl.location_id -- cklee
796: and cle_fin.dnz_chr_id = p_dnz_chr_id
797: order by cle_fin.id asc;
798: -- end abhaxen modiyied for SQL Performance

Line 806: from hz_locations hl,

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

Line 853: from hz_locations hl,

849: IS
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,