VIEW: APPS.OTA_EVENT_ASSOCIATIONS_V2

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)