File: C:\AssetWorks\FASuite\main-ora\Logs\202608\20260811\WebModules\ORAMAIN\sqlerr.log
- ==========[ 08/11/2026 10:44:22 ]==========
SQL LEAK DETECTION (Idle) Registered: True - Time idle: 5 seconds - loc_work_order_loc=BALOC
work_order_yr=2025
work_order_no=13
SELECT ST.LOC_WORK_ORDER_LOC, ST.WORK_ORDER_YR, ST.WORK_ORDER_NO, ST.TASK_TASK_CODE, TSK_MAIN.completion_status, TSK_MAIN.qty_labor_hrs_chargd, TSK_MAIN.WARRANTY,TSK_MAIN.WAC_WAC_CODE, TSK_MAIN.ROW_ID, TSK_MAIN.TASK_TYPE, TSK_MAIN.QTY_LABOR_HRS_EST, TSK_MAIN.PRI_PRIORITY_CODE, TSK_MAIN.datetime_completed, TSK_MAIN.task_proc_version, TSK_MAIN.class_task_proc_version,(SELECT DESCRIPTION FROM WAC_MAIN WHERE WAC_WAC_CODE=TSK_MAIN.WAC_WAC_CODE) AS WAC_DESC,(SELECT FINAL_STATUS FROM WAC_MAIN WHERE WAC_WAC_CODE=TSK_MAIN.WAC_WAC_CODE) AS WAC_FINAL_STATUS,(SELECT DESCRIPTION FROM DES_MAIN WHERE TASK_TASK_CODE=ST.TASK_TASK_CODE) AS DESCRIPTION FROM TSK_MAIN RIGHT OUTER JOIN (SELECT SRV_TASKS.TASK_TASK_CODE, SRV_MAIN.LOC_WORK_ORDER_LOC, SRV_MAIN.WORK_ORDER_YR, SRV_MAIN.WORK_ORDER_NO FROM SRV_TASKS INNER JOIN SRV_MAIN ON SRV_TASKS.SRV_ID=SRV_MAIN.UNIQUE_ID WHERE LOC_WORK_ORDER_LOC=:loc_work_order_loc AND WORK_ORDER_YR=:work_order_yr AND WORK_ORDER_NO=:work_order_no UNION SELECT SRV_MAIN.TASK_TASK_CODE, SRV_MAIN.LOC_WORK_ORDER_LOC, SRV_MAIN.WORK_ORDER_YR, SRV_MAIN.WORK_ORDER_NO FROM SRV_MAIN WHERE LOC_WORK_ORDER_LOC=:loc_work_order_loc AND WORK_ORDER_YR=:work_order_yr AND WORK_ORDER_NO=:work_order_no AND SRV_MAIN.TASK_TASK_CODE IS NOT NULL) ST ON TSK_MAIN.LOC_WORK_ORDER_LOC=ST.LOC_WORK_ORDER_LOC AND TSK_MAIN.WORK_ORDER_YR=ST.WORK_ORDER_YR AND TSK_MAIN.WORK_ORDER_NO=ST.WORK_ORDER_NO AND TSK_MAIN.TASK_TASK_CODE=ST.TASK_TASK_CODE WHERE (TASK_TYPE IS NULL OR TASK_TYPE='R' OR TASK_TYPE='P')