View: BIX_RESOURCE_BASE_V

Product:	BIX - Interaction Center Intelligence
Description:
Implementation/DBA Data:	APPS.BIX_RESOURCE_BASE_V

View Text

SELECT DISTINCT PPF.FULL_NAME RESOURCE_NAME
, JRE.RESOURCE_ID RESOURCE_ID
, JRE.ASSIGNED_TO_GROUP_ID RESOURCE_GROUP_ID
FROM PER_PEOPLE_F PPF
, JTF_RS_RESOURCE_EXTNS JRE
WHERE PPF.PERSON_ID=JRE.SOURCE_ID

Columns