ebs 供应商地点信息_供应商表结构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 as