[Home] [Help]
View: ASF_EMPLOYEE_LOV_V
View Text
SELECT A.RESOURCE_ID PERSON_ID
, A.SOURCE_NAME FULL_NAME
, A.SOURCE_BUSINESS_GRP_NAME BUSINESS_GROUP_NAME
, A.SOURCE_BUSINESS_GRP_ID BUSINESS_GROUP_ID
, A.SOURCE_NAME||'('||A.RESOURCE_ID||')' FULL_NAME_ID
, A.USER_ID
, A.SOURCE_JOB_TITLE JOB_TITLE
, A.SOURCE_PHONE PHONE
, A.SOURCE_EMAIL EMAIL
FROM JTF_RS_RESOURCE_EXTNS A
WHERE A.CATEGORY='EMPLOYEE'
Columns
Name |
PERSON_ID |
FULL_NAME |
BUSINESS_GROUP_NAME |
BUSINESS_GROUP_ID |
FULL_NAME_ID |
USER_ID |
JOB_TITLE |
PHONE |
EMAIL |