VIEW: APPS.PA_PROJ_ROLES_V

Source

View Text - Preformatted

SELECT project_role_id project_role_id , meaning meaning , description description , 'PROJECT_ROLE' FROM pa_project_role_types_tl WHERE language=userenv('LANG') UNION SELECT TO_NUMBER(attribute1) ,meaning ,description ,lookup_code FROM pa_lookups WHERE lookup_type = 'PA_NOTIFICATION_ROLE'

View Text - HTML Formatted

SELECT PROJECT_ROLE_ID PROJECT_ROLE_ID
, MEANING MEANING
, DESCRIPTION DESCRIPTION
, 'PROJECT_ROLE'
FROM PA_PROJECT_ROLE_TYPES_TL
WHERE LANGUAGE=USERENV('LANG') UNION SELECT TO_NUMBER(ATTRIBUTE1)
, MEANING
, DESCRIPTION
, LOOKUP_CODE
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PA_NOTIFICATION_ROLE'