Form Personzalization in Oracle:
SELECT fat.application_name, ffc.function_name, fff.user_function_name,
fff.description function_description, ffc.form_name,
fft.user_form_name, fft.description form_description, ffc.SEQUENCE,
ffc.description, trigger_event, trigger_object, condition,
ffc.enabled, ffca.SEQUENCE line_sequence, argument_type, action_type,
ffca.enabled line_enabled, object_type, ffca.MESSAGE_TYPE,
ffca.MESSAGE_TEXT, ffca.builtin_type, ffca.property_name,
ffca.menu_entry, ffca.menu_label, menu_action,
ffca.menu_argument_long, ffca.menu_argument_short
FROM fnd_form_custom_rules ffc,
fnd_form_custom_actions ffca,
fnd_form_functions_vl fff,
fnd_form_tl fft,
fnd_application_tl fat
WHERE ffc.ID = ffca.rule_id
AND ffc.form_name = NVL (:p_form_name, ffc.form_name)
AND ffc.description = NVL (:p_forms_personalization, ffc.description)
AND ffc.function_name = fff.function_name
AND fff.form_id = fft.form_id
AND fat.application_id = fff.application_id
AND ffc.form_name LIKE 'GME%'
ORDER BY fat.application_name, ffc.form_name, ffc.SEQUENCE
fff.description function_description, ffc.form_name,
fft.user_form_name, fft.description form_description, ffc.SEQUENCE,
ffc.description, trigger_event, trigger_object, condition,
ffc.enabled, ffca.SEQUENCE line_sequence, argument_type, action_type,
ffca.enabled line_enabled, object_type, ffca.MESSAGE_TYPE,
ffca.MESSAGE_TEXT, ffca.builtin_type, ffca.property_name,
ffca.menu_entry, ffca.menu_label, menu_action,
ffca.menu_argument_long, ffca.menu_argument_short
FROM fnd_form_custom_rules ffc,
fnd_form_custom_actions ffca,
fnd_form_functions_vl fff,
fnd_form_tl fft,
fnd_application_tl fat
WHERE ffc.ID = ffca.rule_id
AND ffc.form_name = NVL (:p_form_name, ffc.form_name)
AND ffc.description = NVL (:p_forms_personalization, ffc.description)
AND ffc.function_name = fff.function_name
AND fff.form_id = fft.form_id
AND fat.application_id = fff.application_id
AND ffc.form_name LIKE 'GME%'
ORDER BY fat.application_name, ffc.form_name, ffc.SEQUENCE