VIEW: APPS.OTA_ACTIVITY_VERSIONS_VL

Source

View Text - Preformatted

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 ,TAV.ERES_ENABLED FROM OTA_ACTIVITY_VERSIONS TAV , OTA_ACTIVITY_VERSIONS_TL AVT WHERE TAV.ACTIVITY_VERSION_ID= AVT.ACTIVITY_VERSION_ID AND AVT.LANGUAGE= USERENV('LANG')

View Text - HTML Formatted

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
, TAV.ERES_ENABLED
FROM OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
WHERE TAV.ACTIVITY_VERSION_ID= AVT.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE= USERENV('LANG')