Friday, May 10, 2019

Oracle Form Personalization Query

SELECT fcr.id,
  fff.user_function_name,
  fcr.form_name,
  fcr.sequence,
  fcr.description,
  fcr.enabled,
  fu.user_name,
  fcr.trigger_event,
  fcr.trigger_object,
  fcr.last_update_date,
  fcr.condition,
  fff.function_name,
  ffca.sequence,
  ffca.property_value,
  ffca.target_object,
  ffca.message_text,
  fffs.irep_assoc_function_name,
  fffs.irep_description,
  fffs.irep_method_name
FROM fnd_form_custom_rules fcr,
  fnd_form_functions_vl fff,
  fnd_user fu,
  fnd_form_custom_actions ffca,
  fnd_form_functions fffs,
  fnd_form_functions_tl ffft
WHERE fcr.function_name = fff.function_name
AND ffca.created_by     = fu.user_id
AND fcr.last_updated_by = fu.user_id
AND ffca.rule_id        = fcr.id
AND fffs.function_id    = ffft.function_id
AND fcr.form_name       ='POXPOEPO'
ORDER BY fcr.last_update_date DESC;

No comments:

Post a Comment