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_Concu...