[Home] [Help]
753: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
754: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
755: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) party_site_name
756: FROM hz_locations hl,
757: hz_party_sites hps,
758: hz_party_site_uses hpu
759: WHERE hpu.party_site_use_id = p_party_site_use_id
760: AND hps.party_site_id = hpu.party_site_id
761: AND hl.location_id = hps.location_id;
770: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
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,
797: and cim_ib.object1_id1 = csi.instance_id
798: and cim_ib.object1_id2 = '#'
799: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
800: and csi.install_location_id = hps.party_site_id
801: and csi.install_location_type_code = 'HZ_PARTY_SITES'
802: and hps.location_id = hl.location_id
803: and cle_fin.dnz_chr_id = p_chr_id
804: order by cle_fin.id asc;
805: l_install_site_active_rec c_install_site_active%ROWTYPE;
1030: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
1031: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
1032: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1033: FROM hz_locations hl,
1034: hz_party_sites hps,
1035: hz_cust_acct_sites_all cas,
1036: hz_cust_site_uses_all csu
1037: WHERE csu.site_use_id = p_site_use_id
1038: AND cas.cust_acct_site_id = csu.cust_acct_site_id