VIEW: APPS.OTV_EVENT_ASSOCIATIONS

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)