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 the Concurrent Programs Details

Discussion in 'Oracle Apps Technical' started by nilesh.dudhane, Mar 20, 2014.

  1. nilesh.dudhane

    nilesh.dudhane Active Member

    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    India
    Introduction

    Query to get the Concurrent Programs Details from backend.

    SQL Code:
    Code (SQL):
    SELECT   DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",fcp.description "Concurrent Program Description",
    fef.executable_name"Executable Name",fef.description "Executable Description",fef.execution_file_name "Procedure Name"
        FROM fnd_executables_form_v fef,fnd_concurrent_programs_vl fcp
       WHERE fcp.APPLICATION_ID=fef.APPLICATION_ID
       AND fef.EXECUTABLE_ID=fcp.EXECUTABLE_ID
       AND fef.executable_name='XX_EXECUTABLE'---Youer Executable Name
      AND fcp.user_concurrent_program_name='Program Name'--Your Consurrent Program name