[Home] [Help]
VIEW: APPS.PA_AS_PERSON_ROLES_V
Source
View Text - Preformatted
SELECT meaning , lookup_code , lookup_type , description , meaning ||' - '||description FROM as_lookups WHERE lookup_type = 'ROLE_TYPE'
View Text - HTML Formatted
SELECT MEANING
, LOOKUP_CODE
, LOOKUP_TYPE
, DESCRIPTION
, MEANING ||' - '||DESCRIPTION
FROM AS_LOOKUPS
WHERE LOOKUP_TYPE = 'ROLE_TYPE'