View: OTV_ONE_TIME_EVENTS

Product:	OTA - Learning Management
Description:
Implementation/DBA Data:	APPS.OTV_ONE_TIME_EVENTS

View Text

SELECT EVT.TITLE
, EVT.COURSE_START_DATE
, EVT.COURSE_END_DATE
, EVT.COURSE_START_TIME
, EVT.COURSE_END_TIME
, EVT.DURATION
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, EVT.DURATION_UNITS)
, HR_GENERAL.DECODE_LOOKUP('TRAINING_CENTRE'
, EVT.CENTRE)
, VEN.VENDOR_NAME
, HR_GENERAL.DECODE_LOOKUP('TRAINING_EVENT_TYPE'
, EVT.EVENT_TYPE)
, EVT.EVENT_ID
, EVT.BUSINESS_GROUP_ID
, BGR.NAME
FROM OTA_EVENTS EVT
, PO_VENDORS VEN
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE EVT.VENDOR_ID = VEN.VENDOR_ID(+)
AND EVT.EVENT_TYPE = 'AD HOC'
AND TRUNC(SYSDATE) <= EVT.COURSE_END_DATE
AND EVT.BUSINESS_GROUP_ID+0=BGR.ORGANIZATION_ID
AND EVT.BUSINESS_GROUP_ID+0=NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID)

Columns