Oracle Apps Query : Form Personalization related query

 

1) Form Personlization header table

select  rule_key,function_name,sequence ,rule_type,enabled,a.* 

from fnd_form_custom_rules a 

where form_name ='APXINWKB'

2) Form Personalization Action Table

select id, rule_key,function_name,a.sequence ,rule_type,TRIGGER_EVENT, trigger_object,b.*  

from  fnd_form_custom_rules a  ,FND_FORM_CUSTOM_ACTIONS b

where a.ID = b.RULE_ID 

and form_name ='APXINWKB'