Logs - main-ora - InfoCenter - FA/EAM Web Management

File: C:\AssetWorks\FASuite\main-ora\Logs\202608\20260810\WebModules\ORAMAIN\sqlerr.log

==========[ 08/10/2026 15:47:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 8 seconds - loc_work_order_loc=WBLOC1

```
work_order_yr=2025
```
```
work_order_no=7
```

SELECT row_id,comment_area,x_datetime_insert,usr_userid,task_task_code,srv_id,(SELECT name FROM USR_MAIN WHERE usr_userid=JOB_NOTES.usr_userid) AS USER_NAME FROM EMSDBA.JOB_NOTES WHERE loc_work_order_loc = :loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no ORDER BY x_datetime_insert  DESC

==========[ 08/10/2026 15:47:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 33 seconds - loc_work_order_loc=BALOC

```
work_order_yr=2025
```
```
work_order_no=1
```

SELECT NO_PARTIAL_ISSUE,request_id,ROW_ID FROM EMSDBA.PTS_REQUEST_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 (EXISTS(SELECT REQUEST_ID FROM PTS_REQUEST WHERE Notify_Flag='Y' AND REQUEST_ID=PTS_REQUEST_MAIN.REQUEST_ID AND LOC_WORK_ORDER_LOC='BALOC' AND WORK_ORDER_YR='2025' AND WORK_ORDER_NO='1'))

==========[ 08/10/2026 15:47:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 46 seconds - loc_work_order_loc=BALOC

```
work_order_yr=2025
```
```
work_order_no=1
```

SELECT NO_PARTIAL_ISSUE,request_id,ROW_ID FROM EMSDBA.PTS_REQUEST_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 (EXISTS(SELECT REQUEST_ID FROM PTS_REQUEST WHERE Notify_Flag='Y' AND REQUEST_ID=PTS_REQUEST_MAIN.REQUEST_ID AND LOC_WORK_ORDER_LOC='BALOC' AND WORK_ORDER_YR='2025' AND WORK_ORDER_NO='1'))

==========[ 08/10/2026 15:47:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 9 seconds - asset_type=ASSET

SELECT asset_type,is_linear,legacy_type,subcategory,ROW_ID FROM EMSDBA.ASSET_TYPE WHERE  (asset_type=:asset_type)

==========[ 08/10/2026 15:57:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 31 seconds - loc_work_order_loc=WBLOC1

```
work_order_yr=2025
```
```
work_order_no=6
```

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')

==========[ 08/10/2026 15:57:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 31 seconds - loc_work_order_loc=ACA

```
work_order_yr=2017
```
```
work_order_no=366
```

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')

==========[ 08/10/2026 15:57:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 5 seconds - task_task_code=001

```
loc_work_order_loc=
```
```
work_order_yr=0
```
```
work_order_no=0
```

SELECT * FROM EMSDBA.PTS_REQUEST WHERE loc_work_order_loc = :loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no AND (action IS NULL)  AND (task_task_code=:task_task_code)  ORDER BY request_id ASC,group_row_id ASC

==========[ 08/10/2026 16:07:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 19 seconds - woloc=BALOC

```
woyear=2025
```
```
wonumber=5
```

SELECT erq_req_id,line_no,ptsreq_line_id,ROW_ID FROM EMSDBA.ERQ_WORKORD WHERE loc_work_order_loc = :woloc AND work_order_yr = :woyear AND work_order_no = :wonumber

==========[ 08/10/2026 16:12:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 54 seconds - loc_work_order_loc=BALOC

```
work_order_yr=2025
```
```
work_order_no=1
```

SELECT row_id,comment_area,x_datetime_insert,usr_userid,task_task_code,srv_id,(SELECT name FROM USR_MAIN WHERE usr_userid=JOB_NOTES.usr_userid) AS USER_NAME FROM EMSDBA.JOB_NOTES WHERE loc_work_order_loc = :loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no ORDER BY x_datetime_insert  DESC

==========[ 08/10/2026 16:12:17 ]==========

SQL LEAK DETECTION (Idle) Registered: True - Time idle: 55 seconds - asset_type=ASSET

SELECT asset_type,is_linear,legacy_type,subcategory,ROW_ID FROM EMSDBA.ASSET_TYPE WHERE  (asset_type=:asset_type)