View: JTF_RS_WEB_AVAILABLE_V

Product:	JTF - CRM Foundation
Description:	Stores information about a resources' web availability.
Implementation/DBA Data:	APPS.JTF_RS_WEB_AVAILABLE_V

View Text

SELECT RESOURCE_ID
, RESOURCE_NUMBER
, RESOURCE_NAME
, CATEGORY
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, USER_ID
, USER_NAME
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JTF_RS_RESOURCE_EXTNS_VL RES
WHERE NOT EXISTS ( SELECT AVL.RESOURCE_ID
FROM JTF_RS_RES_AVAILABILITY AVL
WHERE RES.RESOURCE_ID = AVL.RESOURCE_ID
AND AVL.MODE_OF_AVAILABILITY = 'WEB'
AND AVL.AVAILABLE_FLAG = 'N')

Columns