View: ASF_EMPLOYEE_LOV_V

Product:	ASF - Sales Online
Description:	Employee LOV view
Implementation/DBA Data:	APPS.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