Concurrent Programs & Requests Queries

**Query to get Executable name for given Program

SELECT DISTINCT fcp.user_concurrent_program_name,
fe.executable_name,
fe.execution_file_name
FROM
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcp,
fnd_request_groups frg,
fnd_executables fe
WHERE frgu.request_unit_id = fcp.concurrent_program_id
AND frgu.request_group_id = frg.request_group_id
AND fe.executable_id = fcp.executable_id
AND fe.execution_file_name LIKE 'GEPS_INV_ITEM_COPY_COST_PKG%';
AND fcp.user_concurrent_program_name ='<program_name>';

**Query for Concurrent Program Parameters
Select B.User_Concurrent_Program_Name,A.Concurrent_Program_Name,
B.Description,D.Meaning,F.End_User_Column_Name,
F.Enabled_Flag,G.Flex_Value_Set_Name,G.Validation_Type
From
Apps.Fnd_Concurrent_Programs A,
Apps.Fnd_Concurrent_Programs_Tl B,
Apps.Fnd_Executables C,
Apps.Fnd_Lookups D,
Apps.Fnd_Application E,
Apps.Fnd_Descr_Flex_Col_Usage_Vl F,
Apps.Fnd_Flex_Value_Sets G
Where
B.User_Concurrent_Program_Name Like ':Program'
And B.Concurrent_Program_Id = A.Concurrent_Program_Id
And B.Language = 'US'
And C.Executable_Id = A.Executable_Id
And C.Execution_Method_Code = D.Lookup_Code
And D.Lookup_Type='CP_EXECUTION_METHOD_CODE'
And E.Application_Id = C.Application_Id
And F.Application_Id = A.Application_Id (+)
And F.Descriptive_Flexfield_Name = '$SRS$.'||A.Concurrent_Program_Name (+)
And F.Flex_Value_Set_Id = G.Flex_Value_Set_Id
Order By A.Concurrent_Program_Name,F.Column_Seq_Num

**Query to get Run Times for given Program or request id

Select
Request_Id,
Actual_Start_Date,
Actual_Completion_Date,
Round((Actual_Completion_Date - Actual_Start_Date) * 24 * 60*60, 2) Runtime_Sec
From Apps.Fnd_Concurrent_Requests
Where
--request_id in (123456)
Concurrent_Program_Id = 987654
Order By Request_Id Desc;

**Query to obtain request group & responsibility for given program

SELECT DISTINCT
frl.responsibility_name "Responsibility Name",frl.responsibility_id,
fcp.user_concurrent_program_name "Concurrent Program Name",
frg.request_group_name "Request Group Name"
FROM
fnd_responsibility_vl frl
,fnd_request_groups frg
,fnd_request_group_units frgu
,fnd_concurrent_programs_vl fcp
WHERE
frg.request_group_id=frl.request_group_id
AND frg.request_group_id=frgu.request_group_id
AND frgu.request_unit_id=fcp.concurrent_program_id
--and FCP.USER_CONCURRENT_PROGRAM_NAME like '<conc program>'
AND fcp.concurrent_program_id=123456
ORDER BY frl.responsibility_name;

**Query to get Concurrent Manger for given request id

Select B.User_Concurrent_Queue_Name
From Fnd_Concurrent_Processes A,
Fnd_Concurrent_Queues_Vl B,
Fnd_Concurrent_Requests C
Where A.Concurrent_Queue_Id = B.Concurrent_Queue_Id
And A.Concurrent_Process_Id = C.Controlling_Manager
And C.Request_Id = 7654321;