Query to find Form Personalization-oracle Apps R12

1 comment

Query to find Form Personalization details by passing form name:

SELECT ffv.form_id          "Form ID",
       ffv.form_name        "Form Name",
       ffv.user_form_name   "User Form Name",
       ffv.description      "Form Description",
       ffcr.sequence        "Sequence",
       ffcr.description     "Personalization Rule Name"
  FROM fnd_form_vl             ffv,
       fnd_form_custom_rules   ffcr
 WHERE ffv.form_name = ffcr.form_name
 AND   ffv.form_name = :P_Form_Name
 ORDER BY ffv.form_name, ffcr.sequence;

Form Personalization Query

If You Enjoyed This, Take 5 Seconds To Share It

1 comment: