View: OTV_SESSIONS

Product:	OTA - Learning Management
Description:	View to list Session event.
Implementation/DBA Data:	APPS.OTV_SESSIONS

View Text

SELECT EVT.TITLE
, EVT.COURSE_START_DATE
, EVT.COURSE_START_TIME
, EVT.COURSE_END_TIME
, HR_GENERAL.DECODE_LOOKUP('TRAINING_CENTRE'
, EVT.CENTRE)
, EVT.PARENT_EVENT_ID
, EVT.EVENT_ID
, EVT.BUSINESS_GROUP_ID
, BGR.NAME
, EVT.TRAINING_CENTER_ID
, EVT.LOCATION_ID
FROM OTA_EVENTS EVT
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE EVT.EVENT_TYPE = 'SESSION'
AND EVT.BUSINESS_GROUP_ID=BGR.ORGANIZATION_ID
AND EVT.BUSINESS_GROUP_ID=NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID)

Columns