Fallo de View Prueba
Publicado por Caleb (13 intervenciones) el 27/11/2020 18:01:29
Buenas tardes, alguien sabe porque me muestra error esta creación de vista? Lo último que le añadí fue el CASE
"PTIVELEMENTSINSPECTION5. CASE ELEMENTSINSPECTION.WIDTHUOMCODE WHEN 'M' THEN ELEMENTSINSPECTION.WIDTHNET * 100 WHEN 'CM' THEN ELEMENTSINSPECTION.WIDTHNET ELSE 0 END ANCHO_CMS"
--CREACIÓN DE LA VISTA
CREATE VIEW PTIVELEMENTSINSPECTION5_PRUEBA (COMPANYCODE, TIPO_A, REFERENCIA, CLAVE2, CLAVE3, CLAVE4, CLAVE5, CLAVE6, CLAVE7, CALVE8, CLAVE9, CLAVE10, ROLLO, CALIDAD, COD_RAZON_CALIDAD, DESCRIP_RAZON_CALIDAD, DEFECTO, NOMBRE_DEFECTO, PLANTA_CAUSANTE, POSI_INICIO_DEFEC, METROS_FABRICADOS, KGS_FAB, CANT_UNIDADES, KGS_ESTANDAR_UN, LOTE, CONTADOR_DEMANDA, COD_DEMANDA, UM_PRIMARIA_DEMANDA, CANTPRI_PLANEADA_DEMANDA, UM_SECUNDARIA_DEMANDA, CANTSECU_PLANEADA_DEMANDA, VARIANTE, COMPOSICION, TA_ELEMENTO_CRUDO, ELEMENTO_CRUDO, CANT_KG_CRUDO, TELAR, DM_ORIGINAL, CAUSA_DEL_ARREGLO, TA_PREFIJADO, ELEMENTO_PREFIJADO, CANT_KG_PREFIJADO, CONT_DEMANA_PREFIJADO, DEMANDA_PREFIJADO, MAQUINA_PREFIJADO, FECHA_PREFIJADO, FORMULA_PREFIJADO, TINTURA, FECHA_TINTURA, RAMAACABADO, FECHA_RAMA, TA_PIEZA, PIEZA, LINEA_MERCADO, DESCRIP_LINEA_MERCADO, FECHA_FIN_INSPE, OPERARIO, PLANTILLA_FORMULA, DESCRIP_PLANTILLA_FORMULA, TIPODEMANDA, ESTADO_VENTA, ESTADO_PRODUCCION) AS SELECT PTITELEMENTSINSPECTION.COMPANYCODE, TRIM(NVL(PTITELEMENTSINSPECTION.ITEMTYPEAFICODE,'')) TIPO_A, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE01,'')) REFERENCIA, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE02,'')) CLAVE2, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE03,'')) CLAVE3, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE04,'')) CLAVE4, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE05,'')) CLAVE5, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE06,'')) CLAVE6, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE07,'')) CLAVE7, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE08,'')) CALVE8, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE09,'')) CLAVE9, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE10,'')) CLAVE10, PTITELEMENTSINSPECTION.ELEMENTCODE ROLLO, TRIM(NVL(CHAR(ELEMENTSINSPECTION.QUALITYCODE),'')) CALIDAD, TRIM(NVL(ELEMENTSINSPECTION.QUALITYREASONCODE,'')) COD_RAZON_CALIDAD, TRIM(NVL(QualityReason.LONGDESCRIPTION,'')) DESCRIP_RAZON_CALIDAD, '' DEFECTO, '' NOMBRE_DEFECTO, '' PLANTA_CAUSANTE, 0 POSI_INICIO_DEFEC, CASE ELEMENTSINSPECTION.WIDTHUOMCODE WHEN 'M' THEN ELEMENTSINSPECTION.WIDTHNET * 100 WHEN 'CM' THEN ELEMENTSINSPECTION.WIDTHNET ELSE 0 END ANCHO_CMS, CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) /100 AS DECIMAL(10,5)) WHEN 'm' THEN CAST((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) AS DECIMAL(10,5)) ELSE 0 END METROS_FABRICADOS, CASE WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE ='g' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CAST ( ROUND ( (((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) * ELEMENTSINSPECTION.WEIGHTREALNET)/ELEMENTSINSPECTION.LENGTHGROSS)/1000, 2 ) AS DECIMAL(10,5) ) WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE = 'kg' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CAST(ROUND((((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) * ELEMENTSINSPECTION.WEIGHTREALNET)/ELEMENTSINSPECTION.LENGTHGROSS),2) AS DECIMAL(10,5)) ELSE 0 END KGS_FAB, 0 CANT_UNIDADES, 0 KGS_ESTANDAR_UN, PTITELEMENTSINSPECTION.LOTE, PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE CONTADOR_DEMANDA, PTITELEMENTSINSPECTION.DEMANDCODE COD_DEMANDA, BASEPRIMARYUOMCODEDM UM_PRIMARIA_DEMANDA, BASEPRIMARYQUANTITYDM CANTPRI_PLANEADA_DEMANDA, BASESECONDARYUOMCODEDM UM_SECUNDARIA_DEMANDA, BASESECONDARYQUANTITYDM CANTSECU_PLANEADA_DEMANDA, TRIM(NVL(PTITELEMENTSINSPECTION.VARIANTE,'')) VARIANTE, PTITELEMENTSINSPECTION.COMPOSITIONDESCR COMPOSICION, PTITELEMENTSINSPECTION.ITEMTYPECODECRUDO TA_ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.ELEMENTCODECRUDO ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.CRUDOQUANTITYKG CANT_KG_CRUDO, SUBSTR(PTITELEMENTSINSPECTION.ELEMENTCODECRUDO,4,3) TELAR, PTITELEMENTSINSPECTION.EXTERNALREFERENCE DM_ORIGINAL, PTITELEMENTSINSPECTION.INTERNALREFERENCE CAUSA_DEL_ARREGLO, PTITELEMENTSINSPECTION.ITEMTYPECODEPREFIJA TA_PREFIJADO, PTITELEMENTSINSPECTION.ELEPREFIJADO ELEMENTO_PREFIJADO, PTITELEMENTSINSPECTION.PREFIJADOQUANTITYKG CANT_KG_PREFIJADO, PTITELEMENTSINSPECTION.CONTDEMPREFI CONT_DEMANA_PREFIJADO, PTITELEMENTSINSPECTION.DEMANDAPREFI DEMANDA_PREFIJADO, PTITELEMENTSINSPECTION.MAQUINAPREFI MAQUINA_PREFIJADO, PTITELEMENTSINSPECTION.FECHAPREFI FECHA_PREFIJADO, PTITELEMENTSINSPECTION.FORMULAPREFIJA FORMULA_PREFIJADO, PTITELEMENTSINSPECTION.TINTURA, PTITELEMENTSINSPECTION.FECHAPROTIN FECHA_TINTURA, PTITELEMENTSINSPECTION.RAMAACABADO, PTITELEMENTSINSPECTION.FECHAPRORAMA FECHA_RAMA, PTITELEMENTSINSPECTION.ORIGINALELELMENTITEMTYPECODE TA_PIEZA, PTITELEMENTSINSPECTION.ORIGINALELEMENTCODE PIEZA, PTITELEMENTSINSPECTION.MERCADO LINEA_MERCADO, PTITELEMENTSINSPECTION.DESCRMERCADO DESCRIP_LINEA_MERCADO, PTITELEMENTSINSPECTION.INSPECTIONENDDATETIME FECHA_FIN_INSPE, TRIM(NVL(ELEMENTSINSPECTION.OPERATORCODE,'')) OPERARIO, PTITELEMENTSINSPECTION.ACABADO PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.DESCRACABADO DESCRIP_PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.TIPODEMANDA, PROFIKDSTATE.SALESSTATECODE ESTADO_VENTA, PROFIKDSTATE.PRODUCTIONSTATECODE ESTADO_PRODUCCION FROM DB2ADMIN.PTITELEMENTSINSPECTION PTITELEMENTSINSPECTION INNER JOIN ELEMENTSINSPECTION ELEMENTSINSPECTION ON ELEMENTSINSPECTION.COMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ELEMENTSINSPECTION.ELEMENTITEMTYPECODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE AND ELEMENTSINSPECTION.ELEMENTCODE = PTITELEMENTSINSPECTION.ELEMENTCODE AND ELEMENTSINSPECTION.INSPECTIONINDEX = PTITELEMENTSINSPECTION.INSPECTIONINDEX AND ELEMENTSINSPECTION.QUALITYCODE = 1 LEFT OUTER JOIN QualityReason QualityReason ON QualityReason.OWNINGCOMPANYCODE= ELEMENTSINSPECTION.COMPANYCODE AND QualityReason.CODE = ELEMENTSINSPECTION.QUALITYREASONCODE LEFT OUTER JOIN PROFIKDSTATE ON PTITELEMENTSINSPECTION.COMPANYCODE = PROFIKDSTATE.COMPANYCODE AND PTITELEMENTSINSPECTION.ITEMTYPEAFICODE = PROFIKDSTATE.ITEMTYPECODE AND (PTITELEMENTSINSPECTION.SUBCODE01 = PROFIKDSTATE.DECOSUBCODE01 OR PTITELEMENTSINSPECTION.SUBCODE01 = '') AND (PTITELEMENTSINSPECTION.SUBCODE02 = PROFIKDSTATE.DECOSUBCODE02 OR PTITELEMENTSINSPECTION.SUBCODE02 = '') AND (PTITELEMENTSINSPECTION.SUBCODE03 = PROFIKDSTATE.DECOSUBCODE03 OR PTITELEMENTSINSPECTION.SUBCODE03 = '') AND (PTITELEMENTSINSPECTION.SUBCODE04 = PROFIKDSTATE.DECOSUBCODE04 OR PTITELEMENTSINSPECTION.SUBCODE04 = '') AND (PTITELEMENTSINSPECTION.SUBCODE05 = PROFIKDSTATE.DECOSUBCODE05 OR PTITELEMENTSINSPECTION.SUBCODE05 = '') AND (PTITELEMENTSINSPECTION.SUBCODE06 = PROFIKDSTATE.DECOSUBCODE06 OR PTITELEMENTSINSPECTION.SUBCODE06 = '') AND (PTITELEMENTSINSPECTION.SUBCODE07 = PROFIKDSTATE.DECOSUBCODE07 OR PTITELEMENTSINSPECTION.SUBCODE07 = '') AND (PTITELEMENTSINSPECTION.SUBCODE08 = PROFIKDSTATE.DECOSUBCODE08 OR PTITELEMENTSINSPECTION.SUBCODE08 = '') AND (PTITELEMENTSINSPECTION.SUBCODE09 = PROFIKDSTATE.DECOSUBCODE09 OR PTITELEMENTSINSPECTION.SUBCODE09 = '') AND (PTITELEMENTSINSPECTION.SUBCODE10 = PROFIKDSTATE.DECOSUBCODE10 OR PTITELEMENTSINSPECTION.SUBCODE10 = '') LEFT OUTER JOIN ITEMTYPE ON ITEMTYPE.OWNINGCOMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ITEMTYPE.CODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE UNION ALL SELECT PTITELEMENTSINSPECTION.COMPANYCODE, TRIM(NVL(PTITELEMENTSINSPECTION.ITEMTYPEAFICODE,'')) TIPO_A, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE01,'')) REFERENCIA, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE02,'')) CLAVE2, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE03,'')) CLAVE3, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE04,'')) CLAVE4, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE05,'')) CLAVE5, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE06,'')) CLAVE6, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE07,'')) CLAVE7, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE08,'')) CALVE8, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE09,'')) CLAVE9, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE10,'')) CLAVE10, PTITELEMENTSINSPECTION.ELEMENTCODE ROLLO, CASE WHEN (ELEMENTSINSPECTIONEVENT.CREDITS > 0 AND ELEMENTSINSPECTION.TOTALCREDITS > 0 AND ELEMENTSINSPECTIONEVENT.EVENTVALUE IS NULL) THEN 'B' WHEN (ELEMENTSINSPECTIONEVENT.CREDITS > 0 AND ELEMENTSINSPECTION.TOTALCREDITS > 0 AND ELEMENTSINSPECTIONEVENT.EVENTVALUE IS NOT NULL) THEN TRIM(ELEMENTSINSPECTIONEVENT.EVENTVALUE) WHEN (ELEMENTSINSPECTION.TOTALCREDITS = 0 AND ELEMENTSINSPECTIONEVENT.EVENTVALUE IS NULL) THEN TRIM(CHAR(ELEMENTSINSPECTION.QUALITYCODE)) ELSE TRIM(NVL(ELEMENTSINSPECTIONEVENT.EVENTVALUE,'')) END CALIDAD, TRIM(NVL(ELEMENTSINSPECTION.QUALITYREASONCODE,'')) COD_RAZON_CALIDAD, TRIM(NVL(QualityReason.LONGDESCRIPTION,'')) DESCRIP_RAZON_CALIDAD, TRIM(NVL(ELEMENTSINSPECTIONEVENT.CODEEVENTCODE,'')) DEFECTO, TRIM(NVL(INSPECTIONEVENTTEMPLATE.LONGDESCRIPTION,'')) NOMBRE_DEFECTO, SUBSTR( NVL(ELEMENTSINSPECTIONEVENT.VARIABLE,''),1,30) PLANTA_CAUSANTE, ELEMENTSINSPECTIONEVENT.STARTPOSITION POSI_INICIO_DEFEC, CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST(ELEMENTSINSPECTIONEVENT.LENGHT /100 AS DECIMAL(10,5)) WHEN 'm' THEN CAST(ELEMENTSINSPECTIONEVENT.LENGHT AS DECIMAL(10,5)) ELSE 0 END METROS_FABRICADOS, CASE WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE ='g' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST ( ( ( ELEMENTSINSPECTIONEVENT.LENGHT /100 ) * (ELEMENTSINSPECTION.WEIGHTREALNET /1000) ) / (ELEMENTSINSPECTION.LENGTHGROSS/100) AS DECIMAL(10,5) ) WHEN 'm' THEN CAST ( ( (ELEMENTSINSPECTIONEVENT.LENGHT)*(ELEMENTSINSPECTION.WEIGHTREALNET /1000) ) / (ELEMENTSINSPECTION.LENGTHGROSS) AS DECIMAL(10,5) ) END WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE = 'kg' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST(((ELEMENTSINSPECTIONEVENT.LENGHT /100) * (ELEMENTSINSPECTION.WEIGHTREALNET ))/ (ELEMENTSINSPECTION.LENGTHGROSS /100) AS DECIMAL(10,5)) WHEN 'm' THEN CAST(((ELEMENTSINSPECTIONEVENT.LENGHT) * (ELEMENTSINSPECTION.WEIGHTREALNET ))/ (ELEMENTSINSPECTION.LENGTHGROSS) AS DECIMAL(10,5)) END ELSE 0 END KGS_FAB, 0 CANT_UNIDADES, 0 KGS_ESTANDAR_UN, PTITELEMENTSINSPECTION.LOTE, PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE CONTADOR_DEMANDA, PTITELEMENTSINSPECTION.DEMANDCODE COD_DEMANDA, BASEPRIMARYUOMCODEDM UM_PRIMARIA_DEMANDA, BASEPRIMARYQUANTITYDM CANTPRI_PLANEADA_DEMANDA, BASESECONDARYUOMCODEDM UM_SECUNDARIA_DEMANDA, BASESECONDARYQUANTITYDM CANTSECU_PLANEADA_DEMANDA, TRIM(NVL(PTITELEMENTSINSPECTION.VARIANTE,'')) VARIANTE, PTITELEMENTSINSPECTION.COMPOSITIONDESCR COMPOSICION, PTITELEMENTSINSPECTION.ITEMTYPECODECRUDO TA_ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.ELEMENTCODECRUDO ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.CRUDOQUANTITYKG CANT_KG_CRUDO, SUBSTR(PTITELEMENTSINSPECTION.ELEMENTCODECRUDO,4,3) TELAR, PTITELEMENTSINSPECTION.EXTERNALREFERENCE DM_ORIGINAL, PTITELEMENTSINSPECTION.INTERNALREFERENCE CAUSA_DEL_ARREGLO, PTITELEMENTSINSPECTION.ITEMTYPECODEPREFIJA TA_PREFIJADO, PTITELEMENTSINSPECTION.ELEPREFIJADO ELEMENTO_PREFIJADO, PTITELEMENTSINSPECTION.PREFIJADOQUANTITYKG CANT_KG_PREFIJADO, PTITELEMENTSINSPECTION.CONTDEMPREFI CONT_DEMANA_PREFIJADO, PTITELEMENTSINSPECTION.DEMANDAPREFI DEMANDA_PREFIJADO, PTITELEMENTSINSPECTION.MAQUINAPREFI MAQUINA_PREFIJADO, PTITELEMENTSINSPECTION.FECHAPREFI FECHA_PREFIJADO, PTITELEMENTSINSPECTION.FORMULAPREFIJA FORMULA_PREFIJADO, PTITELEMENTSINSPECTION.TINTURA, PTITELEMENTSINSPECTION.FECHAPROTIN FECHA_TINTURA, PTITELEMENTSINSPECTION.RAMAACABADO, PTITELEMENTSINSPECTION.FECHAPRORAMA FECHA_RAMA, PTITELEMENTSINSPECTION.ORIGINALELELMENTITEMTYPECODE TA_PIEZA, PTITELEMENTSINSPECTION.ORIGINALELEMENTCODE PIEZA, PTITELEMENTSINSPECTION.MERCADO LINEA_MERCADO, PTITELEMENTSINSPECTION.DESCRMERCADO DESCRIP_LINEA_MERCADO, PTITELEMENTSINSPECTION.INSPECTIONENDDATETIME FECHA_FIN_INSPE, TRIM(NVL(ELEMENTSINSPECTION.OPERATORCODE,'')) OPERARIO, PTITELEMENTSINSPECTION.ACABADO PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.DESCRACABADO DESCRIP_PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.TIPODEMANDA, PROFIKDSTATE.SALESSTATECODE ESTADO_VENTA, PROFIKDSTATE.PRODUCTIONSTATECODE ESTADO_PRODUCCION FROM DB2ADMIN.PTITELEMENTSINSPECTION PTITELEMENTSINSPECTION INNER JOIN ELEMENTSINSPECTION ELEMENTSINSPECTION ON ELEMENTSINSPECTION.COMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ELEMENTSINSPECTION.ELEMENTITEMTYPECODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE AND ELEMENTSINSPECTION.ELEMENTCODE = PTITELEMENTSINSPECTION.ELEMENTCODE AND ELEMENTSINSPECTION.INSPECTIONINDEX = PTITELEMENTSINSPECTION.INSPECTIONINDEX INNER JOIN DB2ADMIN.ELEMENTSINSPECTIONEVENT ELEMENTSINSPECTIONEVENT ON ELEMENTSINSPECTIONEVENT.ELEMENTSINSPECTIONCOMPANYCODE = ELEMENTSINSPECTION.COMPANYCODE AND ELEMENTSINSPECTIONEVENT.ELEMENTSINSELMITEMTYPECODE = ELEMENTSINSPECTION.ELEMENTITEMTYPECODE AND ELEMENTSINSPECTIONEVENT.ELEMENTSINSPECTIONELEMENTCODE = ELEMENTSINSPECTION.ELEMENTCODE AND ELEMENTSINSPECTIONEVENT.ELEMENTSINSINSPECTIONINDEX = ELEMENTSINSPECTION.INSPECTIONINDEX LEFT OUTER JOIN DB2ADMIN.INSPECTIONEVENTTEMPLATE INSPECTIONEVENTTEMPLATE ON INSPECTIONEVENTTEMPLATE.COMPANYCODE = ELEMENTSINSPECTIONEVENT.ELEMENTSINSPECTIONCOMPANYCODE AND INSPECTIONEVENTTEMPLATE.ITEMTYPECODE = ELEMENTSINSPECTIONEVENT.ELEMENTSINSELMITEMTYPECODE AND INSPECTIONEVENTTEMPLATE.EVENTCODE = ELEMENTSINSPECTIONEVENT.CODEEVENTCODE LEFT OUTER JOIN QualityReason QualityReason ON QualityReason.OWNINGCOMPANYCODE= ELEMENTSINSPECTION.COMPANYCODE AND QualityReason.CODE = ELEMENTSINSPECTION.QUALITYREASONCODE LEFT OUTER JOIN PROFIKDSTATE ON PTITELEMENTSINSPECTION.COMPANYCODE = PROFIKDSTATE.COMPANYCODE AND PTITELEMENTSINSPECTION.ITEMTYPEAFICODE = PROFIKDSTATE.ITEMTYPECODE AND (PTITELEMENTSINSPECTION.SUBCODE01 = PROFIKDSTATE.DECOSUBCODE01 OR PTITELEMENTSINSPECTION.SUBCODE01 = '') AND (PTITELEMENTSINSPECTION.SUBCODE02 = PROFIKDSTATE.DECOSUBCODE02 OR PTITELEMENTSINSPECTION.SUBCODE02 = '') AND (PTITELEMENTSINSPECTION.SUBCODE03 = PROFIKDSTATE.DECOSUBCODE03 OR PTITELEMENTSINSPECTION.SUBCODE03 = '') AND (PTITELEMENTSINSPECTION.SUBCODE04 = PROFIKDSTATE.DECOSUBCODE04 OR PTITELEMENTSINSPECTION.SUBCODE04 = '') AND (PTITELEMENTSINSPECTION.SUBCODE05 = PROFIKDSTATE.DECOSUBCODE05 OR PTITELEMENTSINSPECTION.SUBCODE05 = '') AND (PTITELEMENTSINSPECTION.SUBCODE06 = PROFIKDSTATE.DECOSUBCODE06 OR PTITELEMENTSINSPECTION.SUBCODE06 = '') AND (PTITELEMENTSINSPECTION.SUBCODE07 = PROFIKDSTATE.DECOSUBCODE07 OR PTITELEMENTSINSPECTION.SUBCODE07 = '') AND (PTITELEMENTSINSPECTION.SUBCODE08 = PROFIKDSTATE.DECOSUBCODE08 OR PTITELEMENTSINSPECTION.SUBCODE08 = '') AND (PTITELEMENTSINSPECTION.SUBCODE09 = PROFIKDSTATE.DECOSUBCODE09 OR PTITELEMENTSINSPECTION.SUBCODE09 = '') AND (PTITELEMENTSINSPECTION.SUBCODE10 = PROFIKDSTATE.DECOSUBCODE10 OR PTITELEMENTSINSPECTION.SUBCODE10 = '') LEFT OUTER JOIN ITEMTYPE ON ITEMTYPE.OWNINGCOMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ITEMTYPE.CODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE UNION ALL SELECT PTITELEMENTSINSPECTION.COMPANYCODE, TRIM(NVL(PTITELEMENTSINSPECTION.ITEMTYPEAFICODE,'')) TIPO_A, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE01,'')) REFERENCIA, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE02,'')) CLAVE2, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE03,'')) CLAVE3, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE04,'')) CLAVE4, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE05,'')) CLAVE5, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE06,'')) CLAVE6, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE07,'')) CLAVE7, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE08,'')) CALVE8, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE09,'')) CLAVE9, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE10,'')) CLAVE10, PTITELEMENTSINSPECTION.ELEMENTCODE ROLLO, TRIM(NVL(CHAR(PTITELEMENTSINSPECTION.CALIDAD),'')) CALIDAD, '' COD_RAZON_CALIDAD, '' DESCRIP_RAZON_CALIDAD, TRIM(NVL(PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE,'')) DEFECTO, CASE CHAR(PRODUCTIONPROGRESS.QUALITYCODE) WHEN '1' THEN '' ELSE TRIM(NVL(PRODUCTIONPROGRESS.LONGDESCRIPTION,'')) END NOMBRE_DEFECTO, '' PLANTA_CAUSANTE, 0 POSI_INICIO_DEFEC, 0 METROS_FABRICADOS, CAST(PTITELEMENTSINSPECTION.USERSECUNDARYQUANTITY AS DECIMAL (10,5)) KGS_FAB, PTITELEMENTSINSPECTION.USERPRIMARYQUANTITY CANT_UNIDADES, CASE PTITELEMENTSINSPECTION.PRIMARYUOMCODE WHEN 'un' THEN (PTITELEMENTSINSPECTION.FACTORKGUN * PTITELEMENTSINSPECTION.USERPRIMARYQUANTITY) ELSE 0 END KGS_ESTANDAR_UN, PTITELEMENTSINSPECTION.LOTE, PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE CONTADOR_DEMANDA, PTITELEMENTSINSPECTION.DEMANDCODE COD_DEMANDA, BASEPRIMARYUOMCODEDM UM_PRIMARIA_DEMANDA, BASEPRIMARYQUANTITYDM CANTPRI_PLANEADA_DEMANDA, BASESECONDARYUOMCODEDM UM_SECUNDARIA_DEMANDA, BASESECONDARYQUANTITYDM CANTSECU_PLANEADA_DEMANDA, TRIM(NVL(PTITELEMENTSINSPECTION.VARIANTE,'')) VARIANTE, PTITELEMENTSINSPECTION.COMPOSITIONDESCR COMPOSICION, PTITELEMENTSINSPECTION.ITEMTYPECODECRUDO TA_ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.ELEMENTCODECRUDO ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.CRUDOQUANTITYKG CANT_KG_CRUDO, SUBSTR(PTITELEMENTSINSPECTION.ELEMENTCODECRUDO,4,3) TELAR, PTITELEMENTSINSPECTION.EXTERNALREFERENCE DM_ORIGINAL, PTITELEMENTSINSPECTION.INTERNALREFERENCE CAUSA_DEL_ARREGLO, PTITELEMENTSINSPECTION.ITEMTYPECODEPREFIJA TA_PREFIJADO, PTITELEMENTSINSPECTION.ELEPREFIJADO ELEMENTO_PREFIJADO, PTITELEMENTSINSPECTION.PREFIJADOQUANTITYKG CANT_KG_PREFIJADO, PTITELEMENTSINSPECTION.CONTDEMPREFI CONT_DEMANA_PREFIJADO, PTITELEMENTSINSPECTION.DEMANDAPREFI DEMANDA_PREFIJADO, PTITELEMENTSINSPECTION.MAQUINAPREFI MAQUINA_PREFIJADO, PTITELEMENTSINSPECTION.FECHAPREFI FECHA_PREFIJADO, PTITELEMENTSINSPECTION.FORMULAPREFIJA FORMULA_PREFIJADO, PTITELEMENTSINSPECTION.TINTURA, PTITELEMENTSINSPECTION.FECHAPROTIN FECHA_TINTURA, PTITELEMENTSINSPECTION.RAMAACABADO, PTITELEMENTSINSPECTION.FECHAPRORAMA FECHA_RAMA, PTITELEMENTSINSPECTION.ORIGINALELELMENTITEMTYPECODE TA_PIEZA, PTITELEMENTSINSPECTION.ORIGINALELEMENTCODE PIEZA, PTITELEMENTSINSPECTION.MERCADO LINEA_MERCADO, PTITELEMENTSINSPECTION.DESCRMERCADO DESCRIP_LINEA_MERCADO, PTITELEMENTSINSPECTION.INSPECTIONENDDATETIME FECHA_FIN_INSPE, TRIM(PTITELEMENTSINSPECTION.OPERATORCODE) OPERARIO, PTITELEMENTSINSPECTION.ACABADO PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.DESCRACABADO DESCRIP_PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.TIPODEMANDA, PROFIKDSTATE.SALESSTATECODE ESTADO_VENTA, PROFIKDSTATE.PRODUCTIONSTATECODE ESTADO_PRODUCCION FROM DB2ADMIN.PTITELEMENTSINSPECTION PTITELEMENTSINSPECTION LEFT OUTER JOIN ( SELECT PRODUCTIONPROGRESS.COMPANYCODE, PRODUCTIONPROGRESS.DEMANDCOUNTERCODE, PRODUCTIONPROGRESS.DEMANDCODE, PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE, PRODUCTIONPROGRESS.QUALITYCODE, PRODUCTIONPROGRESSTEMPLATE.LONGDESCRIPTION , PRODUCTIONPROGRESS.PRODUCTIONORDERCODE FROM PRODUCTIONPROGRESS INNER JOIN USERGENERICGROUP H ON H.OWNINGCOMPANYCODE= PRODUCTIONPROGRESS.COMPANYCODE AND H.USERGENERICGROUPTYPECODE = 'OIC' AND PRODUCTIONPROGRESS.OPERATIONCODE = H.CODE INNER JOIN DB2ADMIN.PRODUCTIONPROGRESSTEMPLATE PRODUCTIONPROGRESSTEMPLATE ON PRODUCTIONPROGRESSTEMPLATE.COMPANYCODE = PRODUCTIONPROGRESS.COMPANYCODE AND PRODUCTIONPROGRESSTEMPLATE.CODE = PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE WHERE PRODUCTIONPROGRESS.PRIMARYQTY <> 0 GROUP BY PRODUCTIONPROGRESS.COMPANYCODE, PRODUCTIONPROGRESS.DEMANDCOUNTERCODE, PRODUCTIONPROGRESS.DEMANDCODE, PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE, PRODUCTIONPROGRESS.QUALITYCODE, PRODUCTIONPROGRESSTEMPLATE.LONGDESCRIPTION , PRODUCTIONPROGRESS.PRODUCTIONORDERCODE ) PRODUCTIONPROGRESS ON PTITELEMENTSINSPECTION.COMPANYCODE = PRODUCTIONPROGRESS.COMPANYCODE AND PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE = PRODUCTIONPROGRESS.DEMANDCOUNTERCODE AND PTITELEMENTSINSPECTION.DEMANDCODE = PRODUCTIONPROGRESS.DEMANDCODE AND PTITELEMENTSINSPECTION.LOTE = PRODUCTIONPROGRESS.PRODUCTIONORDERCODE AND PTITELEMENTSINSPECTION.CALIDAD = PRODUCTIONPROGRESS.QUALITYCODE LEFT OUTER JOIN PROFIKDSTATE ON PTITELEMENTSINSPECTION.COMPANYCODE = PROFIKDSTATE.COMPANYCODE AND PTITELEMENTSINSPECTION.ITEMTYPEAFICODE = PROFIKDSTATE.ITEMTYPECODE AND (PTITELEMENTSINSPECTION.SUBCODE01 = PROFIKDSTATE.DECOSUBCODE01 OR PTITELEMENTSINSPECTION.SUBCODE01 = '') AND (PTITELEMENTSINSPECTION.SUBCODE02 = PROFIKDSTATE.DECOSUBCODE02 OR PTITELEMENTSINSPECTION.SUBCODE02 = '') AND (PTITELEMENTSINSPECTION.SUBCODE03 = PROFIKDSTATE.DECOSUBCODE03 OR PTITELEMENTSINSPECTION.SUBCODE03 = '') AND (PTITELEMENTSINSPECTION.SUBCODE04 = PROFIKDSTATE.DECOSUBCODE04 OR PTITELEMENTSINSPECTION.SUBCODE04 = '') AND (PTITELEMENTSINSPECTION.SUBCODE05 = PROFIKDSTATE.DECOSUBCODE05 OR PTITELEMENTSINSPECTION.SUBCODE05 = '') AND (PTITELEMENTSINSPECTION.SUBCODE06 = PROFIKDSTATE.DECOSUBCODE06 OR PTITELEMENTSINSPECTION.SUBCODE06 = '') AND (PTITELEMENTSINSPECTION.SUBCODE07 = PROFIKDSTATE.DECOSUBCODE07 OR PTITELEMENTSINSPECTION.SUBCODE07 = '') AND (PTITELEMENTSINSPECTION.SUBCODE08 = PROFIKDSTATE.DECOSUBCODE08 OR PTITELEMENTSINSPECTION.SUBCODE08 = '') AND (PTITELEMENTSINSPECTION.SUBCODE09 = PROFIKDSTATE.DECOSUBCODE09 OR PTITELEMENTSINSPECTION.SUBCODE09 = '') AND (PTITELEMENTSINSPECTION.SUBCODE10 = PROFIKDSTATE.DECOSUBCODE10 OR PTITELEMENTSINSPECTION.SUBCODE10 = '') LEFT OUTER JOIN ITEMTYPE ON ITEMTYPE.OWNINGCOMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ITEMTYPE.CODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE WHERE PTITELEMENTSINSPECTION.PRIMARYUOMCODE = 'un';
Quedo atento y gracias de antemano
"PTIVELEMENTSINSPECTION5. CASE ELEMENTSINSPECTION.WIDTHUOMCODE WHEN 'M' THEN ELEMENTSINSPECTION.WIDTHNET * 100 WHEN 'CM' THEN ELEMENTSINSPECTION.WIDTHNET ELSE 0 END ANCHO_CMS"
--CREACIÓN DE LA VISTA
CREATE VIEW PTIVELEMENTSINSPECTION5_PRUEBA (COMPANYCODE, TIPO_A, REFERENCIA, CLAVE2, CLAVE3, CLAVE4, CLAVE5, CLAVE6, CLAVE7, CALVE8, CLAVE9, CLAVE10, ROLLO, CALIDAD, COD_RAZON_CALIDAD, DESCRIP_RAZON_CALIDAD, DEFECTO, NOMBRE_DEFECTO, PLANTA_CAUSANTE, POSI_INICIO_DEFEC, METROS_FABRICADOS, KGS_FAB, CANT_UNIDADES, KGS_ESTANDAR_UN, LOTE, CONTADOR_DEMANDA, COD_DEMANDA, UM_PRIMARIA_DEMANDA, CANTPRI_PLANEADA_DEMANDA, UM_SECUNDARIA_DEMANDA, CANTSECU_PLANEADA_DEMANDA, VARIANTE, COMPOSICION, TA_ELEMENTO_CRUDO, ELEMENTO_CRUDO, CANT_KG_CRUDO, TELAR, DM_ORIGINAL, CAUSA_DEL_ARREGLO, TA_PREFIJADO, ELEMENTO_PREFIJADO, CANT_KG_PREFIJADO, CONT_DEMANA_PREFIJADO, DEMANDA_PREFIJADO, MAQUINA_PREFIJADO, FECHA_PREFIJADO, FORMULA_PREFIJADO, TINTURA, FECHA_TINTURA, RAMAACABADO, FECHA_RAMA, TA_PIEZA, PIEZA, LINEA_MERCADO, DESCRIP_LINEA_MERCADO, FECHA_FIN_INSPE, OPERARIO, PLANTILLA_FORMULA, DESCRIP_PLANTILLA_FORMULA, TIPODEMANDA, ESTADO_VENTA, ESTADO_PRODUCCION) AS SELECT PTITELEMENTSINSPECTION.COMPANYCODE, TRIM(NVL(PTITELEMENTSINSPECTION.ITEMTYPEAFICODE,'')) TIPO_A, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE01,'')) REFERENCIA, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE02,'')) CLAVE2, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE03,'')) CLAVE3, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE04,'')) CLAVE4, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE05,'')) CLAVE5, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE06,'')) CLAVE6, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE07,'')) CLAVE7, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE08,'')) CALVE8, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE09,'')) CLAVE9, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE10,'')) CLAVE10, PTITELEMENTSINSPECTION.ELEMENTCODE ROLLO, TRIM(NVL(CHAR(ELEMENTSINSPECTION.QUALITYCODE),'')) CALIDAD, TRIM(NVL(ELEMENTSINSPECTION.QUALITYREASONCODE,'')) COD_RAZON_CALIDAD, TRIM(NVL(QualityReason.LONGDESCRIPTION,'')) DESCRIP_RAZON_CALIDAD, '' DEFECTO, '' NOMBRE_DEFECTO, '' PLANTA_CAUSANTE, 0 POSI_INICIO_DEFEC, CASE ELEMENTSINSPECTION.WIDTHUOMCODE WHEN 'M' THEN ELEMENTSINSPECTION.WIDTHNET * 100 WHEN 'CM' THEN ELEMENTSINSPECTION.WIDTHNET ELSE 0 END ANCHO_CMS, CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) /100 AS DECIMAL(10,5)) WHEN 'm' THEN CAST((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) AS DECIMAL(10,5)) ELSE 0 END METROS_FABRICADOS, CASE WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE ='g' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CAST ( ROUND ( (((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) * ELEMENTSINSPECTION.WEIGHTREALNET)/ELEMENTSINSPECTION.LENGTHGROSS)/1000, 2 ) AS DECIMAL(10,5) ) WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE = 'kg' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CAST(ROUND((((ELEMENTSINSPECTION.LENGTHGROSS-ELEMENTSINSPECTION.TOTALCREDITS) * ELEMENTSINSPECTION.WEIGHTREALNET)/ELEMENTSINSPECTION.LENGTHGROSS),2) AS DECIMAL(10,5)) ELSE 0 END KGS_FAB, 0 CANT_UNIDADES, 0 KGS_ESTANDAR_UN, PTITELEMENTSINSPECTION.LOTE, PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE CONTADOR_DEMANDA, PTITELEMENTSINSPECTION.DEMANDCODE COD_DEMANDA, BASEPRIMARYUOMCODEDM UM_PRIMARIA_DEMANDA, BASEPRIMARYQUANTITYDM CANTPRI_PLANEADA_DEMANDA, BASESECONDARYUOMCODEDM UM_SECUNDARIA_DEMANDA, BASESECONDARYQUANTITYDM CANTSECU_PLANEADA_DEMANDA, TRIM(NVL(PTITELEMENTSINSPECTION.VARIANTE,'')) VARIANTE, PTITELEMENTSINSPECTION.COMPOSITIONDESCR COMPOSICION, PTITELEMENTSINSPECTION.ITEMTYPECODECRUDO TA_ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.ELEMENTCODECRUDO ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.CRUDOQUANTITYKG CANT_KG_CRUDO, SUBSTR(PTITELEMENTSINSPECTION.ELEMENTCODECRUDO,4,3) TELAR, PTITELEMENTSINSPECTION.EXTERNALREFERENCE DM_ORIGINAL, PTITELEMENTSINSPECTION.INTERNALREFERENCE CAUSA_DEL_ARREGLO, PTITELEMENTSINSPECTION.ITEMTYPECODEPREFIJA TA_PREFIJADO, PTITELEMENTSINSPECTION.ELEPREFIJADO ELEMENTO_PREFIJADO, PTITELEMENTSINSPECTION.PREFIJADOQUANTITYKG CANT_KG_PREFIJADO, PTITELEMENTSINSPECTION.CONTDEMPREFI CONT_DEMANA_PREFIJADO, PTITELEMENTSINSPECTION.DEMANDAPREFI DEMANDA_PREFIJADO, PTITELEMENTSINSPECTION.MAQUINAPREFI MAQUINA_PREFIJADO, PTITELEMENTSINSPECTION.FECHAPREFI FECHA_PREFIJADO, PTITELEMENTSINSPECTION.FORMULAPREFIJA FORMULA_PREFIJADO, PTITELEMENTSINSPECTION.TINTURA, PTITELEMENTSINSPECTION.FECHAPROTIN FECHA_TINTURA, PTITELEMENTSINSPECTION.RAMAACABADO, PTITELEMENTSINSPECTION.FECHAPRORAMA FECHA_RAMA, PTITELEMENTSINSPECTION.ORIGINALELELMENTITEMTYPECODE TA_PIEZA, PTITELEMENTSINSPECTION.ORIGINALELEMENTCODE PIEZA, PTITELEMENTSINSPECTION.MERCADO LINEA_MERCADO, PTITELEMENTSINSPECTION.DESCRMERCADO DESCRIP_LINEA_MERCADO, PTITELEMENTSINSPECTION.INSPECTIONENDDATETIME FECHA_FIN_INSPE, TRIM(NVL(ELEMENTSINSPECTION.OPERATORCODE,'')) OPERARIO, PTITELEMENTSINSPECTION.ACABADO PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.DESCRACABADO DESCRIP_PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.TIPODEMANDA, PROFIKDSTATE.SALESSTATECODE ESTADO_VENTA, PROFIKDSTATE.PRODUCTIONSTATECODE ESTADO_PRODUCCION FROM DB2ADMIN.PTITELEMENTSINSPECTION PTITELEMENTSINSPECTION INNER JOIN ELEMENTSINSPECTION ELEMENTSINSPECTION ON ELEMENTSINSPECTION.COMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ELEMENTSINSPECTION.ELEMENTITEMTYPECODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE AND ELEMENTSINSPECTION.ELEMENTCODE = PTITELEMENTSINSPECTION.ELEMENTCODE AND ELEMENTSINSPECTION.INSPECTIONINDEX = PTITELEMENTSINSPECTION.INSPECTIONINDEX AND ELEMENTSINSPECTION.QUALITYCODE = 1 LEFT OUTER JOIN QualityReason QualityReason ON QualityReason.OWNINGCOMPANYCODE= ELEMENTSINSPECTION.COMPANYCODE AND QualityReason.CODE = ELEMENTSINSPECTION.QUALITYREASONCODE LEFT OUTER JOIN PROFIKDSTATE ON PTITELEMENTSINSPECTION.COMPANYCODE = PROFIKDSTATE.COMPANYCODE AND PTITELEMENTSINSPECTION.ITEMTYPEAFICODE = PROFIKDSTATE.ITEMTYPECODE AND (PTITELEMENTSINSPECTION.SUBCODE01 = PROFIKDSTATE.DECOSUBCODE01 OR PTITELEMENTSINSPECTION.SUBCODE01 = '') AND (PTITELEMENTSINSPECTION.SUBCODE02 = PROFIKDSTATE.DECOSUBCODE02 OR PTITELEMENTSINSPECTION.SUBCODE02 = '') AND (PTITELEMENTSINSPECTION.SUBCODE03 = PROFIKDSTATE.DECOSUBCODE03 OR PTITELEMENTSINSPECTION.SUBCODE03 = '') AND (PTITELEMENTSINSPECTION.SUBCODE04 = PROFIKDSTATE.DECOSUBCODE04 OR PTITELEMENTSINSPECTION.SUBCODE04 = '') AND (PTITELEMENTSINSPECTION.SUBCODE05 = PROFIKDSTATE.DECOSUBCODE05 OR PTITELEMENTSINSPECTION.SUBCODE05 = '') AND (PTITELEMENTSINSPECTION.SUBCODE06 = PROFIKDSTATE.DECOSUBCODE06 OR PTITELEMENTSINSPECTION.SUBCODE06 = '') AND (PTITELEMENTSINSPECTION.SUBCODE07 = PROFIKDSTATE.DECOSUBCODE07 OR PTITELEMENTSINSPECTION.SUBCODE07 = '') AND (PTITELEMENTSINSPECTION.SUBCODE08 = PROFIKDSTATE.DECOSUBCODE08 OR PTITELEMENTSINSPECTION.SUBCODE08 = '') AND (PTITELEMENTSINSPECTION.SUBCODE09 = PROFIKDSTATE.DECOSUBCODE09 OR PTITELEMENTSINSPECTION.SUBCODE09 = '') AND (PTITELEMENTSINSPECTION.SUBCODE10 = PROFIKDSTATE.DECOSUBCODE10 OR PTITELEMENTSINSPECTION.SUBCODE10 = '') LEFT OUTER JOIN ITEMTYPE ON ITEMTYPE.OWNINGCOMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ITEMTYPE.CODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE UNION ALL SELECT PTITELEMENTSINSPECTION.COMPANYCODE, TRIM(NVL(PTITELEMENTSINSPECTION.ITEMTYPEAFICODE,'')) TIPO_A, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE01,'')) REFERENCIA, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE02,'')) CLAVE2, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE03,'')) CLAVE3, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE04,'')) CLAVE4, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE05,'')) CLAVE5, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE06,'')) CLAVE6, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE07,'')) CLAVE7, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE08,'')) CALVE8, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE09,'')) CLAVE9, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE10,'')) CLAVE10, PTITELEMENTSINSPECTION.ELEMENTCODE ROLLO, CASE WHEN (ELEMENTSINSPECTIONEVENT.CREDITS > 0 AND ELEMENTSINSPECTION.TOTALCREDITS > 0 AND ELEMENTSINSPECTIONEVENT.EVENTVALUE IS NULL) THEN 'B' WHEN (ELEMENTSINSPECTIONEVENT.CREDITS > 0 AND ELEMENTSINSPECTION.TOTALCREDITS > 0 AND ELEMENTSINSPECTIONEVENT.EVENTVALUE IS NOT NULL) THEN TRIM(ELEMENTSINSPECTIONEVENT.EVENTVALUE) WHEN (ELEMENTSINSPECTION.TOTALCREDITS = 0 AND ELEMENTSINSPECTIONEVENT.EVENTVALUE IS NULL) THEN TRIM(CHAR(ELEMENTSINSPECTION.QUALITYCODE)) ELSE TRIM(NVL(ELEMENTSINSPECTIONEVENT.EVENTVALUE,'')) END CALIDAD, TRIM(NVL(ELEMENTSINSPECTION.QUALITYREASONCODE,'')) COD_RAZON_CALIDAD, TRIM(NVL(QualityReason.LONGDESCRIPTION,'')) DESCRIP_RAZON_CALIDAD, TRIM(NVL(ELEMENTSINSPECTIONEVENT.CODEEVENTCODE,'')) DEFECTO, TRIM(NVL(INSPECTIONEVENTTEMPLATE.LONGDESCRIPTION,'')) NOMBRE_DEFECTO, SUBSTR( NVL(ELEMENTSINSPECTIONEVENT.VARIABLE,''),1,30) PLANTA_CAUSANTE, ELEMENTSINSPECTIONEVENT.STARTPOSITION POSI_INICIO_DEFEC, CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST(ELEMENTSINSPECTIONEVENT.LENGHT /100 AS DECIMAL(10,5)) WHEN 'm' THEN CAST(ELEMENTSINSPECTIONEVENT.LENGHT AS DECIMAL(10,5)) ELSE 0 END METROS_FABRICADOS, CASE WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE ='g' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST ( ( ( ELEMENTSINSPECTIONEVENT.LENGHT /100 ) * (ELEMENTSINSPECTION.WEIGHTREALNET /1000) ) / (ELEMENTSINSPECTION.LENGTHGROSS/100) AS DECIMAL(10,5) ) WHEN 'm' THEN CAST ( ( (ELEMENTSINSPECTIONEVENT.LENGHT)*(ELEMENTSINSPECTION.WEIGHTREALNET /1000) ) / (ELEMENTSINSPECTION.LENGTHGROSS) AS DECIMAL(10,5) ) END WHEN ELEMENTSINSPECTION.WEIGHTUOMCODE = 'kg' and ELEMENTSINSPECTION.LENGTHGROSS>0 THEN CASE ELEMENTSINSPECTION.LENGTHUOMCODE WHEN 'cm' THEN CAST(((ELEMENTSINSPECTIONEVENT.LENGHT /100) * (ELEMENTSINSPECTION.WEIGHTREALNET ))/ (ELEMENTSINSPECTION.LENGTHGROSS /100) AS DECIMAL(10,5)) WHEN 'm' THEN CAST(((ELEMENTSINSPECTIONEVENT.LENGHT) * (ELEMENTSINSPECTION.WEIGHTREALNET ))/ (ELEMENTSINSPECTION.LENGTHGROSS) AS DECIMAL(10,5)) END ELSE 0 END KGS_FAB, 0 CANT_UNIDADES, 0 KGS_ESTANDAR_UN, PTITELEMENTSINSPECTION.LOTE, PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE CONTADOR_DEMANDA, PTITELEMENTSINSPECTION.DEMANDCODE COD_DEMANDA, BASEPRIMARYUOMCODEDM UM_PRIMARIA_DEMANDA, BASEPRIMARYQUANTITYDM CANTPRI_PLANEADA_DEMANDA, BASESECONDARYUOMCODEDM UM_SECUNDARIA_DEMANDA, BASESECONDARYQUANTITYDM CANTSECU_PLANEADA_DEMANDA, TRIM(NVL(PTITELEMENTSINSPECTION.VARIANTE,'')) VARIANTE, PTITELEMENTSINSPECTION.COMPOSITIONDESCR COMPOSICION, PTITELEMENTSINSPECTION.ITEMTYPECODECRUDO TA_ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.ELEMENTCODECRUDO ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.CRUDOQUANTITYKG CANT_KG_CRUDO, SUBSTR(PTITELEMENTSINSPECTION.ELEMENTCODECRUDO,4,3) TELAR, PTITELEMENTSINSPECTION.EXTERNALREFERENCE DM_ORIGINAL, PTITELEMENTSINSPECTION.INTERNALREFERENCE CAUSA_DEL_ARREGLO, PTITELEMENTSINSPECTION.ITEMTYPECODEPREFIJA TA_PREFIJADO, PTITELEMENTSINSPECTION.ELEPREFIJADO ELEMENTO_PREFIJADO, PTITELEMENTSINSPECTION.PREFIJADOQUANTITYKG CANT_KG_PREFIJADO, PTITELEMENTSINSPECTION.CONTDEMPREFI CONT_DEMANA_PREFIJADO, PTITELEMENTSINSPECTION.DEMANDAPREFI DEMANDA_PREFIJADO, PTITELEMENTSINSPECTION.MAQUINAPREFI MAQUINA_PREFIJADO, PTITELEMENTSINSPECTION.FECHAPREFI FECHA_PREFIJADO, PTITELEMENTSINSPECTION.FORMULAPREFIJA FORMULA_PREFIJADO, PTITELEMENTSINSPECTION.TINTURA, PTITELEMENTSINSPECTION.FECHAPROTIN FECHA_TINTURA, PTITELEMENTSINSPECTION.RAMAACABADO, PTITELEMENTSINSPECTION.FECHAPRORAMA FECHA_RAMA, PTITELEMENTSINSPECTION.ORIGINALELELMENTITEMTYPECODE TA_PIEZA, PTITELEMENTSINSPECTION.ORIGINALELEMENTCODE PIEZA, PTITELEMENTSINSPECTION.MERCADO LINEA_MERCADO, PTITELEMENTSINSPECTION.DESCRMERCADO DESCRIP_LINEA_MERCADO, PTITELEMENTSINSPECTION.INSPECTIONENDDATETIME FECHA_FIN_INSPE, TRIM(NVL(ELEMENTSINSPECTION.OPERATORCODE,'')) OPERARIO, PTITELEMENTSINSPECTION.ACABADO PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.DESCRACABADO DESCRIP_PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.TIPODEMANDA, PROFIKDSTATE.SALESSTATECODE ESTADO_VENTA, PROFIKDSTATE.PRODUCTIONSTATECODE ESTADO_PRODUCCION FROM DB2ADMIN.PTITELEMENTSINSPECTION PTITELEMENTSINSPECTION INNER JOIN ELEMENTSINSPECTION ELEMENTSINSPECTION ON ELEMENTSINSPECTION.COMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ELEMENTSINSPECTION.ELEMENTITEMTYPECODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE AND ELEMENTSINSPECTION.ELEMENTCODE = PTITELEMENTSINSPECTION.ELEMENTCODE AND ELEMENTSINSPECTION.INSPECTIONINDEX = PTITELEMENTSINSPECTION.INSPECTIONINDEX INNER JOIN DB2ADMIN.ELEMENTSINSPECTIONEVENT ELEMENTSINSPECTIONEVENT ON ELEMENTSINSPECTIONEVENT.ELEMENTSINSPECTIONCOMPANYCODE = ELEMENTSINSPECTION.COMPANYCODE AND ELEMENTSINSPECTIONEVENT.ELEMENTSINSELMITEMTYPECODE = ELEMENTSINSPECTION.ELEMENTITEMTYPECODE AND ELEMENTSINSPECTIONEVENT.ELEMENTSINSPECTIONELEMENTCODE = ELEMENTSINSPECTION.ELEMENTCODE AND ELEMENTSINSPECTIONEVENT.ELEMENTSINSINSPECTIONINDEX = ELEMENTSINSPECTION.INSPECTIONINDEX LEFT OUTER JOIN DB2ADMIN.INSPECTIONEVENTTEMPLATE INSPECTIONEVENTTEMPLATE ON INSPECTIONEVENTTEMPLATE.COMPANYCODE = ELEMENTSINSPECTIONEVENT.ELEMENTSINSPECTIONCOMPANYCODE AND INSPECTIONEVENTTEMPLATE.ITEMTYPECODE = ELEMENTSINSPECTIONEVENT.ELEMENTSINSELMITEMTYPECODE AND INSPECTIONEVENTTEMPLATE.EVENTCODE = ELEMENTSINSPECTIONEVENT.CODEEVENTCODE LEFT OUTER JOIN QualityReason QualityReason ON QualityReason.OWNINGCOMPANYCODE= ELEMENTSINSPECTION.COMPANYCODE AND QualityReason.CODE = ELEMENTSINSPECTION.QUALITYREASONCODE LEFT OUTER JOIN PROFIKDSTATE ON PTITELEMENTSINSPECTION.COMPANYCODE = PROFIKDSTATE.COMPANYCODE AND PTITELEMENTSINSPECTION.ITEMTYPEAFICODE = PROFIKDSTATE.ITEMTYPECODE AND (PTITELEMENTSINSPECTION.SUBCODE01 = PROFIKDSTATE.DECOSUBCODE01 OR PTITELEMENTSINSPECTION.SUBCODE01 = '') AND (PTITELEMENTSINSPECTION.SUBCODE02 = PROFIKDSTATE.DECOSUBCODE02 OR PTITELEMENTSINSPECTION.SUBCODE02 = '') AND (PTITELEMENTSINSPECTION.SUBCODE03 = PROFIKDSTATE.DECOSUBCODE03 OR PTITELEMENTSINSPECTION.SUBCODE03 = '') AND (PTITELEMENTSINSPECTION.SUBCODE04 = PROFIKDSTATE.DECOSUBCODE04 OR PTITELEMENTSINSPECTION.SUBCODE04 = '') AND (PTITELEMENTSINSPECTION.SUBCODE05 = PROFIKDSTATE.DECOSUBCODE05 OR PTITELEMENTSINSPECTION.SUBCODE05 = '') AND (PTITELEMENTSINSPECTION.SUBCODE06 = PROFIKDSTATE.DECOSUBCODE06 OR PTITELEMENTSINSPECTION.SUBCODE06 = '') AND (PTITELEMENTSINSPECTION.SUBCODE07 = PROFIKDSTATE.DECOSUBCODE07 OR PTITELEMENTSINSPECTION.SUBCODE07 = '') AND (PTITELEMENTSINSPECTION.SUBCODE08 = PROFIKDSTATE.DECOSUBCODE08 OR PTITELEMENTSINSPECTION.SUBCODE08 = '') AND (PTITELEMENTSINSPECTION.SUBCODE09 = PROFIKDSTATE.DECOSUBCODE09 OR PTITELEMENTSINSPECTION.SUBCODE09 = '') AND (PTITELEMENTSINSPECTION.SUBCODE10 = PROFIKDSTATE.DECOSUBCODE10 OR PTITELEMENTSINSPECTION.SUBCODE10 = '') LEFT OUTER JOIN ITEMTYPE ON ITEMTYPE.OWNINGCOMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ITEMTYPE.CODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE UNION ALL SELECT PTITELEMENTSINSPECTION.COMPANYCODE, TRIM(NVL(PTITELEMENTSINSPECTION.ITEMTYPEAFICODE,'')) TIPO_A, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE01,'')) REFERENCIA, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE02,'')) CLAVE2, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE03,'')) CLAVE3, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE04,'')) CLAVE4, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE05,'')) CLAVE5, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE06,'')) CLAVE6, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE07,'')) CLAVE7, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE08,'')) CALVE8, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE09,'')) CLAVE9, TRIM(NVL(PTITELEMENTSINSPECTION.SUBCODE10,'')) CLAVE10, PTITELEMENTSINSPECTION.ELEMENTCODE ROLLO, TRIM(NVL(CHAR(PTITELEMENTSINSPECTION.CALIDAD),'')) CALIDAD, '' COD_RAZON_CALIDAD, '' DESCRIP_RAZON_CALIDAD, TRIM(NVL(PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE,'')) DEFECTO, CASE CHAR(PRODUCTIONPROGRESS.QUALITYCODE) WHEN '1' THEN '' ELSE TRIM(NVL(PRODUCTIONPROGRESS.LONGDESCRIPTION,'')) END NOMBRE_DEFECTO, '' PLANTA_CAUSANTE, 0 POSI_INICIO_DEFEC, 0 METROS_FABRICADOS, CAST(PTITELEMENTSINSPECTION.USERSECUNDARYQUANTITY AS DECIMAL (10,5)) KGS_FAB, PTITELEMENTSINSPECTION.USERPRIMARYQUANTITY CANT_UNIDADES, CASE PTITELEMENTSINSPECTION.PRIMARYUOMCODE WHEN 'un' THEN (PTITELEMENTSINSPECTION.FACTORKGUN * PTITELEMENTSINSPECTION.USERPRIMARYQUANTITY) ELSE 0 END KGS_ESTANDAR_UN, PTITELEMENTSINSPECTION.LOTE, PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE CONTADOR_DEMANDA, PTITELEMENTSINSPECTION.DEMANDCODE COD_DEMANDA, BASEPRIMARYUOMCODEDM UM_PRIMARIA_DEMANDA, BASEPRIMARYQUANTITYDM CANTPRI_PLANEADA_DEMANDA, BASESECONDARYUOMCODEDM UM_SECUNDARIA_DEMANDA, BASESECONDARYQUANTITYDM CANTSECU_PLANEADA_DEMANDA, TRIM(NVL(PTITELEMENTSINSPECTION.VARIANTE,'')) VARIANTE, PTITELEMENTSINSPECTION.COMPOSITIONDESCR COMPOSICION, PTITELEMENTSINSPECTION.ITEMTYPECODECRUDO TA_ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.ELEMENTCODECRUDO ELEMENTO_CRUDO, PTITELEMENTSINSPECTION.CRUDOQUANTITYKG CANT_KG_CRUDO, SUBSTR(PTITELEMENTSINSPECTION.ELEMENTCODECRUDO,4,3) TELAR, PTITELEMENTSINSPECTION.EXTERNALREFERENCE DM_ORIGINAL, PTITELEMENTSINSPECTION.INTERNALREFERENCE CAUSA_DEL_ARREGLO, PTITELEMENTSINSPECTION.ITEMTYPECODEPREFIJA TA_PREFIJADO, PTITELEMENTSINSPECTION.ELEPREFIJADO ELEMENTO_PREFIJADO, PTITELEMENTSINSPECTION.PREFIJADOQUANTITYKG CANT_KG_PREFIJADO, PTITELEMENTSINSPECTION.CONTDEMPREFI CONT_DEMANA_PREFIJADO, PTITELEMENTSINSPECTION.DEMANDAPREFI DEMANDA_PREFIJADO, PTITELEMENTSINSPECTION.MAQUINAPREFI MAQUINA_PREFIJADO, PTITELEMENTSINSPECTION.FECHAPREFI FECHA_PREFIJADO, PTITELEMENTSINSPECTION.FORMULAPREFIJA FORMULA_PREFIJADO, PTITELEMENTSINSPECTION.TINTURA, PTITELEMENTSINSPECTION.FECHAPROTIN FECHA_TINTURA, PTITELEMENTSINSPECTION.RAMAACABADO, PTITELEMENTSINSPECTION.FECHAPRORAMA FECHA_RAMA, PTITELEMENTSINSPECTION.ORIGINALELELMENTITEMTYPECODE TA_PIEZA, PTITELEMENTSINSPECTION.ORIGINALELEMENTCODE PIEZA, PTITELEMENTSINSPECTION.MERCADO LINEA_MERCADO, PTITELEMENTSINSPECTION.DESCRMERCADO DESCRIP_LINEA_MERCADO, PTITELEMENTSINSPECTION.INSPECTIONENDDATETIME FECHA_FIN_INSPE, TRIM(PTITELEMENTSINSPECTION.OPERATORCODE) OPERARIO, PTITELEMENTSINSPECTION.ACABADO PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.DESCRACABADO DESCRIP_PLANTILLA_FORMULA, PTITELEMENTSINSPECTION.TIPODEMANDA, PROFIKDSTATE.SALESSTATECODE ESTADO_VENTA, PROFIKDSTATE.PRODUCTIONSTATECODE ESTADO_PRODUCCION FROM DB2ADMIN.PTITELEMENTSINSPECTION PTITELEMENTSINSPECTION LEFT OUTER JOIN ( SELECT PRODUCTIONPROGRESS.COMPANYCODE, PRODUCTIONPROGRESS.DEMANDCOUNTERCODE, PRODUCTIONPROGRESS.DEMANDCODE, PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE, PRODUCTIONPROGRESS.QUALITYCODE, PRODUCTIONPROGRESSTEMPLATE.LONGDESCRIPTION , PRODUCTIONPROGRESS.PRODUCTIONORDERCODE FROM PRODUCTIONPROGRESS INNER JOIN USERGENERICGROUP H ON H.OWNINGCOMPANYCODE= PRODUCTIONPROGRESS.COMPANYCODE AND H.USERGENERICGROUPTYPECODE = 'OIC' AND PRODUCTIONPROGRESS.OPERATIONCODE = H.CODE INNER JOIN DB2ADMIN.PRODUCTIONPROGRESSTEMPLATE PRODUCTIONPROGRESSTEMPLATE ON PRODUCTIONPROGRESSTEMPLATE.COMPANYCODE = PRODUCTIONPROGRESS.COMPANYCODE AND PRODUCTIONPROGRESSTEMPLATE.CODE = PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE WHERE PRODUCTIONPROGRESS.PRIMARYQTY <> 0 GROUP BY PRODUCTIONPROGRESS.COMPANYCODE, PRODUCTIONPROGRESS.DEMANDCOUNTERCODE, PRODUCTIONPROGRESS.DEMANDCODE, PRODUCTIONPROGRESS.PROGRESSTEMPLATECODE, PRODUCTIONPROGRESS.QUALITYCODE, PRODUCTIONPROGRESSTEMPLATE.LONGDESCRIPTION , PRODUCTIONPROGRESS.PRODUCTIONORDERCODE ) PRODUCTIONPROGRESS ON PTITELEMENTSINSPECTION.COMPANYCODE = PRODUCTIONPROGRESS.COMPANYCODE AND PTITELEMENTSINSPECTION.DEMANDCOUNTERCODE = PRODUCTIONPROGRESS.DEMANDCOUNTERCODE AND PTITELEMENTSINSPECTION.DEMANDCODE = PRODUCTIONPROGRESS.DEMANDCODE AND PTITELEMENTSINSPECTION.LOTE = PRODUCTIONPROGRESS.PRODUCTIONORDERCODE AND PTITELEMENTSINSPECTION.CALIDAD = PRODUCTIONPROGRESS.QUALITYCODE LEFT OUTER JOIN PROFIKDSTATE ON PTITELEMENTSINSPECTION.COMPANYCODE = PROFIKDSTATE.COMPANYCODE AND PTITELEMENTSINSPECTION.ITEMTYPEAFICODE = PROFIKDSTATE.ITEMTYPECODE AND (PTITELEMENTSINSPECTION.SUBCODE01 = PROFIKDSTATE.DECOSUBCODE01 OR PTITELEMENTSINSPECTION.SUBCODE01 = '') AND (PTITELEMENTSINSPECTION.SUBCODE02 = PROFIKDSTATE.DECOSUBCODE02 OR PTITELEMENTSINSPECTION.SUBCODE02 = '') AND (PTITELEMENTSINSPECTION.SUBCODE03 = PROFIKDSTATE.DECOSUBCODE03 OR PTITELEMENTSINSPECTION.SUBCODE03 = '') AND (PTITELEMENTSINSPECTION.SUBCODE04 = PROFIKDSTATE.DECOSUBCODE04 OR PTITELEMENTSINSPECTION.SUBCODE04 = '') AND (PTITELEMENTSINSPECTION.SUBCODE05 = PROFIKDSTATE.DECOSUBCODE05 OR PTITELEMENTSINSPECTION.SUBCODE05 = '') AND (PTITELEMENTSINSPECTION.SUBCODE06 = PROFIKDSTATE.DECOSUBCODE06 OR PTITELEMENTSINSPECTION.SUBCODE06 = '') AND (PTITELEMENTSINSPECTION.SUBCODE07 = PROFIKDSTATE.DECOSUBCODE07 OR PTITELEMENTSINSPECTION.SUBCODE07 = '') AND (PTITELEMENTSINSPECTION.SUBCODE08 = PROFIKDSTATE.DECOSUBCODE08 OR PTITELEMENTSINSPECTION.SUBCODE08 = '') AND (PTITELEMENTSINSPECTION.SUBCODE09 = PROFIKDSTATE.DECOSUBCODE09 OR PTITELEMENTSINSPECTION.SUBCODE09 = '') AND (PTITELEMENTSINSPECTION.SUBCODE10 = PROFIKDSTATE.DECOSUBCODE10 OR PTITELEMENTSINSPECTION.SUBCODE10 = '') LEFT OUTER JOIN ITEMTYPE ON ITEMTYPE.OWNINGCOMPANYCODE = PTITELEMENTSINSPECTION.COMPANYCODE AND ITEMTYPE.CODE = PTITELEMENTSINSPECTION.ELEMENTITEMTYPECODE WHERE PTITELEMENTSINSPECTION.PRIMARYUOMCODE = 'un';
Quedo atento y gracias de antemano
Valora esta pregunta
0