SELECTt3.meaning site_vendor_type, pay.ext_payee_id, vd.vendor_type_lookup_code vendor_type_code, t1.meaning vendor_type,--供应商类型 vd.vendor_name,--供应商名称 pb.c_ext_attr1 org_dept_code,--组织机构代码 pb.c_ext_attr8 vendor_classify_code, pb.c_ext_attr3 ledger_name,--法人代表 pb.c_ext_attr4 ledger_card_num,--法人身份证号 pb.c_ext_attr2 business_num,--营业执照号 pb.d_ext_attr1 business_end_date,--营业执照有效期 ft.territory_short_name site_country,--国家 _id, ou.name ou_name,--JD核算机构 vs.vendor_site_code,--地址名称 vs.address_line2,--详细地址 hpc.person_last_name,--姓名 hcpp.phone_number,--电话号码 hcpf.phone_number tax_number,--传真 hcpe.email_address,--邮箱 ft2.territory_short_name bank_country,--国家 ieb.bank_name,--银行名称 iebb.bank_branch_name,--分行名称 iebb.branch_number,--银联号 acc.bank_account_name,--开户名 acc.bank_account_num,--账号 t2.meaning registration_type,--默认申报类型 vd.vat_registration_num,--税号 hca.class_code,--税率 p.payment_method_name,--付款方法 decode(vs.hold_all_payments_flag,'N','否','Y','是') hold_all_payments--付款冻结FROMap_suppliers vd, ap_supplier_sites_all vs, fnd_lookup_values_vl t1, fnd_lookup_values_vl t2, fnd_lookup_values_vl t3, hr_operating_units ou, fnd_territories_vl ft, fnd_territories_vl ft2, pos_supp_prof_ext_b pb, iby_external_payees_all pay, iby_payment_methods_vl p, iby_ext_bank_accounts acc, iby_pmt_instr_uses_all uses, iby_ext_bank_branches_v iebb, iby_ext_banks_v ieb, zx_party_tax_profile zpt, hz_code_assignments hca, hz_parties hpc, hz_contact_points hcpp, hz_contact_points hcpf, hz_contact_points hcpe, hz_relationships hr, hz_contact_points hcppa, hz_contact_points hcppw, ap_supplier_contacts vc, zx_party_tax_profile zpt2 WHEREvd.vendor_id = vs.vendor_id(+) ANDnvl(vs.inactive_date(+),SYSDATE) >=SYSDATE ANDt1.lookup_type(+) ='VENDOR TYPE' ANDt1.enabled_flag(+) ='Y' ANDSYSDATEBETWEENnvl(t1.start_date_active(+), trunc(SYSDATE))ANDnvl(t1.end_date_active(+),SYSDATE+1) ANDvd.vendor_type_lookup_code = t1.lookup_code(+) ANDt3.lookup_type(+) ='VENDOR TYPE' ANDt3.enabled_flag(+) ='Y' ANDSYSDATEBETWEENnvl(t3.start_date_active(+), trunc(SYSDATE))ANDnvl(t3.end_date_active(+),SYSDATE+1) ANDt3.lookup_code(+) = vs.attribute1 anization_id(+) = _id ANDft.territory_code(+) = vs.country ANDpb.attr_group_id(+) =231--按配置的进行更换ANDpb.pk1_value(+) = vs.party_site_id ANDpb.pk2_value(+) = vs.vendor_site_id ANDpay.supplier_site_id(+) = vs.vendor_site_id ANDp.payment_method_code(+) = pay.default_payment_method_code ANDnvl(p.inactive_date(+),SYSDATE) >=SYSDATE ANDacc.ext_bank_account_id(+) = uses.instrument_id AND(uses.instrument_type(+) ='BANKACCOUNT'ORuses.instrument_type(+)ISNULL) ANDuses.ext_pmt_party_id(+) = pay.ext_payee_id ANDSYSDATEBETWEENnvl(uses.start_date(+),SYSDATE)ANDnvl(uses.end_date(+),SYSDATE+1) ANDiebb.branch_party_id(+) = acc.branch_id ANDft2.territory_code(+) = acc.country_code ANDieb.bank_party_id(+) = acc.bank_id ANDzpt.party_id(+) = vs.party_site_id ANDzpt.party_type_code ='THIRD_PARTY_SITE' ANDzpt2.party_id = vd.party_id ANDt2.lookup_code(+) = zpt2.registration_type_code ANDt2.lookup_type(+) ='ZX_REGISTRATIONS_TYPE' ANDt2.enabled_flag(+) ='Y' ANDSYSDATEBETWEENnvl(t2.start_date_active(+), trunc(SYSDATE))ANDnvl(t2.end_date_active(+),SYSDATE+1) ANDhca.owner_table_name(+) ='ZX_PARTY_TAX_PROFILE' ANDtrunc(SYSDATE) >= nvl(trunc(hca.end_date_active(+)), trunc(SYSDATE)) ANDhca.owner_table_id(+) = zpt.party_tax_profile_id ANDSYSDATEBETWEENnvl(hca.start_date_active(+),SYSDATE)ANDnvl(hca.end_date_active(+),SYSDATE+1) ANDhcpp.owner_table_name(+) ='HZ_PARTIES' ANDhcpp.owner_table_id(+) = hr.party_id ANDhcpp.phone_line_type(+) ='GEN' ANDhcpp.contact_point_type(+) ='PHONE' ANDhcpf.owner_table_name(+) ='HZ_PARTIES' ANDhcpf.owner_table_id(+) = hr.party_id ANDhcpf.phone_line_type(+) ='FAX' ANDhcpf.contact_point_type(+) ='PHONE' ANDhcpe.owner_table_name(+) ='HZ_PARTIES' ANDhcpe.owner_table_id(+) = hr.party_id ANDhcpe.contact_point_type(+) ='EMAIL' ANDhcppw.owner_table_id(+) = hr.party_id ANDhcppw.owner_table_name(+) ='HZ_PARTIES' ANDhcppw.status(+) ='A' ANDhcppw.contact_point_type(+) ='WEB' ANDhcppa.owner_table_id(+) = hr.party_id ANDhcppa.owner_table_name(+) ='HZ_PARTIES' ANDhcppa.status(+) ='A' ANDhcppa.contact_point_type(+) ='PHONE' ANDhcppa.phone_line_type(+) ='GEN' ANDhcppa.primary_flag(+) ='N' ANDhr.object_id(+) = hpc.party_id ANDhr.subject_type(+) ='ORGANIZATION' ANDhr.subject_table_name(+) ='HZ_PARTIES' ANDhr.object_table_name(+) ='HZ_PARTIES' ANDhr.object_type(+) ='PERSON' ANDhr.relationship_code(+) ='CONTACT' ANDhr.directional_flag(+) ='B' ANDhr.relationship_type(+) ='CONTACT' ANDSYSDATEBETWEENnvl(hr.start_date(+),SYSDATE)ANDnvl(hr.end_date(+),SYSDATE+1) ANDhcpe.status(+) ='A' ANDhcpe.primary_flag(+) ='Y' ANDhcpp.status(+) ='A' ANDhcpp.primary_flag(+) ='Y' ANDhcpf.status(+) ='A' _party_site_id(+) = vs.party_site_id ANDhpc.party_id(+) = vc.per_party_id
