[Home] [Help]
View: PA_PROJECT_PLAYERS_V
View Text
SELECT PRO.PROJECT_ID
, PRO.PERSON_ID
, PA_UTILS.GETPERSONINFO(PRO.PERSON_ID
, 'FULL_NAME')
, PA_UTILS.GETPERSONINFO(PRO.PERSON_ID
, 'LAST_NAME')
, PA_UTILS.GETPERSONINFO(PRO.PERSON_ID
, 'FIRST_NAME')
, PA_UTILS.GETPERSONINFO(PRO.PERSON_ID
, 'MIDDLE_NAMES')
, PA_UTILS.GETPERSONINFO(PRO.PERSON_ID
, 'EMPLOYEE_NUMBER')
, PRO.START_DATE_ACTIVE
, PRO.END_DATE_ACTIVE
, ROL.MEANING
FROM PA_PROJECT_PLAYERS PRO
, PA_PROJECT_ROLE_TYPES ROL
WHERE PA_UTILS.GETPERSONINFO(PRO.PERSON_ID) = 'FOUND'
AND PRO.PROJECT_ROLE_TYPE = ROL.PROJECT_ROLE_TYPE
Columns
Name |
PROJECT_ID |
PERSON_ID |
FULL_NAME |
LAST_NAME |
FIRST_NAME |
MIDDLE_NAMES |
EMPLOYEE_NUMBER |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ROLE |