Wednesday 19 June 2013

Form Personalization

  SELECT   DISTINCT d.APPLICATION_NAME,
                    a.form_name,
                    c.USER_FORM_NAME,
                    a.enabled,
                    a.FUNCTION_NAME,
                    a.description,
                    a.SEQUENCE,
                    a.TRIGGER_EVENT,
                    a.TRIGGER_OBJECT,
                    a.CONDITION
    FROM   FND_FORM_CUSTOM_RULES a,
           FND_FORM b,
           FND_FORM_TL c,
           fnd_application_tl d
   WHERE       a.form_name = b.form_name
           AND b.form_id = c.form_id
           AND b.application_id = d.application_id
ORDER BY   application_name

No comments:

Post a Comment