商品维护-查询SQL

SELECT 
DISTINCT
    NVL( A.ISDRUGCODEFLG, 0 ) AS ISDRUGCODEFLG,
    A.ISDRUGCODEFLG,
    A.OWNERI D,
    A.ISPRINTGOODSLIST,
    A.GOODSID,
    A.GOODSTOPCATEGORYID,
    A.GOODSCATEGORYID,
    A.FULL GOODSMOVESTYLE,
    A.ODDGOODSMOVESTYLE,
    A.GOODSTYPEID,
    A.SPELLCODE,
    A.NAME,
    A.TRADE MARK,
    A.MODEL,
    A.LICENSENUMBER,
    A.BATCHFLG,
    A.BIOLOGYFLG,
    NVL( A.HOLDDAYS, 0 ) HOLD DAYS,
    A.PRINTFLG,
    A.SKUBARCODE,
    A.STYLEID,
    A.ABCATTRI,
    A.GOODSMIDCATEGORYID,
    A.P RODAREA,
    A.CHEMICALNAME,
    A.SNAME,
    A.ENGLISHNAME,
    A.GSPFORM,
    A.FORM,
    A.BIGUNIT,
    A.BIGPERNUM,
    A.MIDUNIT,
    A.MIDPERNUM,
    A.STANDUNIT,
    A.STANDGROSSWEIGHT,
    A.STANDNETW EIGHT,
    A.STANDCAP,
    A.ISBIG,
    A.ISMID,
    A.ISSTAND,
    A.STATICSTOCK,
    A.SAFESTOCK,
    A.UP PERSTOCK,
    A.DOWNSTOCK,
    A.BUYPRICE,
    A.CUSTPRICE,
    A.STOCKPRICE,
    A.SALEPRICE,
    A.HOL DDAYTYPE,
    A.REMARK,
    A.CREATOR,
    A.CREATEDATE,
    A.UPDATEMAN,
    A.UPDATEDATE,
    A.TRANS FLG,
    A.OTHER1,
    A.OTHER2,
    A.DOCKLAYER,
    A.DOCKQTY,
    A.DOCKSUM,
    A.ACTIONFLG,
    A.ATTRI STOCKAREA,
    A.ATTRISTOCKFUNCTION,
    A.TEMPTYPEID,
    A.ISBIGUNIT,
    A.PRICETYPE,
    A.LISTP RICE,
    A.RETAILPRICE,
    A.TRANSTYPE,
    A.TAXRATE,
    A.MATYPE,
    A.SUMTYPE,
    A.CERTIFIED,
    A.FULLMARK,
    A.IMPORTFLG,
    A.GOODSCORRCODE,
    A.REPORTFLG,
    A.SCANFLG1,
    A.SCANFLG2,
    A.SCANFLG3,
    A.INBOXFLG,
    A.INCACHEFLG,
    A.BUSINESSSCOPE BUSINESSSCOPETEMP,
    A.BUSINESSSCOPE,
    A.PACKAGINGCOMPANYNAME,
    A.CFYFL,
    A.LENGTH,
    A.WIDTH,
    A.HEIGHT,
    TEMPE RATURE,
    TOPTEMP,
    LOWTEMP,
    A.ISHSKUBARCODE,
    nvl( a.MUSTSCANFLG1, 0 ) MUSTSCANFLG1,
    to_num ber ( nvl( a.ISDONATIONS, 0 ) ) ISDONATIONS,
    MAH,
    FACTORYNAME,
    FACTORYCODE,
    FACTORYTYPE,
    FACTORYLICENSE,
    ISMINSO,
    A.SCXKZHBAH,
    A.YLQXZCRBAR,
    A.STORAGECONDITION,
    A.ISIMPORT ANTMAINTAIN,
    to_number( nvl( a.ISINSECONDWAREHOUSE, 0 ) ) ISINSECONDWAREHOUSE,
    A.YJMSCA NFLG,
    A.FZDW,
    A.BZXS,
    A.BIGSKUBARCODE,
    F_GET_BASEDATA_NAME ( 'SYS_OPERTYPE69', A.OPE RTYPE ) AS OPERTYPE,
    A.OPERTIME,
    F_GET_USERNAME ( A.OPERMAN ) AS OPERMAN,
    A.INSURANCE AMOUNT,
    'CQP' AS BUSSNESSTYPE 
FROM
    goodsmst A 
WHERE
    1 = 1 
    AND ( A.GoodsID LIKE 'SKU%' ) 
ORDER BY
    A.goodsid