供应商表结构SQL语句

供应商表结构SQL语句 收藏
以下是我整理的和供应商相关的表结构和重要信息的SQL语句：

 1.  供应商主表数据：

 view plaincopy to clipboardprint?
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(+) 
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. 供应商银行信息：

view plaincopy to clipboardprint?
SELECT ass.vendor_id         vendor_id,  
             ass.party_id          party_id,  
             bank.party_id         bank_id,  
             bank.party_name       bank_