1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to check the concurrent program request traking

Discussion in 'Oracle Apps Technical' started by Venkata Ramesh V, May 6, 2016.

  1. Venkata Ramesh V

    Venkata Ramesh V Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Bangalore
    Code (SQL):
    SELECT fcr.request_id,fcpt.user_concurrent_program_name, DECODE(fcr.PHASE_CODE,'C','COMPLETED','P','PENDING','R','RUNNING','***') PHASE,
               DECODE(fcr.STATUS_CODE,'C','COMPLETED','G','WARNING','E','ERRORED','R','RUNNING','***') STATUS,
    fcr.COMPLETION_TEXT,fcr.phase_code,fcr.status_code,((nvl(actual_completion_date,sysdate)-fcr.actual_start_date)*1440) time_in_min,
    fcr.REQUESTED_START_DATE,fcr.ACTUAL_START_DATE,fcr.ACTUAL_COMPLETION_DATE,fcr.argument_text, (SELECT user_name FROM apps.fnd_user WHERE user_id=fcr.requested_by) requested_by
    FROM
    apps.fnd_concurrent_programs_tl fcpt,
    apps.fnd_concurrent_programs fcp,apps.fnd_concurrent_requests fcr
    WHERE fcpt.concurrent_program_id=fcp.concurrent_program_id
    AND fcp.concurrent_program_id=fcr.concurrent_program_id
    --and fcr.argument_text like '%CAPITAL%'
    AND UPPER(fcpt.user_concurrent_program_name) LIKE UPPER('%Sales Journal Report%')
    ORDER BY fcr.REQUEST_DATE DESC, fcr.PHASE_CODE DESC;
     

    Attached Files: