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:
Post a Comment