NAV_BAR

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Tuesday, April 19, 2016

Query to get all Personalization applied to Forms in oracle EBS R12.x

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"
        ,ppx.full_name "Last updated by"
        ,ppx2.full_name "Created by"
from     fnd_form_vl ffv
        ,fnd_form_custom_rules ffcr
        ,per_people_x ppx
        ,fnd_user fus
        ,per_people_x ppx2
        ,fnd_user fus2
where    ffv.form_name = ffcr.form_name
and      ffcr.last_updated_by = fus.user_id
and      ppx.person_id = fus.employee_id
and      ffcr.created_by = fus2.user_id
and      ppx2.person_id = fus2.employee_id
order by ffv.form_name, ffcr.sequence;

No comments:

Post a Comment