View: OTA_ACTIVITY_DEFINITIONS_V

Product:	OTA - Learning Management
Description:	View to list all information about an Activity.
Implementation/DBA Data:	APPS.OTA_ACTIVITY_DEFINITIONS_V

View Text

SELECT TAD.ROWID
, TAD.ACTIVITY_ID
, TAD.BUSINESS_GROUP_ID
, ADT.NAME
, TAD.COMMENTS
, ADT.DESCRIPTION
, TAD.MULTIPLE_CON_VERSIONS_FLAG
, TAD.OBJECT_VERSION_NUMBER
, TAD.LAST_UPDATE_DATE
, TAD.LAST_UPDATED_BY
, TAD.LAST_UPDATE_LOGIN
, TAD.CREATED_BY
, TAD.CREATION_DATE
, TAD.TAD_INFORMATION_CATEGORY
, TAD.TAD_INFORMATION1
, TAD.TAD_INFORMATION2
, TAD.TAD_INFORMATION3
, TAD.TAD_INFORMATION4
, TAD.TAD_INFORMATION5
, TAD.TAD_INFORMATION6
, TAD.TAD_INFORMATION7
, TAD.TAD_INFORMATION8
, TAD.TAD_INFORMATION9
, TAD.TAD_INFORMATION10
, TAD.TAD_INFORMATION11
, TAD.TAD_INFORMATION12
, TAD.TAD_INFORMATION13
, TAD.TAD_INFORMATION14
, TAD.TAD_INFORMATION15
, TAD.TAD_INFORMATION16
, TAD.TAD_INFORMATION17
, TAD.TAD_INFORMATION18
, TAD.TAD_INFORMATION19
, TAD.TAD_INFORMATION20
, TAD.CATEGORY_USAGE_ID
FROM OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL ADT
WHERE TAD.ACTIVITY_ID = ADT.ACTIVITY_ID
AND ADT.LANGUAGE= USERENV('LANG')

Columns