VIEW: OTA.OTA_ACTIVITY_VERSIONS#

Source

View Text - Preformatted

select ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, ACTIVITY_ID ACTIVITY_ID, SUPERSEDED_BY_ACT_VERSION_ID SUPERSEDED_BY_ACT_VERSION_ID, DEVELOPER_ORGANIZATION_ID DEVELOPER_ORGANIZATION_ID, CONTROLLING_PERSON_ID CONTROLLING_PERSON_ID, VENDOR_ID VENDOR_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VERSION_NAME VERSION_NAME, ACTUAL_COST ACTUAL_COST, BUDGET_COST BUDGET_COST, BUDGET_CURRENCY_CODE BUDGET_CURRENCY_CODE, COMMENTS COMMENTS, DESCRIPTION DESCRIPTION, DURATION DURATION, DURATION_UNITS DURATION_UNITS, END_DATE END_DATE, EXPENSES_ALLOWED EXPENSES_ALLOWED, INTENDED_AUDIENCE INTENDED_AUDIENCE, LANGUAGE_ID LANGUAGE_ID, MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES, MAXIMUM_INTERNAL_ATTENDEES MAXIMUM_INTERNAL_ATTENDEES, MINIMUM_ATTENDEES MINIMUM_ATTENDEES, OBJECTIVES OBJECTIVES, PROFESSIONAL_CREDIT_TYPE PROFESSIONAL_CREDIT_TYPE, PROFESSIONAL_CREDITS PROFESSIONAL_CREDITS, START_DATE START_DATE, SUCCESS_CRITERIA SUCCESS_CRITERIA, USER_STATUS USER_STATUS, 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, TAV_INFORMATION_CATEGORY TAV_INFORMATION_CATEGORY, TAV_INFORMATION1 TAV_INFORMATION1, TAV_INFORMATION2 TAV_INFORMATION2, TAV_INFORMATION3 TAV_INFORMATION3, TAV_INFORMATION4 TAV_INFORMATION4, TAV_INFORMATION5 TAV_INFORMATION5, TAV_INFORMATION6 TAV_INFORMATION6, TAV_INFORMATION7 TAV_INFORMATION7, TAV_INFORMATION8 TAV_INFORMATION8, TAV_INFORMATION9 TAV_INFORMATION9, TAV_INFORMATION10 TAV_INFORMATION10, TAV_INFORMATION11 TAV_INFORMATION11, TAV_INFORMATION12 TAV_INFORMATION12, TAV_INFORMATION13 TAV_INFORMATION13, TAV_INFORMATION14 TAV_INFORMATION14, TAV_INFORMATION15 TAV_INFORMATION15, TAV_INFORMATION16 TAV_INFORMATION16, TAV_INFORMATION17 TAV_INFORMATION17, TAV_INFORMATION18 TAV_INFORMATION18, TAV_INFORMATION19 TAV_INFORMATION19, TAV_INFORMATION20 TAV_INFORMATION20, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, RCO_ID RCO_ID, VERSION_CODE VERSION_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DATA_SOURCE DATA_SOURCE, COMPETENCY_UPDATE_LEVEL COMPETENCY_UPDATE_LEVEL, ERES_ENABLED ERES_ENABLED from "OTA"."OTA_ACTIVITY_VERSIONS"

View Text - HTML Formatted

SELECT ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, ACTIVITY_ID ACTIVITY_ID
, SUPERSEDED_BY_ACT_VERSION_ID SUPERSEDED_BY_ACT_VERSION_ID
, DEVELOPER_ORGANIZATION_ID DEVELOPER_ORGANIZATION_ID
, CONTROLLING_PERSON_ID CONTROLLING_PERSON_ID
, VENDOR_ID VENDOR_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VERSION_NAME VERSION_NAME
, ACTUAL_COST ACTUAL_COST
, BUDGET_COST BUDGET_COST
, BUDGET_CURRENCY_CODE BUDGET_CURRENCY_CODE
, COMMENTS COMMENTS
, DESCRIPTION DESCRIPTION
, DURATION DURATION
, DURATION_UNITS DURATION_UNITS
, END_DATE END_DATE
, EXPENSES_ALLOWED EXPENSES_ALLOWED
, INTENDED_AUDIENCE INTENDED_AUDIENCE
, LANGUAGE_ID LANGUAGE_ID
, MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES
, MAXIMUM_INTERNAL_ATTENDEES MAXIMUM_INTERNAL_ATTENDEES
, MINIMUM_ATTENDEES MINIMUM_ATTENDEES
, OBJECTIVES OBJECTIVES
, PROFESSIONAL_CREDIT_TYPE PROFESSIONAL_CREDIT_TYPE
, PROFESSIONAL_CREDITS PROFESSIONAL_CREDITS
, START_DATE START_DATE
, SUCCESS_CRITERIA SUCCESS_CRITERIA
, USER_STATUS USER_STATUS
, 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
, TAV_INFORMATION_CATEGORY TAV_INFORMATION_CATEGORY
, TAV_INFORMATION1 TAV_INFORMATION1
, TAV_INFORMATION2 TAV_INFORMATION2
, TAV_INFORMATION3 TAV_INFORMATION3
, TAV_INFORMATION4 TAV_INFORMATION4
, TAV_INFORMATION5 TAV_INFORMATION5
, TAV_INFORMATION6 TAV_INFORMATION6
, TAV_INFORMATION7 TAV_INFORMATION7
, TAV_INFORMATION8 TAV_INFORMATION8
, TAV_INFORMATION9 TAV_INFORMATION9
, TAV_INFORMATION10 TAV_INFORMATION10
, TAV_INFORMATION11 TAV_INFORMATION11
, TAV_INFORMATION12 TAV_INFORMATION12
, TAV_INFORMATION13 TAV_INFORMATION13
, TAV_INFORMATION14 TAV_INFORMATION14
, TAV_INFORMATION15 TAV_INFORMATION15
, TAV_INFORMATION16 TAV_INFORMATION16
, TAV_INFORMATION17 TAV_INFORMATION17
, TAV_INFORMATION18 TAV_INFORMATION18
, TAV_INFORMATION19 TAV_INFORMATION19
, TAV_INFORMATION20 TAV_INFORMATION20
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, RCO_ID RCO_ID
, VERSION_CODE VERSION_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DATA_SOURCE DATA_SOURCE
, COMPETENCY_UPDATE_LEVEL COMPETENCY_UPDATE_LEVEL
, ERES_ENABLED ERES_ENABLED
FROM "OTA"."OTA_ACTIVITY_VERSIONS"