Product: | OTA - Learning Management |
---|---|
Description: | View to list all information about an Activity. It is scheduled for a future release. |
Implementation/DBA Data: | APPS.OTA_ACTIVITY_DEFINITIONS_VL |
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')