VIEW: APPS.OTA_ACTIVITY_DEFINITIONS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')