askjaskjas.sql

select
	"viewGoEmp"."USER_ID" as "viewGoEmp_USER_ID",
	"viewGoEmp"."USER_NAME" as "viewGoEmp_USER_NAME",
	"viewGoEmp"."FULL_NAME" as "viewGoEmp_FULL_NAME",
	"viewGoEmp"."EMP_ID" as "viewGoEmp_EMP_ID",
	"viewGoEmp"."EMP_NO" as "viewGoEmp_EMP_NO",
	"viewGoEmp"."POS_CODE" as "viewGoEmp_POS_CODE",
	"viewGoEmp"."POS_NAME_EN" as "viewGoEmp_POS_NAME_EN",
	"viewGoEmp"."COMPANY_ID" as "viewGoEmp_COMPANY_ID",
	"viewGoEmp"."SPV_PARENT" as "viewGoEmp_SPV_PARENT",
	"viewGoEmp"."SPV_PATH" as "viewGoEmp_SPV_PATH",
	"viewGoEmp"."PHOTO" as "viewGoEmp_PHOTO",
	"viewAttendance"."EMP_ID" as "viewAttendance_EMP_ID",
	"viewAttendance"."ATTEND_ID" as "viewAttendance_ATTEND_ID",
	"viewAttendance"."ATTEND_CODE" as "viewAttendance_ATTEND_CODE",
	"viewAttendance"."CREATED_DATE" as "viewAttendance_CREATED_DATE",
	"viewAttendance"."SHIFTDAILY_CODE" as "viewAttendance_SHIFTDAILY_CODE",
	"viewAttendance"."SHIFTSTARTTIMEX" as "viewAttendance_SHIFTSTARTTIMEX",
	"viewAttendance"."SHIFTSTARTTIME" as "viewAttendance_SHIFTSTARTTIME",
	"viewAttendance"."SHIFTENDTIME" as "viewAttendance_SHIFTENDTIME",
	"viewAttendance"."STARTTIME" as "viewAttendance_STARTTIME",
	"viewAttendance"."ENDTIME" as "viewAttendance_ENDTIME",
	"viewAttendance"."GEOLOC_START" as "viewAttendance_GEOLOC_START",
	"viewAttendance"."GEOLOC_END" as "viewAttendance_GEOLOC_END",
	"viewAttendance"."PHOTO_START" as "viewAttendance_PHOTO_START",
	"viewAttendance"."PHOTO_END" as "viewAttendance_PHOTO_END",
	"viewAttendance"."SHIFT_STARTTIME" as "viewAttendance_SHIFT_STARTTIME",
	"viewAttendance"."SHIFT_ENDTIME" as "viewAttendance_SHIFT_ENDTIME",
	"viewAttendance"."PRODUCTIVEHOURS" as "viewAttendance_PRODUCTIVEHOURS",
	"viewAttendance"."DAYTYPE" as "viewAttendance_DAYTYPE",
	"viewAttendance"."GRACEFORLATE" as "viewAttendance_GRACEFORLATE",
	"viewAttendance"."GRACE_EAI" as "viewAttendance_GRACE_EAI",
	"viewAttendance"."GRACE_LTI" as "viewAttendance_GRACE_LTI",
	"viewAttendance"."GRACE_EAO" as "viewAttendance_GRACE_EAO",
	"viewAttendance"."GRACE_LTO" as "viewAttendance_GRACE_LTO",
	"ttdttsttsdtls"."ATTEND_ID" as "ttdttsttsdtls_ATTEND_ID",
	"ttdttsttsdtls"."EMP_ID" as "ttdttsttsdtls_EMP_ID",
	"ttdttsttsdtls"."ATTEND_DATE" as "ttdttsttsdtls_ATTEND_DATE",
	"ttdttsttsdtls"."COMPANY_ID" as "ttdttsttsdtls_COMPANY_ID",
	"ttdttsttsdtls"."ATTEND_CODE" as "ttdttsttsdtls_ATTEND_CODE",
	"ttdttsttsdtls"."REMARK" as "ttdttsttsdtls_REMARK",
	"ttdttsttsdtls"."CREATED_DATE" as "ttdttsttsdtls_CREATED_DATE",
	"ttdttsttsdtls"."CREATED_BY" as "ttdttsttsdtls_CREATED_BY",
	"ttdttsttsdtls"."MODIFIED_DATE" as "ttdttsttsdtls_MODIFIED_DATE",
	"ttdttsttsdtls"."MODIFIED_BY" as "ttdttsttsdtls_MODIFIED_BY",
	"ttamattstatus"."ATTEND_CODE" as "ttamattstatus_ATTEND_CODE",
	"ttamattstatus"."ATTEND_NAME_EN" as "ttamattstatus_ATTEND_NAME_EN",
	"ttamattstatus"."ATTEND_NAME_ID" as "ttamattstatus_ATTEND_NAME_ID",
	"ttamattstatus"."ATTEND_NAME_MY" as "ttamattstatus_ATTEND_NAME_MY",
	"ttamattstatus"."ATTEND_NAME_TH" as "ttamattstatus_ATTEND_NAME_TH",
	"ttamattstatus"."ORDERNO" as "ttamattstatus_ORDERNO",
	"ttamattstatus"."PRESENT_FLAG" as "ttamattstatus_PRESENT_FLAG",
	"ttamattstatus"."CREATED_DATE" as "ttamattstatus_CREATED_DATE",
	"ttamattstatus"."CREATED_BY" as "ttamattstatus_CREATED_BY",
	"ttamattstatus"."MODIFIED_DATE" as "ttamattstatus_MODIFIED_DATE",
	"ttamattstatus"."MODIFIED_BY" as "ttamattstatus_MODIFIED_BY",
	"tgospempfavorite"."ID" as "tgospempfavorite_ID",
	"tgospempfavorite"."EMP_ID" as "tgospempfavorite_EMP_ID",
	"tgospempfavorite"."FAVORITE_ID" as "tgospempfavorite_FAVORITE_ID",
	"tgospempfavorite"."COMPANY_ID" as "tgospempfavorite_COMPANY_ID"
from
	"VIEW_GO_EMP" "viewGoEmp"
left join "VIEW_ATTENDANCE" "viewAttendance" on
	"viewAttendance"."EMP_ID" = "viewGoEmp"."EMP_ID"
	and "viewAttendance"."SHIFTSTARTTIME" <= (sysdate + nvl("viewAttendance"."GRACE_EAI", 240)/(60 * 24))
	and ("viewAttendance"."SHIFTENDTIME" + nvl("viewAttendance"."GRACE_LTO", 660)/(60 * 24)) >= '2020-10-26 08:04:12.000'
left join "TTADATTSTATUSDETAIL" "ttdttsttsdtls" on
	"ttdttsttsdtls"."ATTEND_ID" = "viewAttendance"."ATTEND_ID"
	and "ttdttsttsdtls"."ATTEND_CODE" in ('ANL','FCM','LOL','MAT','OFF','PFP','PIL','PL','PNI','SDC','SWC','TRANSPORT_LEMBUR','OVT_MEAL_HD','VLD','TOTAL_MENIT_LTI','OVT_MEAL_WD','CAP_DDR','CAP_KIM','CAP_KISK','CAP_MSC','CAP_MP','CAP_KBA')
	and "ttdttsttsdtls"."COMPANY_ID" = 18898
left join "TTAMATTSTATUS" "ttamattstatus" on
	"ttamattstatus"."ATTEND_CODE" = "ttdttsttsdtls"."ATTEND_CODE"
left join "TGOSPEMPFAVORITE" "tgospempfavorite" on
	"tgospempfavorite"."FAVORITE_ID" = "viewGoEmp"."EMP_ID"
	and "tgospempfavorite"."EMP_ID" = 'DO197621'
where
	"viewGoEmp"."SPV_PARENT" = 'DO197621'
	and "viewGoEmp"."EMP_ID" != 'DO197621'
	and "viewGoEmp"."COMPANY_ID" = 18898
	and "viewGoEmp"."EMP_ID" not in ('DO192138')
  and ( "viewGoEmp"."EMP_ID" in ('DO197621','DO198840','DO198841','DO198842','DO198843','DO191038','DO191036','DO191037','DO191039','DO191040','DO191041','DO191042','DO191043','DO191047','DO191048','DO191049','DO191050','DO191051','DO191052','DO191053','DO191054','DO191055','DO191056','DO191057','DO191058','DO191059','DO191060','DO191061','DO191062','DO191063','DO191064','DO191065','DO191066','DO191067','DO191068','DO191069','DO191070','DO191071','DO191072','DO191073','DO191074','DO191075','DO191076','DO191077','DO191078','DO191080','DO191081','DO191082','DO191083','DO191084','DO191085','DO191086','DO191087','DO191088','DO191089','DO191090','DO191091','DO191092','DO191093','DO191094','DO191095','DO192966','DO192969','DO192970','DO198418','DO199077','DO191096','DO191097','DO191098','DO191099','DO191100','DO191101','DO191102','DO191103','DO191104','DO191105','DO191106','DO191107','DO191108','DO191109','DO191110','DO191111','DO191112','DO191113','DO191114','DO191115','DO191116','DO191117','DO191118','DO191119','DO191120','DO191121','DO191122','DO191123','DO191124','DO191125','DO191126','DO191127','DO191128','DO191129','DO191131','DO191132','DO191133','DO191134','DO191135','DO191137','DO191138','DO191139','DO191140','DO191141','DO191142','DO191143','DO191145','DO191146','DO191148','DO191149','DO191151','DO191152','DO191153','DO191155','DO191156','DO191157','DO191158','DO191159','DO191160','DO191161','DO191162','DO191163','DO191164','DO191165','DO191166','DO191167','DO191168','DO191169','DO191170','DO191171','DO191172','DO191173','DO191174','DO191175','DO191176','DO191177','DO191178','DO191179','DO191180','DO191181','DO191182','DO191183','DO191184','DO191185','DO191186','DO191187','DO191188','DO191189','DO191190','DO191191','DO191192','DO191193','DO191194','DO191195','DO191196','DO191197','DO191198','DO191199','DO191200','DO191201','DO191202','DO191203','DO191204','DO191205','DO191206','DO191207','DO191208','DO191209','DO191210','DO191211','DO191214','DO191215','DO191216','DO191217','DO191218','DO191219','DO191220','DO191221','DO192971','DO192972','DO192973','DO192974','DO192975','DO192976','DO192977','DO192978','DO192979','DO192980','DO192981','DO192982','DO192983','DO192984','DO192986','DO192987','DO192989','DO192990','DO192991','DO192992','DO192993','DO192995','DO192996','DO192998','DO192999','DO193497','DO191150','DO191154','DO191213','DO192994','DO192997','DO198441','DO198512','DO198513','DO198661','DO198844','DO198845','DO198846','DO198847','DO198848','DO198849','DO198850','DO198851','DO198852','DO198853','DO198854','DO198855','DO198856','DO190108','DO190115','DO191144','DO190568','DO190578','DO190585','DO190595','DO190598','DO190793','DO192848','DO192896','DO192913','DO198403','DO198577','DO198578','DO198579','DO198580','DO198581','DO198582','DO198583','DO198584','DO198585','DO198586','DO198587','DO198589','DO198590','DO198591','DO198592','DO198593','DO198668','DO198669','DO198684','DO198825','DO198826','DO198827','DO190463','DO190464','DO190465','DO190466','DO190467','DO190468','DO190469','DO190470','DO190471','DO190472','DO190473','DO190693','DO190694','DO190474','DO190475','DO190476','DO190477','DO190478','DO190479','DO190480','DO190481','DO190482','DO190483','DO190484','DO190485','DO190486','DO190487','DO190488','DO190489','DO190490','DO190491','DO190492','DO190493','DO190494','DO190495','DO190496','DO190497','DO190498','DO190499','DO190500','DO190501','DO190502','DO190503','DO190504','DO190505','DO190506','DO190507','DO190508','DO190509','DO190510','DO190511','DO190512','DO190513','DO190514','DO190515','DO190516','DO190517','DO190518','DO190519','DO190520','DO190521','DO190522','DO190523','DO190524','DO190525','DO190526','DO190527','DO190528','DO190529','DO190530','DO190531','DO190532','DO190533','DO190534','DO190535','DO190536','DO190537','DO190538','DO190539','DO190540','DO190541','DO190542','DO190543','DO190544','DO190545','DO190546','DO190547','DO190548','DO190549','DO190551','DO190552','DO190555','DO190556','DO190557','DO190559','DO190561','DO190562','DO190563','DO190564','DO190569','DO190570','DO190571','DO190572','DO190573','DO190575','DO190576','DO190579','DO190580','DO190581','DO190582','DO190583','DO190584','DO190586','DO190587','DO190588','DO190591','DO190596','DO190597','DO190599','DO190600','DO190601','DO190602','DO190603','DO190604','DO190605','DO190606','DO190607','DO190608','DO190609','DO190610','DO190611','DO190612','DO190613','DO190614','DO190615','DO190616','DO190617','DO190618','DO190619','DO190620','DO190621','DO190622','DO190623','DO190624','DO190625','DO190626','DO190627','DO190628','DO190629','DO190630','DO190631','DO190632','DO190633','DO190634','DO190635','DO190636','DO190637','DO190638','DO190639','DO190640','DO190641','DO190642','DO190643','DO190644','DO190645','DO190646','DO190647','DO190648','DO190649','DO190650','DO190651','DO190652','DO190653','DO190654','DO190655','DO190656','DO190657','DO190658','DO190659','DO190660','DO190661','DO190662','DO190663','DO190664','DO190665','DO190666','DO190667','DO190668','DO190669','DO190670','DO190671','DO190672','DO190673','DO190674','DO190675','DO190676','DO190677','DO190678','DO190679','DO190680','DO190681','DO190682','DO190683','DO190684','DO190685','DO190686','DO190687','DO190688','DO190689','DO190690','DO190691','DO190692','DO190695','DO190696','DO190697','DO190698','DO190699','DO190700','DO190701','DO190702','DO190703','DO190704','DO190705','DO190706','DO190707','DO190708','DO190709','DO190710','DO190711','DO190712','DO190713','DO190714','DO190715','DO190716','DO190717','DO190718','DO190719','DO190720','DO190721','DO190722','DO190723','DO190724','DO190725','DO190726','DO190727','DO190728','DO190729','DO190730','DO190731','DO190732','DO190733','DO190734','DO190735','DO190736','DO190737','DO190738','DO190739','DO190740','DO190741','DO190742','DO190743','DO190744','DO190746','DO190747','DO190748','DO190749','DO190750','DO190751','DO190752','DO190753','DO190754','DO190755','DO190756','DO190757','DO190758','DO190759','DO190760','DO190761','DO190762','DO190763','DO190764','DO190765','DO190766','DO190767','DO190768','DO190769','DO190770','DO190771','DO190772','DO190773','DO190774','DO190775','DO190776','DO190777','DO190778','DO190779','DO190780','DO190781','DO190783','DO190784','DO190785','DO190786','DO190787','DO190788','DO190789','DO190790','DO190791','DO190792','DO190794','DO190795','DO190796','DO190797','DO190798','DO190799','DO190800','DO190801','DO190802','DO190803','DO190804','DO190805','DO190806','DO190807','DO190808','DO190809','DO190810','DO190811','DO190812','DO190813','DO190814','DO192229','DO192819','DO192820','DO192822','DO192826','DO192827','DO192828','DO192829','DO192830','DO192832','DO192833','DO192834','DO192835','DO192836','DO192837','DO192838','DO192840','DO192841','DO192842','DO192843','DO192844','DO192845','DO192846','DO192851','DO192852','DO192858','DO192859','DO192861','DO192865','DO192866','DO192867','DO192868','DO192869','DO192870','DO192871','DO192872','DO192874','DO192875','DO192877','DO192878','DO192879','DO192880','DO192884','DO192885','DO192886','DO192887','DO192888','DO192889','DO192890','DO192891','DO192892','DO192893','DO192894','DO192895','DO192898','DO192899','DO192900','DO192902','DO192903','DO192904','DO192905','DO192906','DO192908','DO192909','DO192910','DO192911','DO192912','DO192914','DO192915','DO192916','DO192917','DO192918','DO193492','DO193493','DO198124','DO198125','DO198289','DO190250','DO190252','DO190253','DO190254','DO190255','DO190256','DO190258','DO190259','DO190260','DO190261','DO190262','DO190263','DO190264','DO190265','DO190266','DO190267','DO190268','DO190269','DO190270','DO190271','DO190272','DO190273','DO190274','DO190275','DO190276','DO190277','DO190278','DO190279','DO190280','DO190281','DO190282','DO190283','DO190284','DO190285','DO190286','DO190287','DO190288','DO190289','DO209834','DO190290','DO190291','DO190292','DO190293','DO190294','DO190295','DO190296','DO190297','DO190298','DO190057','DO190058','DO190059','DO190060','DO190061','DO190062','DO190063','DO190064','DO190065','DO190066','DO190067','DO190068','DO190070','DO190071','DO190072','DO190073','DO190074','DO190075','DO190076','DO190077','DO190078','DO190079','DO190080','DO190081','DO190082','DO190083','DO190084','DO190085','DO190086','DO190087','DO190088','DO190089','DO190090','DO190091','DO190092','DO190093','DO190094','DO190095','DO190096','DO190097','DO190098','DO190099','DO190100','DO190101','DO190102','DO190103','DO190104','DO190105','DO190106','DO190107','DO190109','DO190110','DO190111','DO190112','DO190113','DO190114','DO190116','DO190117','DO190118','DO190119','DO190120','DO190121','DO190122','DO190123','DO190124','DO190125','DO190126','DO190127','DO190128','DO190129','DO190130','DO190131','DO190132','DO190133','DO190135','DO190136','DO190137','DO190138','DO190139','DO190141','DO190142','DO190143','DO190144','DO190145','DO190146','DO190147','DO190148','DO190149','DO190150','DO190151','DO190152','DO190153','DO190154','DO190155','DO190156','DO190157','DO190158','DO190159','DO190160','DO190161','DO190162','DO190163','DO190164','DO190165','DO190166','DO190167','DO190168','DO190169','DO190171','DO190172','DO190173','DO190174','DO190175','DO190176','DO190177','DO190179','DO190180','DO190181','DO190182','DO190183','DO190184','DO190186','DO190187','DO190188','DO190189','DO190190','DO190191','DO190192','DO190193','DO190194','DO190195','DO190196','DO190197','DO190198','DO190199','DO190200','DO190201','DO190203','DO190205','DO190206','DO190207','DO190208','DO190209','DO190210','DO190211','DO190212','DO190213','DO190214','DO190215','DO190216','DO190217','DO190218','DO190219','DO190220','DO190221','DO190222','DO190223','DO190224','DO190226','DO190227','DO190228','DO190229','DO190230','DO190231','DO190232','DO190233','DO190234','DO190235','DO190236','DO190237','DO190238','DO190239','DO190240','DO190241','DO190242','DO190243','DO190244','DO190245','DO190246','DO190247','DO190248','DO190249','DO190443','DO190444','DO190445','DO190446','DO190447','DO190448','DO190449','DO190450','DO190451','DO190452','DO190453','DO190454','DO190455','DO190456','DO190457','DO190459','DO190460','DO190461','DO190590','DO190593','DO190594','DO190553','DO190554','DO190558','DO209818','DO190565','DO190577','DO190589','DO190299','DO190300','DO190301','DO190302','DO190303','DO190304','DO190305','DO190306','DO190307','DO190308','DO190309','DO190310','DO190311','DO190312','DO190313','DO190314','DO190315','DO190316','DO190317','DO190318','DO190319','DO190320','DO190321','DO190322','DO190323','DO190324','DO190325','DO190326','DO190327','DO190328','DO190329','DO190330','DO190331','DO190332','DO190333','DO190334','DO190335','DO190336','DO190337','DO190339','DO190340','DO190341','DO190342','DO190343','DO190344','DO190346','DO190347','DO190348','DO190349','DO190350','DO190351','DO190352','DO190353','DO190354','DO190355','DO190356','DO190357','DO190358','DO190359','DO190360','DO190361','DO190362','DO190363','DO190364','DO190365','DO190366','DO190367','DO190368','DO190369') or "viewGoEmp"."EMP_ID" in ('DO190371','DO190373','DO190374','DO190375','DO190376','DO190377','DO190378','DO190379','DO190380','DO190381','DO190382','DO190383','DO190384','DO190385','DO190386','DO190387','DO190388','DO190390','DO190392','DO190393','DO190395','DO190396','DO190397','DO190398','DO190399','DO190400','DO190401','DO190402','DO190403','DO190404','DO190405','DO190406','DO190407','DO190408','DO190409','DO190410','DO190411','DO190412','DO190413','DO190414','DO190415','DO190416','DO190417','DO190418','DO190419','DO190420','DO190422','DO190423','DO190424','DO190425','DO190426','DO190427','DO190428','DO190429','DO190430','DO190431','DO190432','DO190433','DO190434','DO190435','DO190436','DO190437','DO190438','DO190439','DO190440','DO190441','DO190442','DO190880','DO190881','DO190882','DO190883','DO190884','DO190885','DO190886','DO190887','DO190888','DO190889','DO190890','DO190891','DO190892','DO190893','DO190894','DO190895','DO190896','DO190897','DO190898','DO190899','DO209822','DO190901','DO190902','DO190903','DO190904','DO190905','DO190906','DO190907','DO190908','DO190910','DO190911','DO190912','DO190913','DO190914','DO190915','DO190916','DO190917','DO190918','DO190919','DO190920','DO190921','DO190922','DO190923','DO190924','DO190925','DO190926','DO190927','DO190928','DO190929','DO190930','DO190931','DO190932','DO190933','DO190934','DO190935','DO190936','DO190937','DO190938','DO190939','DO190940','DO190942','DO190943','DO190945','DO190947','DO190948','DO190949','DO190950','DO190951','DO190952','DO190953','DO190955','DO190956','DO190957','DO190958','DO190959','DO190960','DO190961','DO190962','DO190963','DO190964','DO190965','DO190966','DO190968','DO190969','DO190970','DO190971','DO190972','DO190973','DO190974','DO190975','DO190976','DO190977','DO190978','DO190979','DO190980','DO190981','DO190982','DO190983','DO190984','DO190985','DO190988','DO190989','DO190990','DO190991','DO190992','DO190993','DO190994','DO190995','DO190996','DO190997','DO190998','DO190999','DO191000','DO191002','DO191003','DO191004','DO191005','DO191006','DO191007','DO191008','DO191009','DO191010','DO191011','DO191012','DO191013','DO191014','DO191015','DO191016','DO191017','DO191018','DO191019','DO191020','DO191021','DO191022','DO191023','DO191024','DO191025','DO191026','DO191027','DO190745','DO190815','DO190816','DO190817','DO190818','DO190819','DO190820','DO190821','DO190822','DO190823','DO190824','DO190825','DO190826','DO190827','DO190828','DO190829','DO190830','DO190831','DO190832','DO190833','DO190834','DO190835','DO190836','DO190837','DO190838','DO190839','DO190840','DO190841','DO190842','DO190843','DO190844','DO190846','DO190847','DO190848','DO190849','DO190850','DO190851','DO190852','DO190853','DO190854','DO190855','DO190856','DO190857','DO190858','DO190859','DO190860','DO190861','DO190862','DO190863','DO190864','DO190865','DO190866','DO190867','DO190868','DO190869','DO190870','DO190871','DO190872','DO190873','DO190874','DO190875','DO190876','DO190877','DO190878','DO190879','DO191212','DO191222','DO191223','DO191224','DO191225','DO191226','DO191227','DO191228','DO191229','DO191230','DO191231','DO191233','DO191234','DO191235','DO191236','DO191237','DO191238','DO191239','DO191240','DO191241','DO191242','DO191243','DO191244','DO191245','DO191246','DO191247','DO191249','DO191250','DO191251','DO191252','DO191253','DO191254','DO191255','DO191256','DO191257','DO191258','DO191259','DO191260','DO191261','DO191262','DO191263','DO191264','DO191265','DO191266','DO191267','DO191268','DO191269','DO191318','DO191319','DO191320','DO191321','DO191322','DO191323','DO191324','DO191325','DO191326','DO191327','DO191329','DO191330','DO191332','DO191333','DO191335','DO191336','DO191337','DO191338','DO191339','DO191340','DO191341','DO191342','DO191345','DO191346','DO191347','DO191349','DO191350','DO191351','DO191352','DO191353','DO191354','DO191355','DO191356','DO191358','DO191360','DO191361','DO191362','DO191363','DO191364','DO191365','DO191366','DO191367','DO191368','DO191370','DO191371','DO191372','DO191374','DO191375','DO191377','DO191378','DO191379','DO191380','DO191381','DO191382','DO191384','DO191385','DO191386','DO191387','DO191388','DO191389','DO191390','DO191391','DO191393','DO191394','DO191395','DO191396','DO191398','DO191399','DO191400','DO191401','DO191402','DO191403','DO191404','DO191405','DO191406','DO191407','DO191408','DO191411','DO191412','DO191413','DO191270','DO191271','DO191272','DO191273','DO191274','DO191275','DO191276','DO191277','DO191278','DO191280','DO191282','DO191283','DO191284','DO191285','DO191286','DO191287','DO191288','DO191289','DO191290','DO191291','DO191292','DO191293','DO191294','DO191295','DO191296','DO191297','DO191298','DO191299','DO191300','DO191301','DO191302','DO191303','DO191304','DO191305','DO191306','DO191307','DO191308','DO191309','DO191310','DO191311','DO191312','DO191313','DO191314','DO191315','DO191316','DO191317','DO191028','DO191029','DO191030','DO191031','DO191032','DO191033','DO191034','DO191035','DO191045','DO191046','DO191079','DO191147','DO191602','DO191603','DO191604','DO191605','DO191606','DO191607','DO191608','DO191609','DO191610','DO191611','DO191612','DO191613','DO191616','DO191617','DO191618','DO191619','DO191621','DO191622','DO191623','DO191624','DO191625','DO191626','DO191628','DO191629','DO191630','DO191631','DO191632','DO191633','DO191634','DO191635','DO191636','DO191637','DO191638','DO191639','DO191640','DO191641','DO191642','DO191643','DO191644','DO191646','DO191648','DO191649','DO191650','DO191651','DO191652','DO191653','DO191654','DO191655','DO191656','DO191657','DO191658','DO191659','DO191660','DO191661','DO191662','DO191663','DO191664','DO191665','DO191666','DO191667','DO191668','DO191669','DO191670','DO191671','DO191672','DO191673','DO191674','DO191675','DO191676','DO191677','DO191678','DO191679','DO191680','DO191681','DO191682','DO191683','DO191684','DO191685','DO191686','DO191687','DO191688','DO191689','DO191690','DO191691','DO191692','DO191693','DO191694','DO191695','DO191696','DO191697','DO191698','DO191699','DO191700','DO191701','DO191702','DO191703','DO191704','DO191705','DO191706','DO191707','DO191708','DO191709','DO191710','DO191711','DO191712','DO191713','DO191714','DO191715','DO191716','DO191717','DO191718','DO191719','DO191720','DO191721','DO191722','DO191723','DO191724','DO191725','DO191727','DO191728','DO191729','DO191730','DO191731','DO191732','DO191733','DO191734','DO191735','DO191736','DO191737','DO191738','DO191739','DO191740','DO191741','DO191742','DO191743','DO191744','DO191745','DO191746','DO191747','DO191748','DO191416','DO191417','DO191418','DO191419','DO191420','DO191421','DO191422','DO191423','DO191424','DO191425','DO191426','DO191427','DO191428','DO191429','DO191430','DO191431','DO191432','DO191433','DO191434','DO191435','DO191436','DO191437','DO191438','DO191439','DO191441','DO191442','DO191443','DO191444','DO191445','DO191446','DO191447','DO191448','DO191449','DO191450','DO191451','DO191452','DO191453','DO191455','DO191457','DO191458','DO191459','DO191460','DO191461','DO191462','DO191463','DO191464','DO191466','DO191467','DO191468','DO191469','DO191470','DO191471','DO191472','DO191475','DO191477','DO191478','DO191479','DO191480','DO191481','DO191482','DO191483','DO191485','DO191486','DO191487','DO191488','DO191489','DO191490','DO191491','DO191492','DO191493','DO191494','DO191495','DO191496','DO191497','DO191498','DO191499','DO191501','DO191502','DO191503','DO191504','DO191505','DO191506','DO191507','DO191508','DO191509','DO191511','DO191512','DO191513','DO191514','DO191515','DO191516','DO191517','DO191518','DO191519','DO191520','DO191524','DO191525','DO191526','DO191527','DO191528','DO191529','DO191530','DO191531','DO191532','DO191533','DO191534','DO191536','DO191537','DO191538','DO191539','DO191540','DO191541','DO191542','DO191543','DO191546','DO191547','DO191548','DO191550','DO191551','DO191552','DO191553','DO191554','DO191555','DO191556','DO191557','DO191559','DO191560','DO191561','DO191562','DO191564','DO191565','DO191567','DO191568','DO191569','DO191570','DO191571','DO191572','DO191573','DO191574','DO191576','DO191577','DO191579','DO191580','DO191582','DO191584','DO191585','DO191586','DO191587','DO191588','DO191590','DO191591','DO191592','DO191593','DO191594','DO191595','DO191596','DO191598','DO191599','DO191600','DO191601','DO191914','DO191915','DO191916','DO191917','DO191918','DO191919','DO191920','DO191921','DO191922','DO191923','DO191924','DO191925','DO191926','DO191927','DO191928','DO191929','DO191930','DO191931','DO191932','DO191933','DO191934','DO191935','DO191936','DO191937','DO191938','DO191939','DO191940','DO191941','DO191942','DO191943','DO191944','DO191945','DO191946','DO191947','DO191948','DO191949','DO191950','DO191951','DO191952','DO191953','DO191954','DO191955','DO191956','DO191957','DO191958','DO191959','DO191960','DO191961','DO191962','DO191963','DO191964','DO191965','DO191966','DO191967','DO191968','DO191969','DO191970','DO191971','DO191972','DO191973','DO191974','DO191975','DO191976','DO191977','DO191978','DO191979','DO191980','DO191981','DO191982','DO191983','DO191984','DO191985','DO191986','DO191987','DO191988','DO191989','DO191990','DO191991','DO191992','DO191993','DO191994','DO191995','DO191996','DO191997','DO191998','DO191999','DO192000','DO192001','DO192002','DO192003','DO192004','DO192005','DO192006','DO192007','DO192008','DO192009','DO192010','DO192062','DO192063','DO192064','DO192065','DO192066','DO192067','DO192069','DO192070','DO192071','DO192072','DO192073','DO192074','DO192076','DO192077','DO192078','DO192079','DO192080','DO192081','DO192082','DO192083','DO192084','DO192085','DO192086','DO192087','DO192088','DO192089','DO192093','DO192094','DO192095','DO192096','DO192097','DO192098','DO192100','DO192101','DO192102','DO192104','DO192107','DO192108','DO192109','DO192110','DO192111','DO192112','DO192114','DO192115','DO192116','DO192117','DO192118','DO192119','DO192120','DO192121','DO192122','DO192123','DO192124','DO192125','DO192127','DO192128','DO192129','DO192130','DO192131','DO192132','DO192133','DO192134','DO192135','DO192136','DO192137','DO192138','DO192139','DO192140','DO192141','DO192142','DO192143','DO192144','DO192145','DO192146','DO192147','DO192148','DO192149','DO192150','DO192151','DO192152','DO192153','DO192154','DO192155','DO192156','DO192157','DO192159','DO192160','DO192161','DO192162','DO192163','DO192011','DO192012','DO192013','DO192014','DO192015','DO192016','DO192017','DO192018','DO192019','DO192020','DO192021','DO192022','DO192023','DO192024','DO192025','DO192026','DO192027','DO192028','DO192029','DO192030','DO192031','DO192032','DO192033','DO192034','DO192035','DO192036','DO192038','DO192039','DO192040','DO192041','DO192042','DO192043','DO192044','DO192045','DO192046','DO192047','DO192048','DO192049','DO192050','DO192051','DO192052','DO192053','DO192054','DO192055','DO192056','DO192057','DO192058','DO192059','DO192060','DO191749','DO191750','DO191751','DO191752','DO191753','DO191754','DO191777','DO191778'))
ORDER BY
  "ttamattstatus"."ORDERNO" ASC
FETCH NEXT 5 ROWS ONLY