suppliersdetail.sql

本程序是将ORACLE数据库中的表导出成为XML文件的程序。 1. 运行本程序前必须确保机器上已安装JDK 1.4.x 2. 编辑cfg.ini中的参数 3. 运行startup.bat

select s.supplier_id,s.SERVICE_LEVEL,s.accessurl,
s.company_name_en, sg.com_info_title_en,sg.com_info_en, sg.g_cert_pic,sg.g_logo_pic,
sgc.g_faddr_en,sgc.g_fphone,sgc.g_ffax,sgc.g_femail,sgc.g_contact_en,sgc.g_job_title_en,sgc.g_homepage1, sgc.g_homepage2,sgc.g_email 
,
sp.BUILD_YEAR_EN,
sp.PRODUCT_RANGE_EN,                                        
sp.BRAND_EN,
sp.AUTHENTICATION_EN,
sp.AUTHENTICATION_GB,
sp.ADVANDAGE_EN,
sp.CAPITALIZATION,
sp.SALES_VOLUME,
sp.STAFF_AMOUNT,
sp.OEM_FLAG,
sp.EXPORT_PERCERT,
sp.DELIVER_BEFORE_EN,                                                 
sp.MINIORDER_VOLUME_EN,                                           
sp.P_LINE_AMOUNT_EN,
sp.AREA_EN,
sp.MOUTH_CAPACITY_EN,                                           
sp.P_DEVICE_MONEY,
sp.QC_RESPONSIBILITY,
sp.RD_AMOUNT,
sp.ENGINEER_AMOUNT,
sp.QC_AMOUNT,
sp.PAY_TYPE,
sb.TO_MARKET
from suppliers s,sup_general sg,sup_general_contact sgc, sup_profile sp,SUP_BASEINFO sb
where s.supplier_id=sg.supplier_id(+)
and s.supplier_id=sgc.supplier_id(+)
and s.supplier_id=sp.supplier_id(+)
and s.supplier_id=sb.supplier_id(+)
and s.on_level = 'B'