API tools faq
paste
Guest User

Untitled

a guest
Nov 24th, 2017
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 70.03 KB | None | 0 0
raw download clone embed print report
  1. SELECT atencion.fldatencion_id, atencion.fldplanitem_codigo, atencion.fldorganigrama_codigo, atencion.fldatencion_fechaatencion, atencion.fldatencion_fechaaprobada, atencion.fldatencion_fechacumplida, atencion.fldatencion_estado, atencion.fldatencion_fechanotificacion,
  2.                                 atencion.fldatencion_fechalimite, atencion.fldatencion_flimitedcg, atencion.fldatencion_tipo, atencion.flddisposicionatencion_id, atencion.fldorigenatencion_id, atencion.fldimportanciaatencion_id, atencion.fldrecurrenciaatencion_id, atencion.fldusuario_dueno_id,
  3.                                 atencion.fldatencion_causa, atencion.fldclaatencion_id, atencion.fldatencion_fechaverificacion, atencion.fldverificaatencion_id, atencion.fldatencion_iniciativa, atencion.fldatencion_et, atencion.fldindicador_id, atencion.fldatencion_oportunidadmejora, atencion.fldatencion_padre_id,plan.*,item.*,emisor.*,area.*
  4. FROM tbdsigspaatencion atencion,
  5.      tbdsigspaplan plan,
  6.      tbdsigspaplanitem item,
  7.      tbdsigspaemisor emisor,
  8.      tblunidadauditable area
  9. WHERE   emisor.fldemisor_codigo=plan.fldemisor_codigo AND
  10. plan.fldplan_codigo=item.fldplan_codigo AND
  11. item.fldplanitem_codigo=atencion.fldplanitem_codigo AND
  12. area.fldunidadauditable_id=atencion.fldorganigrama_codigo  AND
  13. plan.fldplan_et IS NULL AND
  14. item.fldplanitem_et IS NULL AND
  15. atencion.fldatencion_et IS NULL
  16. AND item.fldplanitem_codigo IN (SELECT vista.planitem FROM vista_planitem_usuario vista WHERE vista.usuario IS NULL OR vista.usuario='3') AND
  17. atencion.fldatencion_id NOT IN (SELECT fldatencion_id
  18.                             FROM tblatencionprio
  19.                             WHERE fldatencionprio_eshallazgo = 'F' )  
  20. AND  (plan.fldplan_codigo IN('449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52')
  21. OR plan.fldplan_codigo IN ('99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133')
  22. OR plan.fldplan_codigo IN ('224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60')
  23. OR plan.fldplan_codigo IN ('70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216')
  24. OR plan.fldplan_codigo IN ('219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183')
  25. OR plan.fldplan_codigo IN ('171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71')
  26. OR plan.fldplan_codigo IN ('101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123')
  27. OR plan.fldplan_codigo IN ('155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174')
  28. OR plan.fldplan_codigo IN ('169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351')
  29. OR plan.fldplan_codigo IN ('350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223')
  30. OR plan.fldplan_codigo IN ('138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176')
  31. OR plan.fldplan_codigo IN ('191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148','449','91','67','69','60','70','55','86','90','71','101','207','349','369','351','350','329','309','489','122','139','469','82','81','200','289','202','84','85','83','121','168','109','132','146','131','93','150','98','211','269','92','201','190','189','88','130','129','127','94','75','120','74','111','116','89','95','218','80','204','57','113','135','52','99','134','110','73','216','219','105','119','143','123','155','61','79','142','223','138','154','149','151','173','157','164','161','156','137','144','215','199','59','108','212','58','117','51','78','106','62','118','213','56','114','68','159','158','220','248','186','64','63','203','126','66','115','128','96','185','167','125','100','153','124','72','104','133','224','192','198','170','183','171','180','163','177','174','169','196','175','181','176','191','172','182','208','165','166','178','184','162','179','188','227','225','229','228','226','194','230','231','210','209','232','233','245','244','242','243','235','237','234','236','193','241','238','239','240','136','217','76','152','214','195','222','148')
  32. )
  33. AND area.fldunidadauditable_id IN ('1','164','170','137','138','163','20','70','44','167','90','192','108','93','143','111','110','109','191','168','27','103','113','94','95','98','97','99','96','102','101','100','84','87','85','88','86','89','37','73','38','190','175','189','176','179','180','181','177','178','185','186','187','129','128','188','17','165','106','78','32','33','49','130','40','125','57','123','126','76','124','42','120','116','122','121','92','118','117','119','41','131','132','39','79','81','105','80','174','36','171','45','66','115','48','133','142','135','134','71','172','47','67','136','114','139','173','127','169')
  34. ORDER BY  atencion.fldatencion_estado DESC
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!