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

File: C:\AssetWorks\FASuite\main-ora\Logs\202608\20260819\WebModules\ORAMAIN\sqlcalls_BA.log

==========[ 08/19/2026 10:28:35 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.283 sec - A - Rows: 5904  - Connection ID: 7dfa4f86-cae2-4f30-928d-3a559193fbae

==========[ 08/19/2026 10:28:35 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 0163abf4-7f6e-4d55-8831-f4cceafdcd7f

==========[ 08/19/2026 10:28:35 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 570a9b03-9975-450e-9bb7-d930a4487850

==========[ 08/19/2026 10:28:36 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:28:06:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 838fc87a-85db-42dd-9ff6-97361c216c29

==========[ 08/19/2026 10:28:36 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 22dc9f60-f0b3-45bc-936d-91f36beced40

==========[ 08/19/2026 10:28:54 ]==========
```
module_id=46
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.002 sec - V - Rows: 1  - Connection ID: a8c79f8c-d594-42bf-b885-24f6a33a8c01

==========[ 08/19/2026 10:28:54 ]==========
```
module_id=46
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.002 sec - V - Rows: 1  - Connection ID: d03dfdf3-5b00-4d72-bb47-935d8c83fb98

==========[ 08/19/2026 10:28:54 ]==========
```
screen_screen_id=7278
```

SELECT row_no,screen_screen_id FROM EMSDBA.UI_SCREEN WHERE screen_screen_id = :screen_screen_id

Duration: 0.002 sec - A - Rows: 1  - Connection ID: e7f0aba5-f2a5-43c0-ae0d-7f5f40aaac8c

==========[ 08/19/2026 10:28:54 ]==========

Duration: 0.019 sec - V - Rows: 1  - Connection ID: e4ae3d44-5ab8-4195-9827-bc48779dc0a9

==========[ 08/19/2026 10:28:54 ]==========
```
emp_empl_no=BA-EMP
```

SELECT * FROM EMSDBA.EMP_MAIN WHERE emp_empl_no = :emp_empl_no

Duration: 0.015 sec - A - Rows: 0  - Connection ID: bb2e03e7-a03c-41a8-aa5a-b382b169e9b5

==========[ 08/19/2026 10:28:54 ]==========

SELECT period_id,ROW_ID FROM EMSDBA.ACCT_PERIODS

Duration: 0.070 sec - A - Rows: 30  - Connection ID: 8fa5bd0e-b5a6-460b-9a72-5cc2e0a51ef7

==========[ 08/19/2026 10:28:54 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.016 sec - A - Rows: 1  - Connection ID: 7b6934db-f60c-4b0f-8647-8825e1f56695

==========[ 08/19/2026 10:28:54 ]==========
```
SELECT * FROM EMSDBA.PORTAL_ID
```

Duration: 0.090 sec - A - Rows: 59  - Connection ID: 57cdba3b-3b73-4cf6-aa15-d6e5e9f76028

==========[ 08/19/2026 10:28:54 ]==========
```
value_key=Gadgets
```
```
value_1=ALL
```
```
section=AC:Billing:Layout
```

SELECT * FROM EMSDBA.USR_PROFILE WHERE  (value_key=:value_key)  AND (value_1=:value_1)  AND (section=:section)  ORDER BY value_1 ASC

Duration: 0.022 sec - A - Rows: 7  - Connection ID: c4adc393-3a76-48cb-9932-c2109d073499

==========[ 08/19/2026 10:28:54 ]==========
```
value_key=Gadgets
```
```
value_1=105:884:ALL
```
```
usr_userid=All Portal Users
```
```
section=AC:Billing:Layout
```

SELECT * FROM EMSDBA.USR_PROFILE WHERE usr_userid = :usr_userid AND section = :section AND (value_key=:value_key)  AND (value_1=:value_1)

Duration: 0.007 sec - V - Rows: 0  - Connection ID: 77a2f986-9279-4801-8f05-1ea2fe8c638f

==========[ 08/19/2026 10:28:54 ]==========
```
value_key=Gadgets
```
```
value_1=105:884:ALL
```
```
usr_userid=BA
```
```
section=AC:Billing:Layout
```

SELECT * FROM EMSDBA.USR_PROFILE WHERE usr_userid = :usr_userid AND section = :section AND (value_key=:value_key)  AND (value_1=:value_1)

Duration: 0.003 sec - V - Rows: 0  - Connection ID: e59b7db4-9dca-4d92-9b5f-9c631964d496

==========[ 08/19/2026 10:28:56 ]==========
```
screen_screen_id=7291
```

SELECT row_no,screen_screen_id FROM EMSDBA.UI_SCREEN WHERE screen_screen_id = :screen_screen_id

Duration: 0.001 sec - A - Rows: 1  - Connection ID: d8b66f9c-08cf-463b-9fb8-0a3ef2df5c3a

==========[ 08/19/2026 10:28:58 ]==========
```
screen_screen_id=7334
```

SELECT row_no,screen_screen_id FROM EMSDBA.UI_SCREEN WHERE screen_screen_id = :screen_screen_id

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 03e122d2-f091-4a48-8c9f-dd54e31f7c3c

==========[ 08/19/2026 10:28:58 ]==========
```
value_key=RefreshInterval
```
```
value_1=Default
```
```
usr_userid=BA
```
```
section=SA:Gadget:Billing:Prefs
```

SELECT * FROM EMSDBA.USR_PROFILE WHERE usr_userid = :usr_userid AND section = :section AND (value_key=:value_key)  AND (value_1=:value_1)

Duration: 0.002 sec - V - Rows: 0  - Connection ID: 5ac1d06c-6c36-4463-9ddc-0bceb5dc5804

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.003 sec - A - Rows: 0  - Connection ID: 73bd0461-2624-4708-b577-66b76ae61667

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.005 sec - V - Rows: 1  - Connection ID: 67780db8-6129-42c1-b38f-06021521098b

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.003 sec - V - Rows: 1  - Connection ID: ac8086f0-58f8-4a3d-9d4e-d0a39d80908f

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.007 sec - V - Rows: 1  - Connection ID: 2f429edf-2510-41cc-9434-02affc6b80a8

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.005 sec - V - Rows: 1  - Connection ID: 7bcc77bc-637d-48c5-9b83-88692356711c

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.005 sec - V - Rows: 1  - Connection ID: 104e0049-6bdb-487e-ba7a-3956321df182

==========[ 08/19/2026 10:28:58 ]==========
```
usr_userid_to=BA
```

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 78962aac-fddb-4ff4-9ccf-8bc561f01740

==========[ 08/19/2026 10:28:58 ]==========

Duration: 0.003 sec - V - Rows: 1  - Connection ID: 7c86e68a-dff3-4eb5-b66f-7fe875b89bb1

==========[ 08/19/2026 10:28:59 ]==========

Duration: 0.026 sec - V - Rows: 1  - Connection ID: 467c0139-bf79-460c-a63a-bf657f2b5fc5

==========[ 08/19/2026 10:28:59 ]==========

Duration: 0.021 sec - V - Rows: 1  - Connection ID: d39e7083-3b20-43d6-bef6-98af96d39b16

==========[ 08/19/2026 10:28:59 ]==========

Duration: 0.016 sec - V - Rows: 1  - Connection ID: 8f23f5e0-c64e-4594-8272-a1dda12bed2e

==========[ 08/19/2026 10:28:59 ]==========

Duration: 0.008 sec - V - Rows: 1  - Connection ID: dad86945-f0d4-4513-a43f-440b9eab07dd

==========[ 08/19/2026 10:28:59 ]==========

Duration: 0.011 sec - V - Rows: 1  - Connection ID: f319b6f1-4e6e-4f04-8a2b-0bd7679ece13

==========[ 08/19/2026 10:28:59 ]==========

SELECT * FROM EMSDBA.USR_PROFILE WHERE  (usr_userid = 'BA')  AND (section = 'NOTIF:NotificationSettings')

Duration: 0.010 sec - A - Rows: 1  - Connection ID: e7bce3c1-75e3-4ca5-9072-7894eb4650fb

==========[ 08/19/2026 10:28:59 ]==========

SELECT period_id,end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (status = 'OPEN')

Duration: 0.005 sec - A - Rows: 1  - Connection ID: 000c6022-7535-4a30-af15-6035a0b6a737

==========[ 08/19/2026 10:28:59 ]==========

SELECT period_id,end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (status = 'OPEN')

Duration: 0.001 sec - A - Rows: 1  - Connection ID: f54cb60c-2000-4c58-bc6e-776e35b3b6ef

==========[ 08/19/2026 10:28:59 ]==========
```
currentEndDate=10/31/2017 12:00:01 AM
```

SELECT period_id,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = ((SELECT MIN(end_date) FROM ACCT_PERIODS WHERE (status = 'PENDING') AND (end_date > :currentEndDate))))

Duration: 0.096 sec - A - Rows: 1  - Connection ID: affeb649-9962-47d1-85a7-80652722a22c

==========[ 08/19/2026 10:28:59 ]==========
```
currentEndDate=10/31/2017 12:00:01 AM
```

SELECT period_id,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = ((SELECT MIN(end_date) FROM ACCT_PERIODS WHERE (status = 'PENDING') AND (end_date > :currentEndDate))))

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 0ec8a8b0-b2a8-4dbd-ac40-fb3cd066b31b

==========[ 08/19/2026 10:28:59 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 102dcce4-f934-4d6a-8a22-4550858ad461

==========[ 08/19/2026 10:28:59 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING CLOSE'

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 5ac4d6d6-1c91-4f3c-b7eb-1ea54689f170

==========[ 08/19/2026 10:29:00 ]==========

SELECT period_id,description,end_date,status,locked,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (status = 'OPEN')  OR (status = 'PENDING')  OR (status = 'PENDING CLOSE')  AND (status IS NOT NULL)  ORDER BY end_date  ASC

Duration: 0.006 sec - A - Rows: 17  - Connection ID: 24a445e6-a3ea-488e-b953-f59452925478

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.004 sec - A - Rows: 0  - Connection ID: 6560a689-e54a-4cd6-ba59-9a77ed135530

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.005 sec - A - Rows: 1  - Connection ID: ca510b9c-4555-481c-8814-0bac7003b94c

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=6/30/2015 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.005 sec - A - Rows: 1  - Connection ID: 60bcac4a-3974-4dcb-b331-0d4f19430753

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 731d6e2f-93f9-4bd7-99b9-fe44b1d87b09

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 05219fa3-5d51-4f42-bcb9-7f2ca7f4b1c0

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=9/30/2015 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.001 sec - A - Rows: 1  - Connection ID: c2dbfd0d-6514-4350-95af-2153c5c4dc0b

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 1293605c-2556-4778-a217-e281da0da053

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 013573ad-49eb-46af-ab90-315f040cb1f5

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=12/31/2016 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 113e9899-a4df-4c4d-b37f-594528dab083

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: e1546ef2-ced4-4749-aeb9-86f087127483

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 1fe0e994-f33c-493b-b89a-6da63b813f33

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=1/31/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 3977c43c-fe70-4d8e-9311-183ad339de04

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 54996e6d-e18c-43a4-a733-3234be856cfd

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 809d7d22-0ab9-46a2-a9e2-eed9842fc62b

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=2/28/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 50e393c7-0ea6-4239-94b8-e878cc7f9a4e

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.008 sec - A - Rows: 0  - Connection ID: ef9eb921-9032-4d83-a5fc-940a65003cae

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.004 sec - A - Rows: 1  - Connection ID: 65e469dc-5578-4b58-a4d8-975e8b14d359

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=3/31/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.004 sec - A - Rows: 1  - Connection ID: f6c80737-627c-4022-9d0f-73bd987b1979

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 48eaf392-2dfb-4010-821e-c19bb16ffa3d

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 436537ce-14f4-4347-b106-be7fb46d2c39

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=4/30/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 03220e71-34c6-4c0e-9a76-93832b57cf7f

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.002 sec - A - Rows: 0  - Connection ID: da4c2a80-24cc-4307-a2f0-aa8d8fd8546f

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 07419fab-02ca-467b-b219-c5208aaf0cd5

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=6/30/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 16e2144d-fbcf-41a5-802a-0ef0e6aae2cf

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.003 sec - A - Rows: 0  - Connection ID: 1c061641-08e9-4bdc-a4d4-e6ebc5640d03

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 2b9135ef-7f0a-42c5-8cb9-599c211d67ae

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=7/31/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.003 sec - A - Rows: 1  - Connection ID: b87c44a7-aab9-4148-b26b-58bf916f8773

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.003 sec - A - Rows: 0  - Connection ID: 0886126b-6136-4ba1-9e4c-b89223a4bb73

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 3098a20d-4a74-477e-9352-ed8393b15056

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=8/31/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.002 sec - A - Rows: 1  - Connection ID: d583141a-fd85-41bf-b7b8-20159dd5735b

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.004 sec - A - Rows: 0  - Connection ID: 1ce29303-3d3b-4736-8f10-acabde3a83f4

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 1a13418d-f918-4267-88cd-a6762c9156e8

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=10/31/2017 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.004 sec - A - Rows: 1  - Connection ID: b12b4a3c-5060-48e3-a1f9-84d8779750c8

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.003 sec - A - Rows: 0  - Connection ID: 6b731303-13e4-4cac-a7e7-a2bc4c4affe6

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.008 sec - A - Rows: 1  - Connection ID: 44745271-1ad9-4ac2-afc5-297e447e693e

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=4/30/2018 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 3e71ed83-eb3e-473c-a846-086b518adb2b

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.005 sec - A - Rows: 0  - Connection ID: 9303e516-369e-4ce5-9ead-33123ec04ae5

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 23d2f7b4-18bc-404f-ab0b-9b819d5c92d3

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=5/31/2018 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.002 sec - A - Rows: 1  - Connection ID: b5dc0963-40c8-4bac-b237-913122b06e20

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.005 sec - A - Rows: 0  - Connection ID: 638dd60c-f197-4d37-af11-2893678c007e

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 28c07ffb-b64d-496a-a5d4-466f9bd974b4

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=6/30/2018 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 1fd712d6-8116-4b93-bda2-599cbbec4fba

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 20e47c16-ed44-457c-b043-2ecd131183b7

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: cbbcdcca-91a0-4d67-97ec-dfce7f34ce02

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=6/30/2020 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 8b68b5de-240f-4a98-97e1-2f1bff1d39e9

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.003 sec - A - Rows: 0  - Connection ID: cc48015d-14d5-4406-b9d9-8d2913604031

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 9559c99a-d500-4469-acee-34a48b7fe8cc

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=8/28/2020 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.002 sec - A - Rows: 1  - Connection ID: d9c55a35-deb4-41c7-9573-03d7b96f9240

==========[ 08/19/2026 10:29:00 ]==========
```
usr_userid=
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.004 sec - A - Rows: 0  - Connection ID: 0f7c0304-4c09-4e0d-9cbf-c89321140fd0

==========[ 08/19/2026 10:29:00 ]==========

Select COUNT(row_id) AS ttlCount  FROM ACCT_PERIODS WHERE status = 'PENDING'

Duration: 0.003 sec - A - Rows: 1  - Connection ID: afe5074a-5ea5-49f9-9200-366b08210db3

==========[ 08/19/2026 10:29:00 ]==========
```
endDate=8/31/2023 12:00:01 AM
```

SELECT end_date,ROW_ID FROM EMSDBA.ACCT_PERIODS WHERE  (end_date = (SELECT MAX(end_date) FROM ACCT_PERIODS WHERE end_date < :endDate) )

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 1c4a024b-d25a-46ed-83f1-bb4a150403b6

==========[ 08/19/2026 10:29:10 ]==========
```
usr_userid=BA
```

SELECT ugr_user_group,is_sys_admin,description,row_id FROM EMSDBA.UGR_MAIN WHERE  (ugr_user_group in (select ugr_user_group from USR_GROUPS where usr_userid = :usr_userid))

Duration: 0.003 sec - V - Rows: 2  - Connection ID: fbae5336-dc77-40f0-bec3-28d864a57bc5

==========[ 08/19/2026 10:29:11 ]==========
```
usr_userid=BA
```

SELECT nonce_token_ttl,nonce_token,ROW_ID FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.003 sec - V - Rows: 1  - Connection ID: 4d6322bc-09e4-4073-aad2-02625e844e21

==========[ 08/19/2026 10:29:11 ]==========
```
usr_userid=BA
```

SELECT nonce_token,ROW_ID FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.002 sec - V - Rows: 1  - Connection ID: b8ad3b22-26fc-42c6-a5dd-02b2c253f773

==========[ 08/19/2026 10:29:11 ]==========
```
usr_userid=BA
```

client_id=872737FC-843C-4157-813A-8220CDD80061

```
client_type=UNK
```

SELECT usr_userid,ROW_ID FROM EMSDBA.USR_LOGINLOG WHERE  (usr_userid = :usr_userid)  AND (client_id = :client_id)  AND (client_type = :client_type)  AND (datetime_logout IS NULL )

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 4abd963b-0ebc-46a1-9096-b659206a72f7

==========[ 08/19/2026 10:29:11 ]==========
```
:DATETIME_LOGIN=8/19/2026 10:29:11 AM
```
```
:WORKSTATION_IP=10.10.103.10
```
```
:WEB_SERVER_IP=10.8.1.25
```
```
:PRODUCT=EAMWEB
```

:WEB_SESSION_ID=3sphmt0z4244y0hthqshwnpe

```
:WORKSTATION_BROWSER=CHROME
```
```
:WORKSTATION_BROWSER_VERSION=151.0
```
```
:ROW_ID=487500044
```

UPDATE EMSDBA.USR_LOGINLOG SET datetime_login=:DATETIME_LOGIN,workstation_ip=:WORKSTATION_IP,web_server_ip=:WEB_SERVER_IP,product=:PRODUCT,web_session_id=:WEB_SESSION_ID,workstation_browser=:WORKSTATION_BROWSER,workstation_browser_version=:WORKSTATION_BROWSER_VERSION WHERE ROW_ID = :ROW_ID

Duration: 0.003 sec - A - Rows: 1  - Connection ID: bbcfa0fe-c0d7-4c17-8c4f-b3c7ca913d8f

==========[ 08/19/2026 10:29:11 ]==========
```
count_id=20
```

SELECT * FROM EMSDBA.SYS_COUNT WHERE  (count_id=:count_id)

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 2a297ba2-270a-498d-88ed-be11489dd694

==========[ 08/19/2026 10:29:11 ]==========
```
grp_name=Admins
```
```
section=InfoCenterPrefs
```
```
value_key=UserGroupPrefs
```

SELECT * FROM EMSDBA.UGR_PREFERENCES WHERE  (grp_name=:grp_name)  AND (section=:section)  AND (value_key=:value_key)

Duration: 0.002 sec - V - Rows: 0  - Connection ID: 3297ed54-2e86-4807-bc8c-638d0da0b246

==========[ 08/19/2026 10:29:11 ]==========
```
grp_name=SYS ADMIN - PRODUCT MANAGMENT
```
```
section=InfoCenterPrefs
```
```
value_key=UserGroupPrefs
```

SELECT * FROM EMSDBA.UGR_PREFERENCES WHERE  (grp_name=:grp_name)  AND (section=:section)  AND (value_key=:value_key)

Duration: 0.001 sec - V - Rows: 0  - Connection ID: 8b1984d0-0eaf-43f2-a309-289441530762

==========[ 08/19/2026 10:29:11 ]==========
```
grp_name=SYSADMIN
```
```
section=InfoCenterPrefs
```
```
value_key=UserGroupPrefs
```

SELECT * FROM EMSDBA.UGR_PREFERENCES WHERE  (grp_name=:grp_name)  AND (section=:section)  AND (value_key=:value_key)

Duration: 0.002 sec - V - Rows: 0  - Connection ID: a363b05a-eb9a-41ea-a0fc-4fa423ca4438

==========[ 08/19/2026 10:29:11 ]==========
```
section=AdHocQuery
```
```
usr_userid=QueryAdmin
```

SELECT value_2,ROW_ID FROM EMSDBA.USR_PROFILE WHERE usr_userid = :usr_userid AND (section=:section)

Duration: 0.003 sec - A - Rows: 1  - Connection ID: 97c7d026-78c3-4963-9717-009e7e4651ae

==========[ 08/19/2026 10:29:11 ]==========

SELECT pwd_days_expire,ROW_ID FROM EMSDBA.SYS_MAIN

Duration: 0.001 sec - V - Rows: 1  - Connection ID: a5b30235-2f1b-4512-985a-d9d6590b8d47

==========[ 08/19/2026 10:29:11 ]==========
```
usr_userid=BA
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 49218e02-bc4d-40f4-9347-185f5ca2eac3

==========[ 08/19/2026 10:29:11 ]==========

Duration: 0.004 sec - A - Rows: 0  - Connection ID: 0cebde3b-acf6-42a0-a53b-ced0511a5a6d

==========[ 08/19/2026 10:29:11 ]==========

Duration: 0.003 sec - V - Rows: 1  - Connection ID: f7505600-4100-4bf1-81df-43b2cb25d0f9

==========[ 08/19/2026 10:29:11 ]==========

Duration: 0.003 sec - A - Rows: 0  - Connection ID: 6ec9aaad-3d4e-4d4e-9b09-f1dd9b624064

==========[ 08/19/2026 10:29:11 ]==========

Duration: 0.003 sec - V - Rows: 1  - Connection ID: d8757437-4c5b-413e-b427-9dd3383e83d0

==========[ 08/19/2026 10:29:12 ]==========
```
module_id=20
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.001 sec - V - Rows: 1  - Connection ID: 7f81256a-b791-4bc8-8a37-f79d664bf87b

==========[ 08/19/2026 10:29:12 ]==========
```
module_id=20
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.002 sec - V - Rows: 1  - Connection ID: e3a385ee-0cf5-4a08-9648-d25c85add36b

==========[ 08/19/2026 10:29:12 ]==========
```
module_id=20
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.001 sec - V - Rows: 1  - Connection ID: 79b7e42c-a74a-40e0-968b-1b24d1515cf0

==========[ 08/19/2026 10:29:12 ]==========
```
module_id=20
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.001 sec - V - Rows: 1  - Connection ID: a8a57e5b-7c60-422c-b691-99892b9bb12f

==========[ 08/19/2026 10:29:12 ]==========
```
module_id=20
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.001 sec - V - Rows: 1  - Connection ID: 1cf14cc9-f5ae-43ff-becb-08ea782617c0

==========[ 08/19/2026 10:29:12 ]==========
```
module_id=20
```

SELECT last_conversion,ROW_ID FROM EMSDBA.IC_APP_CONFIG WHERE  (module_id=:module_id)  AND (LAST_CONVERSION=(SELECT MAX(LAST_CONVERSION) FROM IC_APP_CONFIG WHERE MODULE_ID=:module_id))

Duration: 0.001 sec - V - Rows: 1  - Connection ID: 317b3489-28e8-42b6-8b42-b1b5bf815f6b

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.003 sec - A - Rows: 0  - Connection ID: bbfbf974-ca5a-4b73-b4f9-8a18748021f5

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 95307324-5e8a-43bc-a8be-634128e456c1

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 399486e8-385e-47d5-ab65-c2184fea774c

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 703ed0d1-5f76-4494-9005-24960c17d24e

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 945e7509-d45b-41ba-a168-9e0170c35a7c

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: fd3c8319-a65f-4bbc-b554-cc6bb02b1cf6

==========[ 08/19/2026 10:29:12 ]==========
```
usr_userid_to=BA
```

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.001 sec - A - Rows: 0  - Connection ID: c51b31a9-e0a6-47e8-b9a5-2864a59245c8

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: bc91e876-1d3b-408f-b17e-a4297d833350

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 06ce9787-dd7c-43a6-8763-17eecb883cf6

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: a180f4db-e399-4fe9-9017-0a0565a68b8b

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 6ccab297-5af9-4fe5-8b88-94df8d0463ca

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.002 sec - V - Rows: 1  - Connection ID: 543cd250-a413-4fe1-9cff-f85105ddb6f2

==========[ 08/19/2026 10:29:12 ]==========

Duration: 0.007 sec - V - Rows: 1  - Connection ID: 106aa6d6-fe8b-4362-8766-a69da3817e7f

==========[ 08/19/2026 10:29:12 ]==========
```
portal_id=105
```
```
moduleid=3
```

SELECT * FROM EMSDBA.PORTAL_LINKS WHERE  (portal_id=:portal_id)  AND (moduleid=:moduleid)  ORDER BY vieworder ASC

Duration: 0.002 sec - A - Rows: 6  - Connection ID: 5162543a-1d10-4632-ade0-8475c6c40472

==========[ 08/19/2026 10:29:12 ]==========
```
portal_id=105
```
```
moduleid=931
```

SELECT * FROM EMSDBA.PORTAL_HTMLTEXT WHERE  (portal_id=:portal_id)  AND (moduleid=:moduleid)

Duration: 0.003 sec - A - Rows: 1  - Connection ID: a350eb15-d1ed-4822-807a-1c7a27f1ac8e

==========[ 08/19/2026 10:29:12 ]==========
```
portal_id=105
```
```
moduleid=932
```

SELECT * FROM EMSDBA.PORTAL_HTMLTEXT WHERE  (portal_id=:portal_id)  AND (moduleid=:moduleid)

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 44182c2c-883d-457e-9bac-acfd9b48f4f1

==========[ 08/19/2026 10:29:18 ]==========
```
usr_userid_to=BA
```

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 2c2c0800-7fe4-4181-940d-e2ac75f0bfff

==========[ 08/19/2026 10:29:18 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: dcac09eb-c8ea-49b8-96c7-73926833739e

==========[ 08/19/2026 10:29:18 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.240 sec - A - Rows: 5904  - Connection ID: 671308ca-9f12-48db-9e13-3138106f2520

==========[ 08/19/2026 10:29:18 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 999508c6-ebe9-4189-a81b-ca20412e671d

==========[ 08/19/2026 10:29:18 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 2e07f3a2-5d12-4ce2-9938-0e68cb3ca541

==========[ 08/19/2026 10:29:48 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:29:18:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 8d828300-9c6b-4d00-80cf-36ab07418b49

==========[ 08/19/2026 10:29:48 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.001 sec - A - Rows: 0  - Connection ID: bcd91754-c133-4491-9350-9146c73c21cb

==========[ 08/19/2026 10:30:18 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:29:48:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.001 sec - A - Rows: 0  - Connection ID: a4ce0bbb-1867-4ad1-bab2-c4cf7dfdf5ae

==========[ 08/19/2026 10:30:18 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 3186ceec-7d79-4459-99f7-1c0d2733958c

==========[ 08/19/2026 10:30:29 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.002 sec - A - Rows: 1  - Connection ID: d81704a1-1fcb-413c-a6f1-49b64e1dde4d

==========[ 08/19/2026 10:30:29 ]==========
```
ROW_ID=3
```

DELETE FROM EMSDBA.USR_LOGGING WHERE ROW_ID = :ROW_ID

Duration: 0.004 sec - A - Rows: 1  - Connection ID: ed1c92b7-f1ce-4cd9-8bc7-99a7f9ad00e2

==========[ 08/19/2026 10:32:13 ]==========
```
usr_userid=BA
```

SELECT * FROM EMSDBA.USR_MAIN WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 4cbf9926-f0b7-48bb-baaa-caec9947a10d

==========[ 08/19/2026 10:32:13 ]==========
```
emp_empl_no=BA-EMP
```

SELECT * FROM EMSDBA.EMP_MAIN WHERE emp_empl_no = :emp_empl_no

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 081fdd1f-976c-444d-9fb4-89e539cbc383

==========[ 08/19/2026 10:32:13 ]==========
```
Status_OPEN=OPEN
```
```
Status_PENDING=PENDING
```
```
Status_WORK_FINISHED=WORK FINISHED
```
```
estimate=N
```
```
emp_empl_no=BA-EMP
```

                    SELECT row_id, loc_work_order_loc, work_order_yr, work_order_no, loc_responsible_loc,

	                    title, 	pri_priority_code, job_type, parent_wo_id,

	                    work_order_status, delay_status, datetime_open, warranty, datetime_pm_sched,

	                    eq_equip_no, equip_status_code, is_linear_order,

	                    part_rebuild_part_no, rebuild_part_suffix, rebuild_qty, mrprun_run_id,

	                    exp_technicn_vendor

```
                    FROM JOB_MAIN
```

                    WHERE (work_order_status=:Status_OPEN OR work_order_status=:Status_PENDING OR work_order_status=:Status_WORK_FINISHED)

	                    AND ESTIMATE=:estimate

             AND job_main.exp_technicn_vendor=:emp_empl_no

Duration: 0.011 sec - A - Rows: 0  - Connection ID: e0b2a206-533d-4759-8056-a429ce04cae7

==========[ 08/19/2026 10:32:13 ]==========
```
emp_empl_no=BA-EMP
```

                SELECT DISTINCT loc_work_order_loc,

```
	                work_order_yr,
```
```
	                work_order_no,
```
```
	                row_type,
```
```
	                TASK_task_code
```

                FROM TSK_ASSIGN LEFT JOIN TSK_ASSIGN_EMP ON TSK_ASSIGN.TSK_assign_id = TSK_ASSIGN_EMP.tsk_assign_id

                WHERE TSK_ASSIGN.work_order_no != 0

	                AND TSK_ASSIGN_EMP.EMP_empl_no = :emp_empl_no

```
            
```

Duration: 0.012 sec - A - Rows: 9  - Connection ID: 041947be-9f8c-4857-98b4-e353112f42cd

==========[ 08/19/2026 10:32:13 ]==========
```
Status_OPEN=OPEN
```
```
Status_PENDING=PENDING
```
```
Status_WORK_FINISHED=WORK FINISHED
```
```
estimate=N
```
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=5
```

                    SELECT row_id, loc_work_order_loc, work_order_yr, work_order_no, loc_responsible_loc,

	                    title, 	pri_priority_code, job_type, parent_wo_id,

	                    work_order_status, delay_status, datetime_open, warranty, datetime_pm_sched,

	                    eq_equip_no, equip_status_code, is_linear_order,

	                    part_rebuild_part_no, rebuild_part_suffix, rebuild_qty, mrprun_run_id,

	                    exp_technicn_vendor

```
                    FROM JOB_MAIN
```

                    WHERE (work_order_status=:Status_OPEN OR work_order_status=:Status_PENDING OR work_order_status=:Status_WORK_FINISHED)

	                    AND ESTIMATE=:estimate

             AND LOC_work_order_loc=:loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.012 sec - A - Rows: 1  - Connection ID: 560abe14-d909-4656-96f9-6ded521df9ea

==========[ 08/19/2026 10:32:13 ]==========
```
Status_OPEN=OPEN
```
```
Status_PENDING=PENDING
```
```
Status_WORK_FINISHED=WORK FINISHED
```
```
estimate=N
```
```
loc_work_order_loc=WBLOC1
```
```
work_order_yr=2025
```
```
work_order_no=7
```

                    SELECT row_id, loc_work_order_loc, work_order_yr, work_order_no, loc_responsible_loc,

	                    title, 	pri_priority_code, job_type, parent_wo_id,

	                    work_order_status, delay_status, datetime_open, warranty, datetime_pm_sched,

	                    eq_equip_no, equip_status_code, is_linear_order,

	                    part_rebuild_part_no, rebuild_part_suffix, rebuild_qty, mrprun_run_id,

	                    exp_technicn_vendor

```
                    FROM JOB_MAIN
```

                    WHERE (work_order_status=:Status_OPEN OR work_order_status=:Status_PENDING OR work_order_status=:Status_WORK_FINISHED)

	                    AND ESTIMATE=:estimate

             AND LOC_work_order_loc=:loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.003 sec - A - Rows: 1  - Connection ID: b55257ea-d815-4984-88c4-8e420475d309

==========[ 08/19/2026 10:32:13 ]==========
```
Status_OPEN=OPEN
```
```
Status_PENDING=PENDING
```
```
Status_WORK_FINISHED=WORK FINISHED
```
```
estimate=N
```
```
loc_work_order_loc=WBLOC1
```
```
work_order_yr=2025
```
```
work_order_no=6
```

                    SELECT row_id, loc_work_order_loc, work_order_yr, work_order_no, loc_responsible_loc,

	                    title, 	pri_priority_code, job_type, parent_wo_id,

	                    work_order_status, delay_status, datetime_open, warranty, datetime_pm_sched,

	                    eq_equip_no, equip_status_code, is_linear_order,

	                    part_rebuild_part_no, rebuild_part_suffix, rebuild_qty, mrprun_run_id,

	                    exp_technicn_vendor

```
                    FROM JOB_MAIN
```

                    WHERE (work_order_status=:Status_OPEN OR work_order_status=:Status_PENDING OR work_order_status=:Status_WORK_FINISHED)

	                    AND ESTIMATE=:estimate

             AND LOC_work_order_loc=:loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.007 sec - A - Rows: 1  - Connection ID: 33743dd1-f82b-4087-89d6-7ede898fffd4

==========[ 08/19/2026 10:32:13 ]==========
```
Status_OPEN=OPEN
```
```
Status_PENDING=PENDING
```
```
Status_WORK_FINISHED=WORK FINISHED
```
```
estimate=N
```
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=1
```

                    SELECT row_id, loc_work_order_loc, work_order_yr, work_order_no, loc_responsible_loc,

	                    title, 	pri_priority_code, job_type, parent_wo_id,

	                    work_order_status, delay_status, datetime_open, warranty, datetime_pm_sched,

	                    eq_equip_no, equip_status_code, is_linear_order,

	                    part_rebuild_part_no, rebuild_part_suffix, rebuild_qty, mrprun_run_id,

	                    exp_technicn_vendor

```
                    FROM JOB_MAIN
```

                    WHERE (work_order_status=:Status_OPEN OR work_order_status=:Status_PENDING OR work_order_status=:Status_WORK_FINISHED)

	                    AND ESTIMATE=:estimate

             AND LOC_work_order_loc=:loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.001 sec - A - Rows: 1  - Connection ID: 42f09336-d9b7-4790-82fb-96929cecf8ae

==========[ 08/19/2026 10:32:13 ]==========
```
emp_empl_no=BA-EMP
```

                SELECT DISTINCT TSK_ASSIGN.tsk_assign_id,

```
	                loc_work_order_loc,
```
```
	                work_order_yr,
```
```
	                work_order_no,
```
```
	                row_type,
```
```
	                TASK_task_code
```

                FROM TSK_ASSIGN LEFT JOIN TSK_ASSIGN_EMP ON TSK_ASSIGN.TSK_assign_id = TSK_ASSIGN_EMP.tsk_assign_id

                WHERE TSK_ASSIGN.work_order_no != 0

	                AND (TSK_ASSIGN.tsk_assign_id IN

			                (SELECT TSK_ASSIGN_EMP.tsk_assign_id

```
				                FROM TSK_ASSIGN_EMP
```

				                WHERE TSK_ASSIGN_EMP.crw_crew_code IN

					                (SELECT CRW_EMP.crw_crew_code

```
						                FROM CRW_EMP
```

						                WHERE CRW_EMP.emp_empl_no = :emp_empl_no)

				                OR TSK_ASSIGN_EMP.crw_crew_code IN

					                (SELECT CRW_MAIN.crw_crew_code

```
						                FROM CRW_MAIN
```

						                WHERE CRW_MAIN.emp_foreman_empl_no = :emp_empl_no)))

```
            
```

Duration: 0.069 sec - A - Rows: 0  - Connection ID: 00be80c1-4fbf-4e59-83e5-8404b5e31e0f

==========[ 08/19/2026 10:32:13 ]==========
```
begin_date=8/18/2026 12:00:00 AM
```
```
end_date=8/20/2026 12:00:00 AM
```
```
cal_calendar_id=10/4 FSS
```

SELECT start_datetime,end_datetime,ROW_ID FROM EMSDBA.CAL_WORK_DAYS WHERE cal_calendar_id = :cal_calendar_id AND (start_datetime >= :begin_date and start_datetime < :end_date)  ORDER BY start_datetime ASC

Duration: 0.008 sec - A - Rows: 2  - Connection ID: 7b23febc-b584-4ef1-b92c-46c0667135af

==========[ 08/19/2026 10:32:13 ]==========
```
emp_empl_no=BA-EMP
```
```
dt_shift_start=8/19/2026 6:00:00 AM
```

SELECT DISTINCT loc_work_order_loc, work_order_yr, work_order_no FROM TSK_ASSIGN, TSK_ASSIGN_APPT WHERE TSK_ASSIGN.TSK_assign_id = TSK_ASSIGN_APPT.TSK_assign_id AND TSK_ASSIGN_APPT.EMP_empl_no = :emp_empl_no and (datetime_sched + (hours/24)) >= :dt_shift_start

Duration: 0.008 sec - A - Rows: 0  - Connection ID: 925dcf7e-c58c-46b2-933f-08957d3f93db

==========[ 08/19/2026 10:32:13 ]==========
```
Status_OPEN=OPEN
```
```
Status_PENDING=PENDING
```
```
Status_WORK_FINISHED=WORK FINISHED
```
```
estimate=N
```
```
emp_empl_no=BA-EMP
```

                    SELECT row_id, loc_work_order_loc, work_order_yr, work_order_no, loc_responsible_loc,

	                    title, 	pri_priority_code, job_type, parent_wo_id,

	                    work_order_status, delay_status, datetime_open, warranty, datetime_pm_sched,

	                    eq_equip_no, equip_status_code, is_linear_order,

	                    part_rebuild_part_no, rebuild_part_suffix, rebuild_qty, mrprun_run_id,

	                    exp_technicn_vendor

```
                    FROM JOB_MAIN
```

                    WHERE (work_order_status=:Status_OPEN OR work_order_status=:Status_PENDING OR work_order_status=:Status_WORK_FINISHED)

	                    AND ESTIMATE=:estimate

             AND EXISTS(SELECT LAB_MAIN.row_id FROM LAB_MAIN WHERE LAB_MAIN.LOC_WORK_ORDER_LOC = JOB_MAIN.LOC_WORK_ORDER_LOC AND LAB_MAIN.WORK_ORDER_YR = JOB_MAIN.WORK_ORDER_YR AND LAB_MAIN.WORK_ORDER_NO = JOB_MAIN.WORK_ORDER_NO AND LAB_MAIN.EMP_EMPL_NO = :emp_empl_no)

Duration: 0.037 sec - A - Rows: 2  - Connection ID: 3f85f783-f726-42cd-91b4-e7969e765704

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=5
```
```
status0=PENDING
```
```
status1=ORDERED
```
```
status2=RECEIVED
```
```
status3=CANCELED
```
```
status4=COMPLETED
```

SELECT row_id,notify_flag,request_id,ptsreq_line_id,line_item_type,loc_work_order_loc,work_order_yr,work_order_no,part_part_no,part_suffix,part_description,comment_area,request_qty,x_datetime_insert,emp_empl_no,datetime_acted,action_comment,required_date,status,pri_priority_code,vend_vendor_no,(  SELECT DATETIME_EXP_DELIVERY FROM EPO_LINE

                                                WHERE EPO_PO_ID = (SELECT EPO_PO_ID

                                                                   FROM EPO_WORKORD

                                                                   WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                                AND LINE_NO = (SELECT LINE_NO

                                                               FROM EPO_WORKORD

                                                               WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS POEXPDELIVERY,( SELECT DATETIME_EXP_DELIVERY FROM ERQ_LINE

                                               WHERE ERQ_REQ_ID = (SELECT ERQ_REQ_ID

                                                               FROM ERQ_WORKORD

                                                               WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                               AND LINE_NO = (SELECT LINE_NO

                                                           FROM ERQ_WORKORD

                                                           WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS REQEXPDELIVERY,   CASE

```
                        WHEN
```
```
                                ( 
```

			                    SELECT qty_on_hand

                                FROM plo_main p

                                WHERE p.loc_loc_code = pts_request.loc_from_loc

                                    AND p.part_part_no = pts_request.part_part_no

                                    AND p.part_suffix = pts_request.part_suffix) > 0 THEN

                                ( SELECT ( CASE WHEN

                                            ( SELECT BLOCK_ISSUE_COMMIT

                                            FROM loc_main

                                            WHERE loc_loc_code = pts_request.loc_from_loc ) = 'Y' THEN (CASE WHEN (

                                                                                                                        (SELECT qty_on_hand

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) -

                                                                                                                        (SELECT QTY_COMMITTED

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) + pts_request.QTY_COMMITTED - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) ELSE (CASE WHEN (

```
                    (SELECT qty_on_hand
```
```
                        FROM plo_main p
```

                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                        AND p.part_part_no = pts_request.part_part_no

                        AND p.part_suffix = pts_request.part_suffix) - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) END)

                                FROM pts_request a

                    WHERE a.row_id = pts_request.row_id)

```
                        ELSE 'N'
```

                    END AS AvailQty,(SELECT QTY_ON_HAND FROM PLO_MAIN WHERE PART_PART_NO = PTS_REQUEST.PART_PART_NO AND PART_SUFFIX = PTS_REQUEST.PART_SUFFIX AND LOC_LOC_CODE = PTS_REQUEST.LOC_FROM_LOC) as QtyOnHand,(SELECT MAX(DATE_RECEIVED)

                                                            FROM   ERCPT_MAIN

                                                            WHERE  EXISTS ( SELECT ROW_ID

                                                                            FROM   ERCPT_WORKORD

                                                                            WHERE  ERCPT_RECEIPT_ID = ERCPT_MAIN.ERCPT_RECEIPT_ID

                                                                            AND    PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) as DateReceived,(SELECT COUNT(*) FROM PTS_REQUEST_NOTES WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID) as NoteCount 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 (status = :status0 OR status = :status1 OR status = :status2 OR status = :status3 OR status = :status4)

Duration: 0.072 sec - A - Rows: 0  - Connection ID: 3431edb6-4149-43fe-8051-24c87224902b

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=WBLOC1
```
```
work_order_yr=2025
```
```
work_order_no=7
```
```
status0=PENDING
```
```
status1=ORDERED
```
```
status2=RECEIVED
```
```
status3=CANCELED
```
```
status4=COMPLETED
```

SELECT row_id,notify_flag,request_id,ptsreq_line_id,line_item_type,loc_work_order_loc,work_order_yr,work_order_no,part_part_no,part_suffix,part_description,comment_area,request_qty,x_datetime_insert,emp_empl_no,datetime_acted,action_comment,required_date,status,pri_priority_code,vend_vendor_no,(  SELECT DATETIME_EXP_DELIVERY FROM EPO_LINE

                                                WHERE EPO_PO_ID = (SELECT EPO_PO_ID

                                                                   FROM EPO_WORKORD

                                                                   WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                                AND LINE_NO = (SELECT LINE_NO

                                                               FROM EPO_WORKORD

                                                               WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS POEXPDELIVERY,( SELECT DATETIME_EXP_DELIVERY FROM ERQ_LINE

                                               WHERE ERQ_REQ_ID = (SELECT ERQ_REQ_ID

                                                               FROM ERQ_WORKORD

                                                               WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                               AND LINE_NO = (SELECT LINE_NO

                                                           FROM ERQ_WORKORD

                                                           WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS REQEXPDELIVERY,   CASE

```
                        WHEN
```
```
                                ( 
```

			                    SELECT qty_on_hand

                                FROM plo_main p

                                WHERE p.loc_loc_code = pts_request.loc_from_loc

                                    AND p.part_part_no = pts_request.part_part_no

                                    AND p.part_suffix = pts_request.part_suffix) > 0 THEN

                                ( SELECT ( CASE WHEN

                                            ( SELECT BLOCK_ISSUE_COMMIT

                                            FROM loc_main

                                            WHERE loc_loc_code = pts_request.loc_from_loc ) = 'Y' THEN (CASE WHEN (

                                                                                                                        (SELECT qty_on_hand

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) -

                                                                                                                        (SELECT QTY_COMMITTED

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) + pts_request.QTY_COMMITTED - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) ELSE (CASE WHEN (

```
                    (SELECT qty_on_hand
```
```
                        FROM plo_main p
```

                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                        AND p.part_part_no = pts_request.part_part_no

                        AND p.part_suffix = pts_request.part_suffix) - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) END)

                                FROM pts_request a

                    WHERE a.row_id = pts_request.row_id)

```
                        ELSE 'N'
```

                    END AS AvailQty,(SELECT QTY_ON_HAND FROM PLO_MAIN WHERE PART_PART_NO = PTS_REQUEST.PART_PART_NO AND PART_SUFFIX = PTS_REQUEST.PART_SUFFIX AND LOC_LOC_CODE = PTS_REQUEST.LOC_FROM_LOC) as QtyOnHand,(SELECT MAX(DATE_RECEIVED)

                                                            FROM   ERCPT_MAIN

                                                            WHERE  EXISTS ( SELECT ROW_ID

                                                                            FROM   ERCPT_WORKORD

                                                                            WHERE  ERCPT_RECEIPT_ID = ERCPT_MAIN.ERCPT_RECEIPT_ID

                                                                            AND    PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) as DateReceived,(SELECT COUNT(*) FROM PTS_REQUEST_NOTES WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID) as NoteCount 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 (status = :status0 OR status = :status1 OR status = :status2 OR status = :status3 OR status = :status4)

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 6bb51347-1ac3-4969-8746-d93390f9891d

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=WBLOC1
```
```
work_order_yr=2025
```
```
work_order_no=6
```
```
status0=PENDING
```
```
status1=ORDERED
```
```
status2=RECEIVED
```
```
status3=CANCELED
```
```
status4=COMPLETED
```

SELECT row_id,notify_flag,request_id,ptsreq_line_id,line_item_type,loc_work_order_loc,work_order_yr,work_order_no,part_part_no,part_suffix,part_description,comment_area,request_qty,x_datetime_insert,emp_empl_no,datetime_acted,action_comment,required_date,status,pri_priority_code,vend_vendor_no,(  SELECT DATETIME_EXP_DELIVERY FROM EPO_LINE

                                                WHERE EPO_PO_ID = (SELECT EPO_PO_ID

                                                                   FROM EPO_WORKORD

                                                                   WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                                AND LINE_NO = (SELECT LINE_NO

                                                               FROM EPO_WORKORD

                                                               WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS POEXPDELIVERY,( SELECT DATETIME_EXP_DELIVERY FROM ERQ_LINE

                                               WHERE ERQ_REQ_ID = (SELECT ERQ_REQ_ID

                                                               FROM ERQ_WORKORD

                                                               WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                               AND LINE_NO = (SELECT LINE_NO

                                                           FROM ERQ_WORKORD

                                                           WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS REQEXPDELIVERY,   CASE

```
                        WHEN
```
```
                                ( 
```

			                    SELECT qty_on_hand

                                FROM plo_main p

                                WHERE p.loc_loc_code = pts_request.loc_from_loc

                                    AND p.part_part_no = pts_request.part_part_no

                                    AND p.part_suffix = pts_request.part_suffix) > 0 THEN

                                ( SELECT ( CASE WHEN

                                            ( SELECT BLOCK_ISSUE_COMMIT

                                            FROM loc_main

                                            WHERE loc_loc_code = pts_request.loc_from_loc ) = 'Y' THEN (CASE WHEN (

                                                                                                                        (SELECT qty_on_hand

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) -

                                                                                                                        (SELECT QTY_COMMITTED

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) + pts_request.QTY_COMMITTED - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) ELSE (CASE WHEN (

```
                    (SELECT qty_on_hand
```
```
                        FROM plo_main p
```

                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                        AND p.part_part_no = pts_request.part_part_no

                        AND p.part_suffix = pts_request.part_suffix) - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) END)

                                FROM pts_request a

                    WHERE a.row_id = pts_request.row_id)

```
                        ELSE 'N'
```

                    END AS AvailQty,(SELECT QTY_ON_HAND FROM PLO_MAIN WHERE PART_PART_NO = PTS_REQUEST.PART_PART_NO AND PART_SUFFIX = PTS_REQUEST.PART_SUFFIX AND LOC_LOC_CODE = PTS_REQUEST.LOC_FROM_LOC) as QtyOnHand,(SELECT MAX(DATE_RECEIVED)

                                                            FROM   ERCPT_MAIN

                                                            WHERE  EXISTS ( SELECT ROW_ID

                                                                            FROM   ERCPT_WORKORD

                                                                            WHERE  ERCPT_RECEIPT_ID = ERCPT_MAIN.ERCPT_RECEIPT_ID

                                                                            AND    PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) as DateReceived,(SELECT COUNT(*) FROM PTS_REQUEST_NOTES WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID) as NoteCount 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 (status = :status0 OR status = :status1 OR status = :status2 OR status = :status3 OR status = :status4)

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 5ef52cf9-70be-4ecb-ad62-ac52771213f4

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=1
```
```
status0=PENDING
```
```
status1=ORDERED
```
```
status2=RECEIVED
```
```
status3=CANCELED
```
```
status4=COMPLETED
```

SELECT row_id,notify_flag,request_id,ptsreq_line_id,line_item_type,loc_work_order_loc,work_order_yr,work_order_no,part_part_no,part_suffix,part_description,comment_area,request_qty,x_datetime_insert,emp_empl_no,datetime_acted,action_comment,required_date,status,pri_priority_code,vend_vendor_no,(  SELECT DATETIME_EXP_DELIVERY FROM EPO_LINE

                                                WHERE EPO_PO_ID = (SELECT EPO_PO_ID

                                                                   FROM EPO_WORKORD

                                                                   WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                                AND LINE_NO = (SELECT LINE_NO

                                                               FROM EPO_WORKORD

                                                               WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS POEXPDELIVERY,( SELECT DATETIME_EXP_DELIVERY FROM ERQ_LINE

                                               WHERE ERQ_REQ_ID = (SELECT ERQ_REQ_ID

                                                               FROM ERQ_WORKORD

                                                               WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)

                                               AND LINE_NO = (SELECT LINE_NO

                                                           FROM ERQ_WORKORD

                                                           WHERE ERQ_WORKORD.PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) AS REQEXPDELIVERY,   CASE

```
                        WHEN
```
```
                                ( 
```

			                    SELECT qty_on_hand

                                FROM plo_main p

                                WHERE p.loc_loc_code = pts_request.loc_from_loc

                                    AND p.part_part_no = pts_request.part_part_no

                                    AND p.part_suffix = pts_request.part_suffix) > 0 THEN

                                ( SELECT ( CASE WHEN

                                            ( SELECT BLOCK_ISSUE_COMMIT

                                            FROM loc_main

                                            WHERE loc_loc_code = pts_request.loc_from_loc ) = 'Y' THEN (CASE WHEN (

                                                                                                                        (SELECT qty_on_hand

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) -

                                                                                                                        (SELECT QTY_COMMITTED

                                                                                                                        FROM plo_main p

                                                                                                                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                                                                                                                        AND p.part_part_no = pts_request.part_part_no

                                                                                                                        AND p.part_suffix = pts_request.part_suffix) + pts_request.QTY_COMMITTED - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) ELSE (CASE WHEN (

```
                    (SELECT qty_on_hand
```
```
                        FROM plo_main p
```

                        WHERE p.loc_loc_code = pts_request.loc_from_loc

                        AND p.part_part_no = pts_request.part_part_no

                        AND p.part_suffix = pts_request.part_suffix) - pts_request.request_qty) >= 0 THEN 'Y' ELSE 'N' END) END)

                                FROM pts_request a

                    WHERE a.row_id = pts_request.row_id)

```
                        ELSE 'N'
```

                    END AS AvailQty,(SELECT QTY_ON_HAND FROM PLO_MAIN WHERE PART_PART_NO = PTS_REQUEST.PART_PART_NO AND PART_SUFFIX = PTS_REQUEST.PART_SUFFIX AND LOC_LOC_CODE = PTS_REQUEST.LOC_FROM_LOC) as QtyOnHand,(SELECT MAX(DATE_RECEIVED)

                                                            FROM   ERCPT_MAIN

                                                            WHERE  EXISTS ( SELECT ROW_ID

                                                                            FROM   ERCPT_WORKORD

                                                                            WHERE  ERCPT_RECEIPT_ID = ERCPT_MAIN.ERCPT_RECEIPT_ID

                                                                            AND    PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID)) as DateReceived,(SELECT COUNT(*) FROM PTS_REQUEST_NOTES WHERE PTSREQ_LINE_ID = PTS_REQUEST.PTSREQ_LINE_ID) as NoteCount 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 (status = :status0 OR status = :status1 OR status = :status2 OR status = :status3 OR status = :status4)

Duration: 0.006 sec - A - Rows: 3  - Connection ID: 4cee2b99-3499-442f-8d03-73a16e16e68f

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=1
```

SELECT * FROM EMSDBA.JOB_MAIN WHERE loc_work_order_loc = :loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.038 sec - A - Rows: 1  - Connection ID: 2b8ac22a-4af1-4b77-a68e-b965f8860f18

==========[ 08/19/2026 10:32:13 ]==========
```
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'))

Duration: 0.012 sec - A - Rows: 0  - Connection ID: d78b0d6b-d7d9-4ade-933e-93146d1ca489

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=1
```

SELECT * FROM EMSDBA.JOB_MAIN WHERE loc_work_order_loc = :loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.005 sec - A - Rows: 1  - Connection ID: 2a216589-30ed-4d30-9e5d-26e59c66e3ea

==========[ 08/19/2026 10:32:13 ]==========
```
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'))

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 98f78667-b18e-4e62-8bcb-dd821ff4ec02

==========[ 08/19/2026 10:32:13 ]==========
```
loc_work_order_loc=BALOC
```
```
work_order_yr=2025
```
```
work_order_no=1
```

SELECT * FROM EMSDBA.JOB_MAIN WHERE loc_work_order_loc = :loc_work_order_loc AND work_order_yr = :work_order_yr AND work_order_no = :work_order_no

Duration: 0.002 sec - A - Rows: 1  - Connection ID: 9013c643-f4bf-4ccf-a2cc-1cd79f125715

==========[ 08/19/2026 10:32:13 ]==========
```
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'))

Duration: 0.001 sec - A - Rows: 0  - Connection ID: f3b27b9c-66c6-40f2-843b-275c59616911

==========[ 08/19/2026 10:32:18 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:31:48:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.005 sec - A - Rows: 0  - Connection ID: c7948957-80a5-4f80-9145-054141bf4df2

==========[ 08/19/2026 10:32:18 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 37a35dbb-e52d-49e6-a2c5-c7b7a2c62f23

==========[ 08/19/2026 10:32:19 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.323 sec - A - Rows: 5904  - Connection ID: 22c414dd-ac32-49af-b9b5-23e9442a2867

==========[ 08/19/2026 10:32:19 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.019 sec - A - Rows: 0  - Connection ID: c6fb0237-7b6a-4f88-b158-b758d91a168e

==========[ 08/19/2026 10:32:20 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.019 sec - A - Rows: 0  - Connection ID: b8bba35d-fa05-49fb-a7ef-68f79f5eefaa

==========[ 08/19/2026 10:32:35 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.337 sec - A - Rows: 5904  - Connection ID: 750f98cf-7d40-446c-b3de-8d9f1b725015

==========[ 08/19/2026 10:32:35 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.002 sec - A - Rows: 0  - Connection ID: 5383de04-3845-4ec2-ae72-2ddec1abcd8b

==========[ 08/19/2026 10:32:35 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.002 sec - A - Rows: 0  - Connection ID: c060d30a-f155-4938-9d14-2512e4a65b9e

==========[ 08/19/2026 10:32:48 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:32:18:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.007 sec - A - Rows: 0  - Connection ID: b8a6f577-572a-460c-9059-df4b51b10378

==========[ 08/19/2026 10:32:48 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: f52d75b6-4a3a-44dd-9f28-b9cbf5559344

==========[ 08/19/2026 10:33:01 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.222 sec - A - Rows: 5904  - Connection ID: 758e439b-0db7-4cf7-b36e-b08694e49aab

==========[ 08/19/2026 10:33:01 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: e01d0b04-bc43-49e2-b03e-3f0a0d330f01

==========[ 08/19/2026 10:33:01 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 8522f5c7-6e25-41bf-97d6-05f47596f814

==========[ 08/19/2026 10:33:18 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:32:48:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: cc1b3d7c-2c46-49bb-898a-e3fd6ca34a95

==========[ 08/19/2026 10:33:18 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.007 sec - A - Rows: 0  - Connection ID: 73467eed-7a2c-47d9-8172-0b147f63cf67

==========[ 08/19/2026 10:33:47 ]==========

DELETE FROM USR_LOGGING WHERE USR_USERID IN ('BA')

Duration: 0.006 sec - A - Rows: 1  - Connection ID: e87ab430-16ed-4fe1-b3fb-ec0cc1e4675d

==========[ 08/19/2026 10:33:47 ]==========

SELECT usr_userid,name,phone,email_addr,external_identifier,loc_session_loc,(SELECT NAME FROM LOC_MAIN WHERE LOC_MAIN.LOC_LOC_CODE = USR_MAIN.LOC_SESSION_LOC) as LOC_DESC,login_disabled,datetime_last_login,emp_empl_no,oper_oper_no,mobile_user,require_external_auth,comment_area,disabled_reason,(SELECT USR_USERID FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as IS_LOGGING,(SELECT X_DATETIME_INSERT FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_LOGGING,(SELECT X_DATETIME_EXPIRATION FROM USR_LOGGING WHERE USR_USERID = USR_MAIN.USR_USERID) as DT_EXPIRATION FROM EMSDBA.USR_MAIN ORDER BY usr_userid ASC

Duration: 0.222 sec - A - Rows: 5904  - Connection ID: e9279167-250c-4838-9919-58d46801ea4e

==========[ 08/19/2026 10:33:48 ]==========
```
usr_userid=[ALL]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 9ded5d6b-81f4-4105-8c98-c243d7ec3e38

==========[ 08/19/2026 10:33:48 ]==========
```
usr_userid=[ANON]
```

SELECT * FROM EMSDBA.USR_LOGGING WHERE usr_userid = :usr_userid

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 7f14b53a-11ee-4358-b10b-68eeb5729845

==========[ 08/19/2026 10:33:48 ]==========
```
usr_userid_to=BA
```

x_datetime_insert=08.19.2026:10:33:18:AM

SELECT notif_type,subject,message,row_id,usr_userid_from,usr_userid_to,external_from_user,external_to_user,x_datetime_insert,recvd FROM EMSDBA.MSG_MAIN WHERE  (usr_userid_to = :usr_userid_to)  AND (X_DATETIME_INSERT >= TO_DATE(:x_datetime_insert,'MM.DD.YYYY:HH12:MI:SS:PM'))  AND (notif_type <> 'NOTIF_IM' OR notif_type IS NULL)  ORDER BY x_datetime_insert  DESC ,row_id  DESC

Duration: 0.002 sec - A - Rows: 0  - Connection ID: c578de33-fa3a-4b2b-81d9-300cebb06031

==========[ 08/19/2026 10:33:48 ]==========
```
usr_userid_to=BA
```

SELECT 'BA' as usr_userid_to, usr_userid_from, external_from_user, MAX(x_datetime_insert) as x_datetime_insert, MAX(row_id) as row_id, 'N' as recvd FROM MSG_MAIN WHERE (usr_userid_to = :usr_userid_to)  AND (notif_type = 'NOTIF_IM') AND (RECVD <> 'Y')GROUP BY usr_userid_from, external_from_user ORDER BY x_datetime_insert DESC, row_id DESC

Duration: 0.001 sec - A - Rows: 0  - Connection ID: 596daffb-1f8e-470c-a610-6380ee44cf73