Histórico da Página

...

Bloco de código

language	sql



SELECT 'WMS Geral' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_INTDL','MV_INTWMS','MV_WMSATDT','MV_WMSMABP','MV_WMSMULP','MV_WMSVLDE','MV_WMSVLDT','MV_WMSEXJB','MV_WMSRLSA','MV_WMSRLEN','MV_WMSEMRE','MV_WMSNRPO',
'MV_WMSREFS','MV_WMSNVOL','MV_WMSWCP','MV_WMSDOC','MV_WM300EN')
UNION ALL
SELECT 'WMS Geral' AS 'Classificação Parâmetro',
       'Novo' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSBLQE','MV_WMSROA','MV_WMSEASC','MV_WMSDPCA','MV_WMSROM','MV_WMSRRCL')
UNION ALL
SELECT 'Rádio Frequência' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSRDST','MV_REINAUT','MV_RFINFAZ','MV_WMSLOTE','MV_WMSVSTC','MV_WMSVSTE','MV_WMSAPAN','MV_WMSCOMP','MV_WMSNREG','MV_WMSMDES','MV_ENDFIRF','MV_ENDINRF',
'MV_MAXCONT','MV_RFIDLES','MV_RFIDLEW','MV_RFSLEEP','MV_WMSQSEP','MV_WMSALOT','MV_WMSSQPR','MV_WMSPRIO','MV_TPCONVO')
UNION ALL
SELECT 'Rádio Frequência' AS 'Classificação Parâmetro',
       'Novo' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSFUNC','MV_WMSPFUN','MV_WMSGEEX')
UNION ALL
SELECT 'Rádio Frequência' AS 'Classificação Parâmetro',
       'Atual' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_RADIOF','MV_WMSMTEA','MV_WMSUMI')
UNION ALL
SELECT 'Qualidade' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_CQ','MV_DISTAUT','MV_DOCTRAN')
UNION ALL
SELECT 'Faturamento' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSAGLU')
UNION ALL
SELECT 'Faturamento' AS 'Classificação Parâmetro',
       'Atual' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSRELI')
UNION ALL
SELECT 'Estoque' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_ESTNEG','MV_NTOL1UM','MV_ULMES')
UNION ALL
SELECT 'Estoque' AS 'Classificação Parâmetro',
       'Novo' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSTMMT','MV_WMSTMRQ','MV_WMSTMBR','MV_WMSTPOP','MV_WMSTMCR')
UNION ALL
SELECT 'Controle de Lote' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_LOTEUNI','MV_LOTVENC','MV_RASTRO','MV_FORMLOT')
UNION ALL
SELECT 'Controle de Endereço' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_GERABLQ','MV_LOCALIZ','MV_MT300NG','MV_DESCEND','MV_PDEVLOC')
UNION ALL
SELECT 'Controle de Endereço' AS 'Classificação Parâmetro',
       'Atual' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_CAPLOCA')
UNION ALL
SELECT 'Carga' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSACAR','MV_WMSACEX')
UNION ALL
SELECT 'Recebimento' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSLCFT','MV_WMSENFT','MV_WMSLCEX','MV_WMSENEX','MV_WMSSRFT','MV_WMSSREX')
UNION ALL
SELECT 'Recebimento' AS 'Classificação Parâmetro',
       'Novo' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSSRRE','MV_WMSSRRE','MV_WMSTMFT','MV_WMSTMEX','MV_WMSTMRE','MV_WMSNPCP','MV_WMSDTCF')
UNION ALL
SELECT 'Log' AS 'Classificação Parâmetro',
       'Todos' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_LOGMOV')
UNION ALL
SELECT 'Outros' AS 'Classificação Parâmetro',
       'Não classificado' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_WMSNEW','MV_APDLFOP','MV_APDLOPE','MV_ARRUMAB','MV_BPKFIX','MV_D3SERVI','MV_DLCOLET','MV_ENPK','MV_F4FILOP','MV_FEFOBLF','MV_MIXLTBL','MV_MTNLOTE','MV_MV_RFST',
'MV_NG3STPL','MV_NGSGAES','MV_NGSGAFA','MV_NGSGAPC','MV_NGSGAQN','MV_NGSGASF','MV_NIVBLOC','MV_NIVMIXL','MV_OMSCMSG','MV_RFENDBL','MV_RFENDDE','MV_RFNNORM','MV_RFSTAEX','MV_RFSTAUT',
'MV_RFSTEXE','MV_RFSTINT','MV_RFSTMAN','MV_RFSTPRO','MV_SGADES','MV_SGADEV','MV_SGADTLE','MV_SGAMNT','MV_SGAOCEQ','MV_SGAREQ','MV_SGAWFCR','MV_SRVALI','MV_SRVFAT','MV_SRVWMSE','MV_SRVWMSS',
'MV_USATRT','MV_WMSACES','MV_WMSAEND','MV_WMSALDC','MV_WMSATB2','MV_WMSATCF','MV_WMSBLAP','MV_WMSBLQF','MV_WMSCEXP','MV_WMSCLRH','MV_WMSCNAG','MV_WMSCODP','MV_WMSCONF','MV_WMSCRD',
'MV_WMSCVAC','MV_WMSDAEN','MV_WMSDCFV','MV_WMSDINI','MV_WMSDPES','MV_WMSEEAE','MV_WMSENPK','MV_WMSEQ','MV_WMSEXFT','MV_WMSEXOR','MV_WMSFSEP','MV_WMSGREM','MV_WMSIDUN','MV_WMSLINV',
'MV_WMSLOCI','MV_WMSLREB','MV_WMSPARF','MV_WMSPKFX','MV_WMSPKMA','MV_WMSPRPF','MV_WMSQCBV','MV_WMSQTAP','MV_WMSREAU','MV_WMSREPV','MV_WMSSRRT','MV_WMSTPAP','MV_WMSTPEN','MV_WMSTPOD',
'MV_WMSTRBL','MV_WMSTREM','MV_WMSV070','MV_WMSVDCF','MV_WMSVEMB','MV_WMSVGOS','MV_WMSVLAG','MV_WMSVLEP','MV_WMSVQFP','MV_WMSVSIV','MV_WMSZNSA')
UNION ALL
SELECT 'Documentação' AS 'Classificação Parâmetro',
       'Não classificado' AS 'Tipo WMS',
       X6_VAR AS 'Parâmetro',
       X6_TIPO AS 'Formato',
       X6_CONTEUD AS 'Conteúdo POR',
       X6_CONTEUD AS 'Conteúdo SPA',
       X6_CONTEUD AS 'Conteúdo ENG',
       X6_DESCRIC+X6_DESC1+X6_DESC2 AS 'Descrição'
FROM SX6T10
WHERE X6_VAR IN ('MV_ABRPROJ','MV_ACENTO','MV_AGDMEN','MV_AGLROT','MV_ALIQICM','MV_ANTCRED','MV_ARQPROD','MV_ATUSAL','MV_ATUSI2','MV_ATUSI3','MV_ATUSI4','MV_BOX','MV_BXPROP','MV_CAPLOTE',
'MV_CBASEFAT','MV_CENT','MV_CENT2','MV_CENT3','MV_CENT4','MV_CENT5','MV_COLICMS','MV_COLIPI','MV_COMMIT','MV_COMP','MV_CONSEST','MV_CONTSB','MV_CONTSOC','MV_CSS','MV_CTRLSI6','MV_CTVALZR',
'MV_CUSENT','MV_CUSFIFO','MV_CUSMED','MV_CUSTEXC','MV_CUSTHOR','MV_DATAATE','MV_DATADE','MV_DATAFIS','MV_DATALOT','MV_DIASPRO','MV_DIGPER','MV_DIGVER','MV_DIRCQ','MV_DIRLOG','MV_DOUBLE',
'MV_EASY','MV_ESTADO','MV_EXERC1','MV_EXERC2','MV_EXERC3','MV_EXERC4','MV_EXERC5','MV_FORINSS','MV_FORPRIN','MV_FRETEST','MV_GERAOPI','MV_GERAPI','MV_GERASC','MV_GERIMPV','MV_GRUPO',
'MV_ICMPAD','MV_IDMEMO','MV_IEMASC','MV_IMPINCE','MV_IMPINCS','MV_IMPSX1','MV_IMPTEFC','MV_INDNEG','MV_INSS','MV_INTGFE','MV_IPIVENC','MV_JUROS','MV_LIMAJU','MV_LOCALIZ','MV_LOCPROC',
'MV_LOGERRO','MV_LOGSIGA','MV_MCONTAB','MV_MCUSTO','MV_MESINCC','MV_MILHAR','MV_MIXLYBL','MV_MOEDA1','MV_MOEDA2','MV_MOEDA3','MV_MOEDA4','MV_MOEDA5','MV_MSIDENT','MV_NEGESTR','MV_NIVALT',
'MV_NIVMAX','MV_NORM','MV_NORTE','MV_NPERM','MV_NUMLIN','MV_PAISLOC','MV_PERCIB','MV_PERCIVA','MV_PESOS','MV_PORT','MV_PRELAN','MV_PRINT','MV_PRODAUT','MV_PRODHOR','MV_PRODIMP','MV_PROVA',
'MV_PRXLOTE','MV_REDUZID','MV_RELT','MV_REQAUT','MV_RESERVA','MV_RESPFIS','MV_RODAPE','MV_ROUND','MV_SABFERI','MV_SALTPAG','MV_SEQFIFO','MV_SEQ_LI','MV_SERCUP','MV_SIMB1','MV_SOMAFRE',
'MV_TABGANA','MV_TMPAD','MV_TPCOMIS','MV_TPHR','MV_TPSALDO','MV_TTS','MV_ULRESER','MV_UNIDMOD','MV_VENCIRF','MV_VLDALMO','MV_VLRETIR','MV_WMSCEND','MV_WMSDFS','MV_WMSREAUT','MV_WMSTEA',
'MV_ZERADEM','MV_ZERASAL')

HTML

<!-- esconder o menu --> 


<style>
div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
#main {
    padding-left: 10px;
    padding-right: 10px;
    overflow-x: hidden;
}

.aui-header-primary .aui-nav,  .aui-page-panel {
    margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
    margin-left: 0px !important;
}
</style>

Árvore de páginas

Versões comparadas

Versão antiga 1

Nova versão 2

Chave