Wednesday, October 26, 2016

SQL to check Pay Groups


SELECT a.lookup_type "Type",
       a.meaning "Meaning",
       b.APPLICATION_NAME "Application",
       a.DESCRIPTION "Description",
       DECODE (a.CUSTOMIZATION_LEVEL, 'U', 'User') "AccessLevel",
       C.LOOKUP_CODE "code",
       c.meaning "Meaning",
       c.DESCRIPTION "Description",
       c.tag "Tag",
       TO_CHAR (c.start_date_active, 'DD-MON-YYYY') "EffectiveDatefrom",
       TO_CHAR (c.end_date_active, 'DD-MON-YYYY') "EffectiveDateto",
       DECODE (c.enabled_flag,  'Y', 'Yes',  'N', 'No') "Enabled"
  FROM apps.FND_LOOKUP_TYPES_VL a,
       apps.fnd_application_tl b,
       apps.FND_LOOKUP_VALUES_VL c
 WHERE     a.application_id = b.application_id
       AND A.LOOKUP_TYPE = c.LOOKUP_TYPE
       AND a.lookup_type IN ('PAY GROUP');

No comments: