Product: | OTA - Learning Management |
---|---|
Description: | View to list Internal Asociations for an Event. |
Implementation/DBA Data: | APPS.OTA_EVENT_ASSOCIATIONS_V2 |
SELECT TEA.ROWID
, TEA.EVENT_ASSOCIATION_ID
, EVT.BUSINESS_GROUP_ID
, EVT.EVENT_ID
, TEA.ORGANIZATION_ID
, ORG.NAME
, TEA.JOB_ID
, JOB.NAME
, TEA.POSITION_ID
, POS.NAME
, TEA.COMMENTS
, TEA.LAST_UPDATE_DATE
, TEA.LAST_UPDATED_BY
, TEA.LAST_UPDATE_LOGIN
, TEA.CREATED_BY
, TEA.CREATION_DATE
, TEA.TEA_INFORMATION_CATEGORY
, TEA.TEA_INFORMATION1
, TEA.TEA_INFORMATION2
, TEA.TEA_INFORMATION3
, TEA.TEA_INFORMATION4
, TEA.TEA_INFORMATION5
, TEA.TEA_INFORMATION6
, TEA.TEA_INFORMATION7
, TEA.TEA_INFORMATION8
, TEA.TEA_INFORMATION9
, TEA.TEA_INFORMATION10
, TEA.TEA_INFORMATION11
, TEA.TEA_INFORMATION12
, TEA.TEA_INFORMATION13
, TEA.TEA_INFORMATION14
, TEA.TEA_INFORMATION15
, TEA.TEA_INFORMATION16
, TEA.TEA_INFORMATION17
, TEA.TEA_INFORMATION18
, TEA.TEA_INFORMATION19
, TEA.TEA_INFORMATION20
FROM OTA_EVENTS EVT
, OTA_EVENT_ASSOCIATIONS TEA
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
WHERE EVT.EVENT_ID = TEA.EVENT_ID
AND TEA.CUSTOMER_ID IS NULL
AND TEA.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND ORG.LANGUAGE (+) = USERENV ('LANG')
AND TEA.JOB_ID = JOB.JOB_ID(+)
AND TEA.POSITION_ID = POS.POSITION_ID(+)