[Home] [Help]
795: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
796: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
797: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) party_site_name
798: FROM hz_locations hl,
799: hz_party_sites hps,
800: hz_party_site_uses hpu
801: WHERE hpu.party_site_use_id = p_party_site_use_id
802: AND hps.party_site_id = hpu.party_site_id
803: AND hl.location_id = hps.location_id;
816: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
817: hl.postal_code,null,hl.country,null, null,null,null,null,null,
818: null,'n','n',80,1,1),1,80) party_site_name
819: from hz_locations hl,
820: hz_party_sites hps,
821: csi_item_instances csi,
822: okc_k_items cim_ib,
823: okc_line_styles_b lse_ib,
824: okc_k_lines_b cle_ib,
843: and cim_ib.object1_id1 = csi.instance_id
844: and cim_ib.object1_id2 = '#'
845: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
846: and csi.install_location_id = hps.party_site_id
847: and csi.install_location_type_code = 'HZ_PARTY_SITES'
848: and hps.location_id = hl.location_id
849: and cle_fin.dnz_chr_id = p_chr_id
850: and cle_fin.id = p_clev_fin_id
851: order by cle_fin.id asc;
1081: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
1082: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
1083: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1084: FROM hz_locations hl,
1085: hz_party_sites hps,
1086: hz_cust_acct_sites_all cas,
1087: hz_cust_site_uses_all csu
1088: WHERE csu.site_use_id = p_site_use_id
1089: AND cas.cust_acct_site_id = csu.cust_acct_site_id