商品维护

SELECT DISTINCT NVL(A.ISDRUGCODEFLG,0) AS ISDRUGCODEFLG,A.ISDRUGCODEFLG,A.OWNERID,A.ISPRINTGOODSLIST, 
A.GOODSID, 
A.GOODSTOPCATEGORYID, 
A.GOODSCATEGORYID, 
A.FULLGOODSMOVESTYLE, 
A.ODDGOODSMOVESTYLE, 
A.GOODSTYPEID, 
A.SPELLCODE, 
A.NAME, 
A.TRADEMARK, 
A.MODEL, 
A.LICENSENUMBER, 
A.BATCHFLG, 
A.BIOLOGYFLG, 
NVL(A.HOLDDAYS,0) HOLDDAYS, 
A.PRINTFLG, 
A.SKUBARCODE, 
A.STYLEID, 
A.ABCATTRI, 
A.GOODSMIDCATEGORYID, 
A.PRODAREA, 
A.CHEMICALNAME, 
A.SNAME, 
A.ENGLISHNAME, 
A.GSPFORM, 
A.FORM, 
A.BIGUNIT, 
A.BIGPERNUM, 
A.MIDUNIT, 
A.MIDPERNUM, 
A.STANDUNIT, 
A.STANDGROSSWEIGHT, 
A.STANDNETWEIGHT, 
A.STANDCAP, 
A.ISBIG, 
A.ISMID, 
A.ISSTAND, 
A.STATICSTOCK, 
A.SAFESTOCK, 
A.UPPERSTOCK, 
A.DOWNSTOCK, 
A.BUYPRICE, 
A.CUSTPRICE, 
A.STOCKPRICE, 
A.SALEPRICE, 
A.HOLDDAYTYPE, 
A.REMARK, 
A.CREATOR , 
A.CREATEDATE, 
A.UPDATEMAN, 
A.UPDATEDATE, 
A.TRANSFLG, 
A.OTHER1, 
A.OTHER2, 
A.DOCKLAYER, 
A.DOCKQTY, 
A.DOCKSUM, 
A.ACTIONFLG, 
A.ATTRISTOCKAREA, 
A.ATTRISTOCKFUNCTION, 
A.TEMPTYPEID, 
A.ISBIGUNIT, 
A.PRICETYPE, 
A.LISTPRICE, 
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,TEMPERATURE,TOPTEMP,LOWTEMP,A.ISHSKUBARCODE,nvl(a.MUSTSCANFLG1,0) MUSTSCANFLG1,to_number(nvl(a.ISDONATIONS,0)) ISDONATIONS  
,MAH,FACTORYNAME,FACTORYCODE,FACTORYTYPE,FACTORYLICENSE,ISMINSO, A.SCXKZHBAH,A.YLQXZCRBAR,  
A.STORAGECONDITION,A.ISIMPORTANTMAINTAIN,to_number(nvl(a.ISINSECONDWAREHOUSE,0)) ISINSECONDWAREHOUSE,A.YJMSCANFLG,A.FZDW,A.BZXS,A.BIGSKUBARCODE 
  ,F_GET_BASEDATA_NAME('SYS_OPERTYPE69',A.OPERTYPE) AS OPERTYPE,A.OPERTIME,F_GET_USERNAME(A.OPERMAN) AS OPERMAN , A.INSURANCEAMOUNT,'CQP' AS BUSSNESSTYPE 
from goodsmst A  where 1=1 
AND A.GOODSTOPCATEGORYID IN (1)
order by A.goodsid