Perdasmes Normal / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2018/05/29 16:42:25.981 - 2018/05/29 16:42:25.981 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N GF - Consinco 10.0.0.7 ORACLE Native DBGF 1521 consinco Encrypted 2be98afc86aa7f2e4a816a063d79cacd5 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 1521 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N STRICT_NUMBER_38_INTERPRETATION N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N GF - Vitruvio 10.0.0.7 ORACLE Native DBGF 1521 vitruvio Encrypted 2be98afc86aa7f2e4cb79ce63db9ca7db FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 1521 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N STRICT_NUMBER_38_INTERPRETATION N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N Table input Add sequence Y Add sequence Insert / Update Y Add sequence Sequence Y 1 none BSC_PERDAS Y GF - Vitruvio VITRUVIO BSC_PERDAS_MES_SEQ N 1 1 999999999

208 48 Y Insert / Update InsertUpdate Y 1 none GF - Vitruvio 100 N BSC_FATURAMENTO_PERDAS NROEMPRESA CHAVE_EMPRESA = CHAVE_CATEGORIA_PAI CHAVE_CATEGORIA_PAI = CHAVE_CATEGORIA CHAVE_CATEGORIA = SEQPRODUTO CHAVE_PRODUTO = REFERENCIA REFERENCIA = CHAVE_PERDA BSC_PERDAS N CHAVE_EMPRESA NROEMPRESA N CATEGORIA_PAI CATEGORIAPAI N CATEGORIA CATEGORIA N CHAVE_PRODUTO SEQPRODUTO N DESCRICAO_PRODUTO DESCRICAOPRODUTO Y CHAVE_FAMILIA SEQFAMILIA N QUANTIDADE QTDDIFERENCA Y VALOR_DIFERENCA VLRDIFERENCA Y REFERENCIA REFERENCIA N CHAVE_CATEGORIA_PAI CHAVE_CATEGORIA_PAI N CHAVE_CATEGORIA CHAVE_CATEGORIA N

320 48 Y Table input TableInput Y 1 none GF - Consinco select E.NROEMPRESA, (Select c.seqcategoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 1 and rownum = 1) chave_categoria_pai, (Select c.categoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 1 and rownum = 1) categoriapai, (Select c.seqcategoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 2 and rownum = 1) chave_categoria, (Select c.categoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 2 and rownum = 1) categoria, A.SEQPRODUTO, (Select desccompleta from map_produto where seqproduto = a.seqproduto) descricaoproduto, A.SEQFAMILIA, sum(L3.QTDENTRADACOMPRA / K.QTDEMBALAGEM) + sum(L3.QTDENTRADAOUTRAS / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM) as QTDDIFERENCA, decode((sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) + sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM)), 0, to_number(null), (sum(L3.QTDENTRADACOMPRA / K.QTDEMBALAGEM) + sum(L3.QTDENTRADAOUTRAS / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM)) / (sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) + sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM)) * 100) as QTDDIFERENCAPERC, sum(L3.VLRENTRADACOMPRA) as VLRENTRADACOMPRA, sum(L3.VLRENTRADAOUTRAS) as VLRENTRADAOUTRAS, sum(L3.VLRSAIDAVENDA) as VLRSAIDAVENDA, sum(L3.VLRSAIDAOUTRAS) as VLRSAIDAOUTRAS, sum(L3.VLRENTRADACOMPRA) + sum(L3.VLRENTRADAOUTRAS) - sum(L3.VLRSAIDAVENDA) - sum(L3.VLRSAIDAOUTRAS) as VLRDIFERENCA, decode((sum(L3.VLRSAIDAVENDA) + sum(L3.VLRSAIDAOUTRAS)), 0, to_number(null), (sum(L3.VLRENTRADACOMPRA) + sum(L3.VLRENTRADAOUTRAS) - sum(L3.VLRSAIDAVENDA) - sum(L3.VLRSAIDAOUTRAS)) / (sum(L3.VLRSAIDAVENDA) + sum(L3.VLRSAIDAOUTRAS)) * 100) as VLRDIFERENCAPERC, trunc(sysdate, 'MM') REFERENCIA from MAXV_ABCMOVTOBASE L3, MAP_PRODUTO A, MAP_FAMDIVISAO D, MAP_FAMEMBALAGEM K, MAX_EMPRESA E where A.SEQPRODUTO = L3.SEQPRODUTO and D.SEQFAMILIA = A.SEQFAMILIA and D.NRODIVISAO = 2 and K.SEQFAMILIA = D.SEQFAMILIA and K.QTDEMBALAGEM = fPadraoEmbVenda(D.SEQFAMILIA, D.NRODIVISAO) and L3.DTAENTRADASAIDA between trunc(sysdate, 'MM') and trunc(sysdate) - 2 and E.NROEMPRESA = L3.NROEMPRESA and L3.CODGERALOPER IN (SELECT Z.CODGERALOPER FROM MAX_CODGERALOPER Z WHERE Z.INDFIXOABCMOVIMENTACAO = 'S') and L3.CODGERALOPER in (18, 30, 702, 707, 305, 306, 308, 951, 952, 953, 955, 956, 957) group by E.NROEMPRESA, A.SEQPRODUTO, A.SEQFAMILIA union all select E.NROEMPRESA, (Select c.seqcategoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 1 and rownum = 1) chave_categoria_pai, (Select c.categoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 1 and rownum = 1) categoriapai, (Select c.seqcategoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 2 and rownum = 1) chave_categoria, (Select c.categoria from map_categoria c inner join map_famdivcateg fc on fc.seqcategoria = c.seqcategoria where c.tipcategoria = 'M' and fc.status = 'A' and fc.seqfamilia = a.seqfamilia AND FC.NRODIVISAO = 2 and c.nivelhierarquia = 2 and rownum = 1) categoria, A.SEQPRODUTO, (Select desccompleta from map_produto where seqproduto = a.seqproduto) descricaoproduto, A.SEQFAMILIA, sum(L3.QTDENTRADACOMPRA / K.QTDEMBALAGEM) + sum(L3.QTDENTRADAOUTRAS / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM) as QTDDIFERENCA, decode((sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) + sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM)), 0, to_number(null), (sum(L3.QTDENTRADACOMPRA / K.QTDEMBALAGEM) + sum(L3.QTDENTRADAOUTRAS / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) - sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM)) / (sum(L3.QTDSAIDAVENDA / K.QTDEMBALAGEM) + sum(L3.QTDSAIDAOUTRAS / K.QTDEMBALAGEM)) * 100) as QTDDIFERENCAPERC, sum(L3.VLRENTRADACOMPRA) as VLRENTRADACOMPRA, sum(L3.VLRENTRADAOUTRAS) as VLRENTRADAOUTRAS, sum(L3.VLRSAIDAVENDA) as VLRSAIDAVENDA, sum(L3.VLRSAIDAOUTRAS) as VLRSAIDAOUTRAS, sum(L3.VLRENTRADACOMPRA) + sum(L3.VLRENTRADAOUTRAS) - sum(L3.VLRSAIDAVENDA) - sum(L3.VLRSAIDAOUTRAS) as VLRDIFERENCA, decode((sum(L3.VLRSAIDAVENDA) + sum(L3.VLRSAIDAOUTRAS)), 0, to_number(null), (sum(L3.VLRENTRADACOMPRA) + sum(L3.VLRENTRADAOUTRAS) - sum(L3.VLRSAIDAVENDA) - sum(L3.VLRSAIDAOUTRAS)) / (sum(L3.VLRSAIDAVENDA) + sum(L3.VLRSAIDAOUTRAS)) * 100) as VLRDIFERENCAPERC, trunc(sysdate, 'MM') REFERENCIA from MAXV_ABCMOVTOBASE L3, MAP_PRODUTO A, MAP_FAMDIVISAO D, MAP_FAMEMBALAGEM K, MAX_EMPRESA E where A.SEQPRODUTO = L3.SEQPRODUTO and D.SEQFAMILIA = A.SEQFAMILIA and D.NRODIVISAO = 2 and K.SEQFAMILIA = D.SEQFAMILIA and K.QTDEMBALAGEM = fPadraoEmbVenda(D.SEQFAMILIA, D.NRODIVISAO) and L3.DTAENTRADASAIDA between trunc(sysdate, 'MM') and trunc(sysdate) - 2 and E.NROEMPRESA = L3.NROEMPRESA and L3.CODGERALOPER IN (SELECT Z.CODGERALOPER FROM MAX_CODGERALOPER Z WHERE Z.INDFIXOABCMOVIMENTACAO = 'S') and L3.CODGERALOPER = 2 group by E.NROEMPRESA, A.SEQPRODUTO, A.SEQFAMILIA 0 N N N

96 48 Y N