View: OTV_EVENT_ASSOCIATIONS

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

View Text

SELECT OAV.VERSION_NAME
, EVT.TITLE
, ORG.NAME
, JOB.NAME
, POS.NAME
, OEA.ORGANIZATION_ID
, OEA.JOB_ID
, OEA.POSITION_ID
, OAV.ACTIVITY_VERSION_ID
, EVT.EVENT_ID
, EVT.BUSINESS_GROUP_ID
, BGR.NAME
FROM OTA_ACTIVITY_VERSIONS OAV
, OTA_EVENTS EVT
, OTA_EVENT_ASSOCIATIONS OEA
, HR_ORGANIZATION_UNITS ORG
, PER_JOBS JOB
, PER_POSITIONS POS
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE EVT.ACTIVITY_VERSION_ID = OAV.ACTIVITY_VERSION_ID
AND EVT.EVENT_TYPE = 'SCHEDULED'
AND EVT.EVENT_ID = OEA.EVENT_ID
AND OEA.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND OEA.POSITION_ID = POS.POSITION_ID(+)
AND OEA.JOB_ID = JOB.JOB_ID(+)
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