SELECT fcr.form_name, fcr.function_name, fcr.SEQUENCE "Rule Seq",
fcr.description, fcr.condition, fca.SEQUENCE "Action Seq",
fca.action_type, fca.object_type, fca.target_object,
fca.MESSAGE_TYPE, fca.MESSAGE_TEXT, fca.builtin_type,
fca.builtin_arguments, fca.property_name, fca.property_value,
fca.menu_entry, fca.menu_label, fca.menu_seperator,
fca.menu_enabled_in, fca.menu_argument_long, fca.menu_argument_short
FROM apps.fnd_form_custom_rules fcr,
apps.fnd_form_custom_scopes fcs,
apps.fnd_form_custom_actions fca
WHERE --fcr.form_name = 'OEXOEORD'
fcr.enabled = 'Y'
AND fcr.ID = fcs.rule_id
AND ( fcs.level_id = 20
OR ( fcs.level_id = 30
AND fcs.level_value =
(SELECT responsibility_id
FROM fnd_responsibility_tl
WHERE responsibility_name = 'ME HLS Sales Quote - RSM'
AND LANGUAGE = USERENV ('LANG'))
)
)
AND fcr.ID = fca.rule_id
AND fca.enabled = 'Y'
ORDER BY fcr.SEQUENCE, fca.SEQUENCE
No comments:
Post a Comment