To Get Administration URL for a Oracle Workflow

DECLARE
   url_l       VARCHAR2 (1000);
   l_agent   VARCHAR2 (2000) := NULL;
BEGIN
   l_agent := WF_CORE.TRANSLATE ('WF_WEB_AGENT');
   url_l :=
      wf_monitor.getEnvelopeUrl (x_agent        => l_agent,
                                                     x_item_type    => UPPER ('XXTSTWF'),
                                                     x_item_key     => '100010',
                                                     x_admin_mode   => 'YES'
                                                   );
   DBMS_OUTPUT.put_line (url_l);
END;


select * from wf_item_types
where name ='XXTSTWF'

select * from WF_ITEM_ACTIVITY_STATUSES
where item_type = 'XXTSTWF'