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;
,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