Skip to main content

Posts

QUERY to get the Value_set

QUERY to get the Value_set -------------------------------------------------------------------------------------------------------------------------------------- SELECT ffvs.flex_value_set_id , ffvs.flex_value_set_name , ffvs.description set_description , ffvs.validation_type, ffv.flex_value, ffvt.description value_description, ffv.enabled_flag, ffv.last_update_date, ffv.last_updated_by, ffv.attribute1, ffv.attribute2, ffv.attribute3--–Include attribute values based on DFF segments FROM fnd_flex_value_sets ffvs , fnd_flex_values ffv , fnd_flex_values_tl ffvt WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id and ffv.flex_value_id = ffvt.flex_value_id AND ffvt.language = USERENV('LANG') and flex_value_set_name like :p_value_set_name ---'XXXXXXXX' ORDER BY flex_value asc; --------------------------------------------------------------------------------------------------------------------------------------
Post a Comment
Read more
Recent posts

Query To get the SMTP Server Details for a database server

Query To get the SMTP Server Details for a database server -------------------------------------------------------------------------------------------------------------------------------------- select fscpv.parameter_value "SMTP Host Name"       --SMTP protocol uses default port number 25 for outgoing emails       ,25                    "SMTP Port Number"       ,fscpt.description   from fnd_svc_comp_params_tl fscpt       ,fnd_svc_comp_param_vals fscpv  where fscpt.parameter_id = fscpv.parameter_id    and fscpt.display_name = 'Outbound Server Name' --'Inbound Server Name'    and fscpt.language = 'US'; --------------------------------------------------------------------------------------------------------------------------------------
Post a Comment
Read more

Query to get the responsibility attached to a particular request group

Query to get the responsibility attached to a particular request group -------------------------------------------------------------------------------------------------------------------------------------- SELECT DISTINCT FRT.RESPONSIBILITY_NAME,                 FRG.REQUEST_GROUP_NAME                -- FRGU.REQUEST_UNIT_TYPE,                -- FRGU.REQUEST_UNIT_ID,               --  FCPT.USER_CONCURRENT_PROGRAM_NAME   FROM APPS.FND_RESPONSIBILITY         FR,        APPS.FND_RESPONSIBILITY_TL      FRT,        APPS.FND_REQUEST_GROUPS       ...
Post a Comment
Read more

Query to get the Locks on database objects if any

Query to get the Locks on database objects if any -------------------------------------------------------------------------------------------------------------------------------------- SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name  FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID --------------------------------------------------------------------------------------------------------------------------------------
Post a Comment
Read more

Query to get the directory of paricular top.

Query to get the directory of paricular top. -------------------------------------------------------------------------------------------------------------------------------------- Select distinct variable_name,value from fnd_env_context a , fnd_concurrent_processes b, fnd_concurrent_requests r where 1=1 and a.concurrent_process_id=b.concurrent_process_id and a.CONCURRENT_PROCESS_ID=r.CONTROLLING_MANAGER and a.variable_name IN ('AP_TOP','FND_TOP','JAVA_TOP'); --------------------------------------------------------------------------------------------------------------------------------------
Post a Comment
Read more

Query to get the details of a submitted concurrent program

Query to get the details of a submitted concurrent program -------------------------------------------------------------------------------------------------------------------------------------- /* Formatted on 2015/03/17 16:40 (Formatter Plus v4.8.8) */ SELECT   fcp.user_concurrent_program_name program_name,          fcp.concurrent_program_name short_name, fcr.request_id request_id,          frv.responsibility_name responsibility_name,          fcr.request_date request_date, fu.user_name request_submitted_by,          DECODE (fcr.status_code,                  'A', 'Waiting',                  'B', 'Resuming',         ...
Post a Comment
Read more

Query to get details of concurent program along with parameter details

Query to get details of concurent program along with parameter details -------------------------------------------------------------------------------------------------------------------------------------- SELECT   cp.user_concurrent_program_name "Program Name",          cp.concurrent_program_name "Short Name",          ap.application_name "Application", cp.description "Description",          cp.enabled_flag "Enabled", cp.output_file_type "Output Format",          cx.executable_name "Executable Short Name",          lv.meaning "Executable Method",          cx.user_executable_name "Executable Name",          df.column_seq_num "Sequence", df.end_user_column_name "Parameter",     ...
Post a Comment
Read more