供应商信息全SQL

SELECT hou.name,
       pv.vendor_name 供应商,
       pv.party_id,
       pvs.vendor_site_id,
       pvs.terms_id,
       pv.vendor_name_alt 供应商别名,
       hp.known_as 别名,
       cux_rebate_pub.get_lookup_meaning(p_lookup_type => 'VENDOR TYPE',
                                         p_lookup_code => pv.vendor_type_lookup_code) 供应商类型,
       decode(upper(pv.vendor_type_lookup_code),
              'EMPLOYEE',
              papf.national_identifier,
              decode(pv.organization_type_lookup_code,
                     'INDIVIDUAL',
                     pv.individual_1099,
                     'FOREIGN INDIVIDUAL',
                     pv.individual_1099,
                     hp.jgzz_fiscal_code)) 纳税人标识,
       pv.attribute1 是否内部供应商,
       pv.attribute2 快递收件人电话,
       pv.attribute3 快递收件人地址,
       bank.party_name 银行名称,
       branch.party_name 银行分行名称,
       ieba.bank_account_num 银行账号,
       hop.principal_name 法人代表,
       vendor_site.party_site_name 供应商地点,
       vendor_site.vendor_address 地址,
       vendor_site.city 城市,
       vendor_site.postal_code 邮编,
       hpc.person_last_name 联系人姓名,
       /*hcpp.phone_area_code ||'-'||*/
       hcpp.phone_number 电话号码,
       /*hcpf.phone_area_code ||'-'||*/
       cux_inv_item_category_pkg.get_gl_co