Thursday, 29 June 2017

Query to get custom Form personalization List

Query :

Select Distinct A.Id,
                A.Form_Name,
                A.Enabled,
                C.User_Form_Name,
                D.Application_Name,
                A.Description,
                Ca.Action_Type,
                Ca.Enabled,
                Ca.Object_Type,
                ca.message_type,
                ca.message_text
  from FND_FORM_CUSTOM_RULES   a,
       FND_FORM                b,
       FND_FORM_TL             c,
       Fnd_Application_Tl      D,
       Fnd_Form_Custom_Actions ca
 where a.form_name = b.form_name
   And B.Form_Id = C.Form_Id
   And B.Application_Id = D.Application_Id
   And A.Enabled = 'Y'
   and a.id = ca.rule_id
   and D.Application_Name = 'Purchasing'
--and A.Form_Name='POXPOVPO'

No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...