Query to find Custom forms in oracle apps

Hi friends, We are going to discuss about the Query to find Custom forms in oracle apps. We will share the detail sql query which will help to extract the details of custom forms created in oracle apps application. Using this query , we can able to extract the details of any oracle apps form which is registered in the application. If you have the name of the custom form then you can find through name in the query itself otherwise you can run this sql query without form name to extract the details of custom forms in oracle apps. We will also share the important tables which helps to store the oracle apps forms registration details. Please find below the complete detail about sql Query to find Custom forms in oracle apps.

Query to find Custom forms in oracle apps

5 Important Tables used in the Query to find Custom forms in oracle apps

 1.Fnd_Application_Tl

 2.Fnd_Form_Custom_Actions

 3.FND_FORM_CUSTOM_RULES

 4.FND_FORM

 5.FND_FORM_TL

Detail SQL Query to find Custom forms in oracle apps

Here below is the detail sql query to find the details of oracle apps forms.

Select Distinct 

                F_C_RULE.Form_Name,

                F_C_RULE.Enabled,

                F_TL.User_Form_Name,

                F_C_RULE.Description,

                D.Application_Name,

                F_CUS_ACT.Action_Type,

                F_CUS_ACT.Enabled,

                F_CUS_ACT.Object_Type,

                F_CUS_ACT.message_type,

                F_CUS_ACT.message_text

  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.Enabled = 'Y'

 and F_C_RULE.Form_Name='XXINVDATA'

    and F_C_RULE.id = F_CUS_ACT.rule_id

   and D.Application_Name = 'Purchasing'

   And F_FORM.Form_Id = F_TL.Form_Id

   And F_FORM.Application_Id = D.Application_Id

Query to find Custom forms in oracle apps