eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OTA.OTA_ACTIVITY_DEFINITIONS#

Source

View Text - Preformatted


select ACTIVITY_ID ACTIVITY_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, COMMENTS COMMENTS, DESCRIPTION DESCRIPTION, MULTIPLE_CON_VERSIONS_FLAG MULTIPLE_CON_VERSIONS_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TAD_INFORMATION_CATEGORY TAD_INFORMATION_CATEGORY, TAD_INFORMATION1 TAD_INFORMATION1, TAD_INFORMATION2 TAD_INFORMATION2, TAD_INFORMATION3 TAD_INFORMATION3, TAD_INFORMATION4 TAD_INFORMATION4, TAD_INFORMATION5 TAD_INFORMATION5, TAD_INFORMATION6 TAD_INFORMATION6, TAD_INFORMATION7 TAD_INFORMATION7, TAD_INFORMATION8 TAD_INFORMATION8, TAD_INFORMATION9 TAD_INFORMATION9, TAD_INFORMATION10 TAD_INFORMATION10, TAD_INFORMATION11 TAD_INFORMATION11, TAD_INFORMATION12 TAD_INFORMATION12, TAD_INFORMATION13 TAD_INFORMATION13, TAD_INFORMATION14 TAD_INFORMATION14, TAD_INFORMATION15 TAD_INFORMATION15, TAD_INFORMATION16 TAD_INFORMATION16, TAD_INFORMATION17 TAD_INFORMATION17, TAD_INFORMATION18 TAD_INFORMATION18, TAD_INFORMATION19 TAD_INFORMATION19, TAD_INFORMATION20 TAD_INFORMATION20, CATEGORY_USAGE_ID CATEGORY_USAGE_ID from "OTA"."OTA_ACTIVITY_DEFINITIONS"

View Text - HTML Formatted

SELECT ACTIVITY_ID ACTIVITY_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, COMMENTS COMMENTS
, DESCRIPTION DESCRIPTION
, MULTIPLE_CON_VERSIONS_FLAG MULTIPLE_CON_VERSIONS_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TAD_INFORMATION_CATEGORY TAD_INFORMATION_CATEGORY
, TAD_INFORMATION1 TAD_INFORMATION1
, TAD_INFORMATION2 TAD_INFORMATION2
, TAD_INFORMATION3 TAD_INFORMATION3
, TAD_INFORMATION4 TAD_INFORMATION4
, TAD_INFORMATION5 TAD_INFORMATION5
, TAD_INFORMATION6 TAD_INFORMATION6
, TAD_INFORMATION7 TAD_INFORMATION7
, TAD_INFORMATION8 TAD_INFORMATION8
, TAD_INFORMATION9 TAD_INFORMATION9
, TAD_INFORMATION10 TAD_INFORMATION10
, TAD_INFORMATION11 TAD_INFORMATION11
, TAD_INFORMATION12 TAD_INFORMATION12
, TAD_INFORMATION13 TAD_INFORMATION13
, TAD_INFORMATION14 TAD_INFORMATION14
, TAD_INFORMATION15 TAD_INFORMATION15
, TAD_INFORMATION16 TAD_INFORMATION16
, TAD_INFORMATION17 TAD_INFORMATION17
, TAD_INFORMATION18 TAD_INFORMATION18
, TAD_INFORMATION19 TAD_INFORMATION19
, TAD_INFORMATION20 TAD_INFORMATION20
, CATEGORY_USAGE_ID CATEGORY_USAGE_ID
FROM "OTA"."OTA_ACTIVITY_DEFINITIONS"