Product: | OTA - Learning Management |
---|---|
Description: | View to list all information about an Activity Version. It is scheduled for a future release. |
Implementation/DBA Data: | APPS.OTA_ACTIVITY_VERSIONS_VL |
SELECT TAV.ROWID
, TAV.ACTIVITY_VERSION_ID
, TAV.SUPERSEDED_BY_ACT_VERSION_ID
, TAV.DEVELOPER_ORGANIZATION_ID
, TAV.CONTROLLING_PERSON_ID
, TAV.VENDOR_ID
, TAV.OBJECT_VERSION_NUMBER
, AVT.VERSION_NAME
, TAV.ACTUAL_COST
, TAV.BUDGET_COST
, TAV.BUDGET_CURRENCY_CODE
, TAV.COMMENTS
, AVT.DESCRIPTION
, TAV.DURATION
, TAV.DURATION_UNITS
, TAV.END_DATE
, TAV.EXPENSES_ALLOWED
, AVT.INTENDED_AUDIENCE
, TAV.LANGUAGE_ID
, TAV.ACTIVITY_ID
, TAV.MAXIMUM_ATTENDEES
, TAV.MAXIMUM_INTERNAL_ATTENDEES
, TAV.MINIMUM_ATTENDEES
, AVT.OBJECTIVES
, TAV.PROFESSIONAL_CREDIT_TYPE
, TAV.PROFESSIONAL_CREDITS
, TAV.START_DATE
, TAV.SUCCESS_CRITERIA
, TAV.USER_STATUS
, TAV.LAST_UPDATE_DATE
, TAV.LAST_UPDATED_BY
, TAV.LAST_UPDATE_LOGIN
, TAV.CREATED_BY
, TAV.CREATION_DATE
, TAV.TAV_INFORMATION_CATEGORY
, TAV.TAV_INFORMATION1
, TAV.TAV_INFORMATION2
, TAV.TAV_INFORMATION3
, TAV.TAV_INFORMATION4
, TAV.TAV_INFORMATION5
, TAV.TAV_INFORMATION6
, TAV.TAV_INFORMATION7
, TAV.TAV_INFORMATION8
, TAV.TAV_INFORMATION9
, TAV.TAV_INFORMATION10
, TAV.TAV_INFORMATION11
, TAV.TAV_INFORMATION12
, TAV.TAV_INFORMATION13
, TAV.TAV_INFORMATION14
, TAV.TAV_INFORMATION15
, TAV.TAV_INFORMATION16
, TAV.TAV_INFORMATION17
, TAV.TAV_INFORMATION18
, TAV.TAV_INFORMATION19
, TAV.TAV_INFORMATION20
, TAV.INVENTORY_ITEM_ID
, TAV.ORGANIZATION_ID
, TAV.RCO_ID
, TAV.VERSION_CODE
, TAV.BUSINESS_GROUP_ID
, TAV.DATA_SOURCE
, AVT.KEYWORDS
, TAV.COMPETENCY_UPDATE_LEVEL
FROM OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
WHERE TAV.ACTIVITY_VERSION_ID= AVT.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE= USERENV('LANG')