how to complete the workflow process duration at the time deferred
hi all,
hi all,
whatever are causing the length of the workflow process at the time deferred.
I have a query:
SELECT ias.item_key,
TO_CHAR (ias.begin_date, 'DD-MON-YYYY HH: MM: SS') BEGIN_DATE,
NVL (
REPLACE (REPLACE (ias.execution_time, CHR (10), ''),
CHR (13),
''),
'')
execution_time,
TO_CHAR (rha.last_update_date, 'DD-MON-YYYY HH: MM: SS')
last_update_date,
rha.segment1,
rha.description,
rha.authorization_status,
ppl1.full_name preparer,
ppl1.email_address preparer_email
FROM wf_item_activity_statuses ias,
po_requisition_headers_all rha,
per_people_v7 ppl1
WHERE ias.item_key = rha.wf_item_key