Wednesday, 26 October 2016

Get Program Name, Schedule date, Responsibility name, Requestor, Status, Phase, Start Time, End Time, Arguments from request Id in oracle apps




SELECT DECODE (fcrs.description,
               NULL, fcrs.user_concurrent_program_name,
               fcrs.description)
          Program_Name,
       TO_CHAR (fcrs.requested_start_date, 'Dy HH24:MI') Schedule_Date,
       fcrs.request_id,
       fresp.responsibility_name,
       fcrs.requestor,
       (SELECT meaning
          FROM apps.fnd_lookups
         WHERE     lookup_type = 'CP_STATUS_CODE'
               AND lookup_code = fcrs.status_code)
          Status,
       (SELECT meaning
          FROM apps.fnd_lookups
         WHERE     lookup_type = 'CP_PHASE_CODE'
               AND lookup_code = fcrs.status_code)
          Phase_Status,
       fcrs.actual_start_date Start_Time,
       fcrs.actual_completion_date End_Time,
       fcr.argument_text
  FROM apps.fnd_conc_req_summary_v fcrs,
       apps.fnd_responsibility_vl fresp,
       fnd_concurrent_requests fcr
 WHERE     fcrs.responsibility_id = fresp.responsibility_id
       AND fcrs.request_id = fcr.request_id
       AND fcrs.request_id IN ('Enter request Id');

No comments:

Post a Comment