VIEW: APPS.JTF_RS_WEB_AVAILABLE_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')