Discrete Manufacturing - EBS (MOSC)

MOSC Banner

how to complete the workflow process duration at the time deferred

edited Aug 20, 2014 4:16AM in Discrete Manufacturing - EBS (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center