Sure Apps
Welcome
Home
Login/Register
Commands
Sql
Pl/Sql
Reports
Forms
Oracle Apps
FAQs
Sql
Pl/Sql
Reports
Forms
Oracle Apps
Learn
Sql
Pl/Sql
Reports
Forms
Oracle Apps

Few Sql Commands

1. To find out the Executable file for a concurrent Program
    SELECT a.concurrent_program_name, at.concurrent_program_id,
                   at.user_concurrent_program_name, c.executable_name
      FROM apps.fnd_concurrent_programs_tl at,
                   apps.fnd_concurrent_programs a,
                   apps.fnd_executables c
    WHERE user_concurrent_program_name LIKE '%[Concurrent program Name]%'
        AND AT.concurrent_program_id = a.concurrent_program_id
        AND a.executable_id = c.executable_id;


2. To find out the Responsibility assigned to a particular Concurrent Program
    SELECT responsibility_name
      FROM apps.fnd_responsibility_tl
    WHERE responsibility_id IN (
                  SELECT responsibility_id
                    FROM apps.fnd_responsibility
                  WHERE request_group_id IN (
                                  SELECT request_group_id
                                    FROM apps.fnd_request_group_units
                                  WHERE request_unit_id IN (
                                                SELECT concurrent_program_id
                                                  FROM apps.fnd_concurrent_programs_tl
                                                WHERE user_concurrent_program_name LIKE '%[Conc Program Name]%'
                                                    AND LANGUAGE = 'US')))
    AND LANGUAGE = 'US';


3. To find out the Responsibility assigned to a particular Request Set
    SELECT responsibility_name
      FROM apps.fnd_responsibility_tl
    WHERE responsibility_id IN (
                  SELECT responsibility_id
                    FROM apps.fnd_responsibility
                  WHERE request_group_id IN (
                                  SELECT request_group_id
                                    FROM apps.fnd_request_group_units
                                  WHERE request_unit_id IN (
                                                SELECT request_set_id
                                                  FROM apps.fnd_request_sets_tl
                                                WHERE user_request_set_name LIKE '%[Request Set Name]%'
                                                    AND LANGUAGE = 'US')))
    AND LANGUAGE = 'US';


4. To find out the Responsibilities assigned to a particular Application
    SELECTfr.application_id,
fat.application_name,
frt.responsibility_name,
fr.responsibility_key,
frt.description
      FROMapps.fnd_responsibility_tl frt,
fnd_responsibility fr,
fnd_application_tl fat
    WHEREfr.responsibility_id = frt.responsibility_id
         ANDfr.application_id = frt.application_id
         ANDfr.application_id = fat.application_id
         ANDfat.application_name = [application name]
DisclaimerContact UsPrivacy Policy