View: CAC_CAL_RESOURCES

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.CAC_CAL_RESOURCES

View Text

SELECT USER_ID
, USER_NAME
, RESOURCE_ID
, RESOURCE_NAME
, 'RS_'||CATEGORY AS RESOURCE_TYPE
, SOURCE_BUSINESS_GRP_NAME AS BUSINESS_GROUP
, SOURCE_JOB_TITLE AS JOB_TITLE
, SOURCE_PHONE AS PHONE
, SOURCE_EMAIL AS EMAIL
, SOURCE_MGR_NAME AS MANAGER
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM JTF_RS_RESOURCE_EXTNS_VL