Oracle Table for forms and Reports

FOR FORMS
==========

SELECT * FROM FND_FORM WHERE FORM_NAME = 'EMPANDDEPT' --ALL FORMS

SELECT * FROM FND_FORM_FUNCTIONS WHERE FORM_ID=59986  --ALL FUNCTIONS

SELECT TNAME FROM TAB WHERE TNAME LIKE 'FND_PROF%'

SELECT * FROM FND_MENUS_VL WHERE MENU_NAME='FORMS MENU' --ALL MENUS

SELECT * FROM FND_RESPONSIBILITY_VL WHERE MENU_ID=1014197 --ALL RESPONSIBILITIES

FOR REPORTS
=============

SELECT * FROM FND_EXECUTABLES WHERE EXECUTABLE_NAME='GL_LOAD' -- FOR EXECUTABLES

SELECT * FROM FND_CONCURRENT_PROGRAMS_VL WHERE EXECUTABLE_ID=13237 --FOR CONCURRENT PROGRAMS

SELECT * FROM FND_REQUEST_GROUPS WHERE APPLICATION_ID=20064 AND REQUEST_GROUP_NAME='All Reports' --FOR REQUEST GROUPS

SELECT * FROM FND_REQUEST_GROUP_UNITS    --> Concurrent programs assigned to Request group

SELECT * FROM FND_RESPONSIBILITY WHERE REQUEST_GROUP_ID=1001313 --FOR RESPONSE

SELECT * FROM FND_USER --FOR USERS

SELECT * FROM FND_CONCURRENT_REQUESTS  --USER_ID=REQUESTED_BY

SELECT * FROM FND_USER_RESP_GROUPS_DIRECT

VALUESETS
=========

SELECT * FROM FND_FLEX_VALUE_SETS        --> VALUE SET INFO

SELECT * FROM FND_FLEX_VALUES            --> VALUES ASSIGNED TO THE VALUESET

FOR FLEXFIELDS
===============

SELECT * FROM FND_DESCRIPTIVE_FLEXS_VL WHERE TITLE = 'Requisition Headers'--FOR DESCRIPTIVE FLEXFIELDS

SELECT * FROM FND_ID_FLEXS WHERE ID_FLEX_CODE='GL#' --FOR NAME OF THE KEY FLEXFIELDS

SELECT * FROM FND_ID_FLEX_STRUCTURES WHERE ID_FLEX_CODE ='GL#' AND ID_FLEX_STRUCTURE_CODE='OPERATIONS_ACCOUNTING_FLEX'
   --FOR KEY FLEXFIELDS(CONTAINS STRUCTURES)

FOR PROFILES
============
 
SELECT * FROM FND_PROFILE_OPTIONS_VL WHERE USER_PROFILE_OPTION_NAME ='MO: Operating Unit' --FOR PROFILES

HOW TO FIND OUT HOWMANY RESP_NAMES FOR PARTICULAR USER
======================================================

SELECT FU.USER_NAME,
       FR.RESPONSIBILITY_NAME
  FROM FND_USER FU,
       FND_RESPONSIBILITY_VL FR,
       FND_USER_RESP_GROUPS_DIRECT FUR
 WHERE FU.USER_ID=FUR.USER_ID
   AND FUR.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID
   AND FU.USER_NAME='OPERATIONS'


HOW TO FIND OUT THE LIST OF CONC_PROGRAMS EXECUTED BY USER FOR DAY
==================================================================

SELECT FE.EXECUTABLE_NAME,
       FE.EXECUTION_FILE_NAME,
       FCP.CONCURRENT_PROGRAM_NAME,
       FCP.USER_CONCURRENT_PROGRAM_NAME,
       FRG.REQUEST_GROUP_NAME,
       FR.RESPONSIBILITY_NAME
 FROM  FND_USER FU,
       FND_CONCURRENT_REQUESTS FCR,
       FND_CONCURRENT_PROGRAMS_VL FCP,
       FND_EXECUTABLES FE,
       FND_RESPONSIBILITY_VL FR,
       FND_REQUEST_GROUPS FRG
WHERE  FU.USER_ID=FCR.REQUESTED_BY
  AND  FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID
  AND  FCP.EXECUTABLE_ID = FE.EXECUTABLE_ID
  AND  FCR.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID
  AND  FRG.REQUEST_GROUP_ID=FR.REQUEST_GROUP_ID
  AND  TO_DATE(FCR.REQUEST_DATE)=TO_DATE(SYSDATE)
  AND  FU.USER_NAME='OPERATIONS'