Query to find Form name in oracle apps

Hi friends, we are going to discuss about the Query to find Form name in oracle apps. We will share the detail sql query which will help to extract the oracle apps form details. This query will help us to provide the informations of the oracle apps forms registered in the application. Using this query, we can find out the each and every oracle apps form details. This is one of the useful sql query interms of keep track on any other new form creation in oracle apps. This is one of the complete sql query to provide the forms detail in oracle apps. We are also sharing the important tables which do stores the Form name and other form details in oracle apps. Please find below the complete detail about Query to find Form name in oracle apps.

Query to find form name in oracle apps

4 Important Tables uses in the Query to find Form name in oracle apps

 1.FND_FORM_CUSTOM_RULES

 2.FND_FORM

 3.Fnd_Application_Tl

 4.Fnd_Form_Custom_Actions

Detail Level SQL Query to find Form name in oracle apps

Here below is the detail sql query to find out the form name in oracle.

Select Distinct 

                F_TL.User_Form_Name,

                F_C_RULE.Description,

                F_C_RULE.Form_Name,

                F_C_RULE.Enabled,

                D.Application_Name,

                F_CUS_ACT.Action_Type,

              F_CUS_ACT.message_type,

                F_CUS_ACT.message_text,

                F_CUS_ACT.Enabled,

                F_CUS_ACT.Object_Type

  from        apps.Fnd_Application_Tl  D,

       apps.Fnd_Form_Custom_Actions F_CUS_ACT,

  apps.FND_FORM_CUSTOM_RULES   F_C_RULE,

       apps.FND_FORM                F_FORM,

       apps.FND_FORM_TL             F_TL

 where F_C_RULE.form_name = F_FORM.form_name

      and F_C_RULE.Form_Name='XXINVDATA'

     and F_C_RULE.id = F_CUS_ACT.rule_id

    And F_C_RULE.Enabled = 'Y'

   And F_FORM.Form_Id = F_TL.Form_Id

   And F_FORM.Application_Id = D.Application_Id

   and D.Application_Name = 'Purchasing'

Query to find form name in oracle apps