DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on HZ_PARTY_SITE_USES

Line 809: --hz_party_site_uses hpsu,

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,
812: okc_line_styles_b lse_ib,
813: okc_k_lines_b cle_ib,

Line 855: hz_party_site_uses hpsu,

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,
859: okc_line_styles_b lse_inst,