select "a14".

"CHI_OP_ID" "CHI_OP_ID",
"a19"."CHI_OP_NAME" "HSUPERVISOR_NAME",
("a19"."CHI_OP_CODE" || ' - ' || "a19"."CHI_OP_NAME") "CustCol_12",
"a19"."CHI_OP_CODE" "CHI_OP_CODE",
"a13"."EMPLOYEE_CODE" "EMPLOYEE_CODE",
"a13"."EMPLOYEE_NAME" "EMPLOYEE_NAME",
"a13"."EMPLOYEE_CODE_META4" "EMPLOYEE_CODE_META4",
"a13"."SHORT_NAME" "SHORT_NAME",
"a13"."BAHIA_ID" "BAHIA_ID",
"a110"."BAHIA_NAME" "BAHIA_NAME",
"a110"."BAHIA_CODE" "BAHIA_CODE",
"a15"."TC_NUMBER" "TC_NUMBER",
"a15"."TC_DESCRIPTION" "TC_DESCRIPTION",
"a15"."TC_NUMBER_COMPLETE" "TC_NUMBER_COMPLETE",
"a17"."ACREG" "ACREG",
("a16"."ORDER_YEAR" || ' ' || "a16"."ORDER_NUMBER" || ' / ' ||
"a16"."WORK_ORDER_NUMBER") "CustCol_13",
"a18"."HANGAR_ID" "HANGAR_ID",
sum("a11"."WORK_HOURS_DETAIL") "REALTIMEDETAIL"
from "DW_FAC_OPERATIVE_TIME_DETAIL" "a11"
join "L_CAL_HOUR" "a12"
on ("a11"."HOUR_ID" = "a12"."HOUR_ID")
join "DW_DIM_WORKER" "a13"
on ("a11"."SEQ_EMPLOYEE" = "a13"."SEQ_EMPLOYEE")
join "L_SUPERVISOR_OP" "a14"
on ("a11"."HIERARCHY_OP_ID" = "a14"."HIERARCHY_OP_ID")
join "DW_DIM_TASK_CARD" "a15"
on ("a11"."SEQ_WO" = "a15"."SEQ_WO")
join "DW_LOV_WORK_ORDER" "a16"
on ("a15"."WORK_ORDER_ID" = "a16"."WORK_ORDER_ID")
join "DW_DIM_AIRCRAFT" "a17"
on ("a16"."AIRCRAFT_KEY" = "a17"."AIRCRAFT_KEY")
join "L_WO_UBICATION" "a18"
on ("a16"."WO_UBI_ID" = "a18"."WO_UBI_ID")
join "L_CHIEF_OP" "a19"
on ("a14"."CHI_OP_ID" = "a19"."CHI_OP_ID")
join "L_BAHIA" "a110"
on ("a13"."BAHIA_ID" = "a110"."BAHIA_ID")
where "BAHIA_NAME" = 'BAHIA - 11'
and "a13"."EMPLOYEE_CODE" in ('60846', '8691821', '8688519', '8687821', '8687121',
'8686521', '8686321', '8684919', '8682919', '8682419', '8682319', '8681918',
'8681418', '8678318', '8677921', '8677121', '8672619', '8671419', '8668818',
'8667621', '8665108', '8656018', '8654418', '8654218', '8653018', '8651218',
'8648021', '8647821', '8647721', '8647621', '8647618', '8647321', '8647221',
'8647121', '8647021', '8646921', '8646821', '8646721', '8646621', '8646521',
'8646421', '8646221', '8646218', '8644518', '8643215', '8643208', '8642518',
'8642008', '8641821', '8641815', '8641521', '8641221', '8640721', '8640521',
'8640519', '8640415', '8640315', '8640215', '8640021', '8639908', '8637715',
'8635419', '8634808', '8634518', '8634218', '8634217', '8634212', '8633912',
'8633812', '8633712', '8633512', '8633312', '8632912', '8632812', '8632712',
'8632612', '8632412', '8632312', '8632212', '8632012', '8631912', '8631712',
'8631418', '8631312', '8631221', '8630918', '8630912', '8630812', '8630515',
'8630512', '8630312', '8630012', '8629912', '8629812', '8629612', '8629512',
'8629312', '8629211', '8629008', '8628711', '8628611', '8628212', '8628211',
'8628011', '8627819', '8627812', '8627808', '8627711', '8627612', '8627611',
'8627318', '8627212', '8627112', '8627108', '8626912', '8626815', '8626712',
'8626512', '8626418', '8626411', '8626311', '8626219', '8626211', '8626119',
'8626019', '8626012', '8625615', '8625612', '8625412', '8625311', '8625111',
'8624912', '8624712', '8624711', '8624708', '8624612', '8624511', '8624012',
'8623812', '8623712', '8623711', '8623612', '8623608', '8623512', '8623511',
'8623412', '8623411', '8623212', '8622918', '8622912', '8622818', '8622812',
'8622718', '8622712', '8622711', '8622612', '8622518', '8622512', '8622418',
'8622411', '8622312', '8622311', '8622218', '8622212', '8622211', '8622206',
'8622119', '8622118', '8622112', '8622018', '8622012', '8621918', '8621911',
'8621818', '8621812', '8621618', '8621612', '8621611', '8621518', '8621512',
'8621511', '8621320', '8621318', '8621311', '8621212', '8621111', '8621018',
'8621011', '8620918', '8620817', '8620718', '8620711', '8620518', '8620511',
'8620418', '8620411', '8620318', '8620218', '8620211', '8620111', '8620018',
'8620011', '8619817', '8619718', '8619618', '8619418', '8619318', '8619219',
'8619218', '8619118', '8619018', '8618919', '8618912', '8618718', '8618518',
'8618411', '8618319', '8618318', '8618218', '8618205', '8618118', '8618018',
'8617918', '8617818', '8617718', '8617618', '8617518', '8617218', '8617212',
'8617211', '8617019', '8617012', '8616719', '8616611', '8616521', '8616515',
'8616421', '8616318', '8616212', '8616211', '8616207', '8616111', '8616011',
'8615921', '8615912', '8615821', '8615712', '8615605', '8615400', '8615311',
'8615117', '8615012', '8614912', '8614412', '8614212', '8614211', '8614112',
'8614012', '8613912', '8613911', '8613812', '8613711', '8613696', '8613411',
'8613320', '8613311', '8612905', '8612709', '8612604', '8612512', '8612411',
'8612405', '8612012', '8611912', '8611812', '8611612', '8611312', '8611204',
'8611117', '8610411', '8610312', '8610218', '8610212', '8610118', '8610112',
'8610019', '8610018', '8609818', '8609718', '8609618', '8609613', '8609518',
'8609509', '8609418', '8609406', '8609399', '8609318', '8609304', '8609118',
'8609018', '8608918', '8608818', '8608796', '8608718', '8608618', '8608518',
'8608418', '8608409', '8608118', '8608018', '8608011', '8607918', '8607818',
'8607718', '8607618', '8607518', '8607418', '8607318', '8606711', '8606618',
'8606518', '8606418', '8606403', '8606318', '8606211', '8606118', '8606111',
'8605918', '8605911', '8605818', '8605716', '8605621', '8605611', '8605521',
'8605518', '8605421', '8605418', '8605318', '8605218', '8605111', '8605018',
'8604699', '8604618', '8604418', '8604400', '8604399', '8604316', '8604213',
'8604118', '8604018', '8603918', '8603818', '8603718', '8603620', '8603315',
'8603118', '8603002', '8602919', '8602918', '8602718', '8602618', '8602518',
'8602497', '8602318', '8602303', '8602119', '8601718', '8601618', '8601518',
'8601418', '8601310', '8601218', '8601118', '8600918', '8600818', '8600713',
'8600618', '8600518', '8600418', '8600316', '8600218', '8600118', '80996', '61051',
'60961', '60827', '60710', '8669118', '8679819', '8649018', '8678021', '8665418',
'8621920', '8671920', '8672019', '8642922', '8626821', '8644620', '8647420')
and "a12"."DATE_ID" = To_Date('2024-01-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
group by "a14"."CHI_OP_ID",
"a19"."CHI_OP_NAME",
("a19"."CHI_OP_CODE" || ' - ' || "a19"."CHI_OP_NAME"),
"a19"."CHI_OP_CODE",
"a13"."EMPLOYEE_CODE",
"a13"."EMPLOYEE_NAME",
"a13"."EMPLOYEE_CODE_META4",
"a13"."SHORT_NAME",
"a13"."BAHIA_ID",
"a110"."BAHIA_NAME",
"a110"."BAHIA_CODE",
"a15"."TC_NUMBER",
"a15"."TC_DESCRIPTION",
"a15"."TC_NUMBER_COMPLETE",
"a17"."ACREG",
("a16"."ORDER_YEAR" || ' ' || "a16"."ORDER_NUMBER" || ' / ' ||
"a16"."WORK_ORDER_NUMBER"),
"a18"."HANGAR_ID"