Thursday, November 20, 2008

Query for Form personalization

SELECT (SELECT application_name
FROM fnd_application_tl fa
WHERE fa.application_id = ff.application_id) application, ffcr.SEQUENCE,
ffcr.function_name,
REPLACE (ffcr.description, CHR (39), CHR (39) || CHR (39)) description,
ffcr.trigger_event, ffcr.trigger_object,
REPLACE (
REPLACE (ffcr.condition, CHR (10), CHR (32)),
CHR (39),
CHR (39) || CHR (39)
) condition,
ffcr.enabled, ffcr.fire_in_enter_query, ffcr.form_name
FROM apps.fnd_form_custom_rules ffcr, applsys.fnd_form ff
WHERE (ff.form_name) = (ffcr.form_name)

No comments: