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 get concurrent program details

Discussion in 'Oracle Apps Technical' started by TiaMariaKC, Sep 29, 2014.

  1. TiaMariaKC

    TiaMariaKC Guest

    Introduction

    Get information about concurrent programs without the need to query through forms.

    The code

    Code (SQL):

    SELECT fcr.request_id,
             fcpt.user_concurrent_program_name,
             fcr.phase_code,
             fcr.status_code,
             fcr.actual_start_date,
             fcr.actual_completion_date,
             fcr.requested_by,
            (fcr.actual_completion_date - fcr.actual_start_date) * 24 run_time_hrs,
             fcr.argument_text,
             fcr.completion_text
     FROM apps.fnd_concurrent_programs_tl fcpt,
            apps.fnd_concurrent_requests fcr
    WHERE fcr.concurrent_program_id = fcpt.concurrent_program_id
      AND fcr.program_application_id = fcpt.application_id
      AND fcpt.user_concurrent_program_name LIKE '%Program Name%'
    --and fcr.argument_text like '%Text To Find in Arguments to Program%'
    --and request_id = 9999 -- use if you know the request id
      AND trunc(actual_start_date) > trunc(sysdate-30) -- specify a date
    ORDER BY actual_start_date;
     
     
  2. oracleappstraining18

    oracleappstraining18 Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Bangalore
    Nice information .
     
  3. Srikanth2890

    Srikanth2890 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Nice work. Can i get code to develop and retrieve BLOB and CLOB . Please help me.

    Thanks in advance.
     
  4. venki

    venki Guest

    very nice .........