VIEW: APPS.ASF_EMPLOYEE_LOV_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'