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'
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