DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on HZ_PARTY_SITE_USES

Line 781: --hz_party_site_uses hpsu,

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,
782: csi_item_instances csi,
783: okc_k_items cim_ib,
784: okc_line_styles_b lse_ib,
785: okc_k_lines_b cle_ib,

Line 827: hz_party_site_uses hpsu,

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,
829: okc_line_styles_b lse_ib,
830: okc_k_lines_b cle_ib,
831: okc_line_styles_b lse_inst,