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

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...