以下是我整理的和供应商相关的表结构和重要信息的SQL语句: 1. 供应商主表数据: SELECT ass.vendor_id vendor_id, ass.party_id party_id, ass.segment1 vendor_code, ass.vendor_name vendor_name, ass.vendor_name vendor_short_name, ass.vendor_type_lookup_code vendor_type, flv.meaning vendor_type_meaning, hp.tax_reference tax_registered_name, ass.payment_method_lookup_code payment_method, att.name term_name, att.enabled_flag enabled_flag, att.end_date_active end_date_active, ass.creation_date creation_date, ass.created_by created_by, ass.last_update_date last_update_date, ass.last_updated_by last_updated_by, ass.last_update_login last_update_login FROM ap_suppliers ass, fnd_lookup_values flv, hz_parties hp, ap_terms_tl att WHERE ass.vendor_type_lookup_code = flv.lookup_code(+) AND flv.lookup_type(+) = 'VENDOR TYPE' AND flv.language(+) = userenv('LANG') AND ass.party_id = hp.party_id AND att.language = userenv('LANG') AND ass.terms_id = att.term_id(+) 2. 供应商银行信息: SELECT ass.vendor_id vendor_id, as