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 find Concurrent Program's Complete details from backend

Discussion in 'Oracle Apps Technical' started by Raviprakash, Oct 20, 2014.

  1. Raviprakash

    Raviprakash Forum Genius

    Messages:
    14
    Likes Received:
    2
    Trophy Points:
    785
    Query to find Concurrent Program's Complete details from backend
    ************************************************** ************************
    SELECT
    fcp.concurrent_program_id,
    fcpt.user_concurrent_program_name,
    fcp.concurrent_program_name,
    flv.meaning Exe_Method ,
    fe.EXECUTION_FILE_NAME,
    frg.request_group_name,
    frt.responsibility_name
    FROM APPS.fnd_request_groups frg
    ,APPS.fnd_request_group_units frgu
    ,APPS.fnd_concurrent_programs fcp
    ,APPS.fnd_concurrent_programs_tl fcpt
    ,APPS.fnd_responsibility_tl frt
    ,APPS.fnd_responsibility frs
    , apps.FND_EXECUTABLES FE
    ,apps.fnd_lookup_values flv
    WHERE frgu.unit_application_id = fcp.application_id
    AND frgu.request_unit_id = fcp.concurrent_program_id
    AND frg.request_group_id = frgu.request_group_id
    AND frg.application_id = frgu.application_id
    AND fcpt.source_lang = USERENV('LANG')
    AND fcp.application_id = fcpt.application_id
    AND fcp.concurrent_program_id = fcpt.concurrent_program_id
    AND frs.application_id = frt.application_id
    AND frs.responsibility_id = frt.responsibility_id
    AND frt.source_lang = USERENV('LANG')
    AND frs.request_group_id = frg.request_group_id
    AND frs.application_id = frg.application_id
    and fcpt.user_concurrent_program_name like 'XX%'
    and fcp.executable_id = fe.executable_id
    and fe.EXECUTION_METHOD_CODE = flv.lookup_code
    and flv. lookup_type = 'CP_EXECUTION_METHOD_CODE'
    order by RESPONSIBILITY_NAME, USER_CONCURRENT_PROGRAM_NAME