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_ACT_CAT_INCLUSIONS#

Source

View Text - Preformatted


select ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, ACTIVITY_CATEGORY ACTIVITY_CATEGORY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EVENT_ID EVENT_ID, COMMENTS COMMENTS, 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, ACI_INFORMATION_CATEGORY ACI_INFORMATION_CATEGORY, ACI_INFORMATION1 ACI_INFORMATION1, ACI_INFORMATION2 ACI_INFORMATION2, ACI_INFORMATION3 ACI_INFORMATION3, ACI_INFORMATION4 ACI_INFORMATION4, ACI_INFORMATION5 ACI_INFORMATION5, ACI_INFORMATION6 ACI_INFORMATION6, ACI_INFORMATION7 ACI_INFORMATION7, ACI_INFORMATION8 ACI_INFORMATION8, ACI_INFORMATION9 ACI_INFORMATION9, ACI_INFORMATION10 ACI_INFORMATION10, ACI_INFORMATION11 ACI_INFORMATION11, ACI_INFORMATION12 ACI_INFORMATION12, ACI_INFORMATION13 ACI_INFORMATION13, ACI_INFORMATION14 ACI_INFORMATION14, ACI_INFORMATION15 ACI_INFORMATION15, ACI_INFORMATION16 ACI_INFORMATION16, ACI_INFORMATION17 ACI_INFORMATION17, ACI_INFORMATION18 ACI_INFORMATION18, ACI_INFORMATION19 ACI_INFORMATION19, ACI_INFORMATION20 ACI_INFORMATION20, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, PRIMARY_FLAG PRIMARY_FLAG, CATEGORY_USAGE_ID CATEGORY_USAGE_ID from "OTA"."OTA_ACT_CAT_INCLUSIONS"

View Text - HTML Formatted

SELECT ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, ACTIVITY_CATEGORY ACTIVITY_CATEGORY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, EVENT_ID EVENT_ID
, COMMENTS COMMENTS
, 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
, ACI_INFORMATION_CATEGORY ACI_INFORMATION_CATEGORY
, ACI_INFORMATION1 ACI_INFORMATION1
, ACI_INFORMATION2 ACI_INFORMATION2
, ACI_INFORMATION3 ACI_INFORMATION3
, ACI_INFORMATION4 ACI_INFORMATION4
, ACI_INFORMATION5 ACI_INFORMATION5
, ACI_INFORMATION6 ACI_INFORMATION6
, ACI_INFORMATION7 ACI_INFORMATION7
, ACI_INFORMATION8 ACI_INFORMATION8
, ACI_INFORMATION9 ACI_INFORMATION9
, ACI_INFORMATION10 ACI_INFORMATION10
, ACI_INFORMATION11 ACI_INFORMATION11
, ACI_INFORMATION12 ACI_INFORMATION12
, ACI_INFORMATION13 ACI_INFORMATION13
, ACI_INFORMATION14 ACI_INFORMATION14
, ACI_INFORMATION15 ACI_INFORMATION15
, ACI_INFORMATION16 ACI_INFORMATION16
, ACI_INFORMATION17 ACI_INFORMATION17
, ACI_INFORMATION18 ACI_INFORMATION18
, ACI_INFORMATION19 ACI_INFORMATION19
, ACI_INFORMATION20 ACI_INFORMATION20
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, PRIMARY_FLAG PRIMARY_FLAG
, CATEGORY_USAGE_ID CATEGORY_USAGE_ID
FROM "OTA"."OTA_ACT_CAT_INCLUSIONS"