Product: | OTA - Learning Management |
---|---|
Description: | View to list all information about an Activity Version. |
Implementation/DBA Data: | APPS.OTA_ACTIVITY_VERSIONS_V |
SELECT TAV.ROWID
, TAV.ACTIVITY_VERSION_ID
, TAV.ACTIVITY_ID
, ADT.NAME
, TAV.BUSINESS_GROUP_ID
, TAV.SUPERSEDED_BY_ACT_VERSION_ID
, OTA_TAV_BUS.GET_ACTIVITY_VERSION_NAME( TAV.SUPERSEDED_BY_ACT_VERSION_ID)
, TAV.DEVELOPER_ORGANIZATION_ID
, ORG.NAME
, TAV.CONTROLLING_PERSON_ID
, PRS.FULL_NAME
, TAV.OBJECT_VERSION_NUMBER
, AVT.VERSION_NAME
, TAV.COMMENTS
, AVT.DESCRIPTION
, TAV.DURATION
, TAV.DURATION_UNITS
, HR_GENERAL.DECODE_LOOKUP('OTA_DURATION_UNITS'
, TAV.DURATION_UNITS)
, TAV.END_DATE
, AVT.INTENDED_AUDIENCE
, TAV.LANGUAGE_ID
, TAV.MAXIMUM_ATTENDEES
, TAV.MINIMUM_ATTENDEES
, AVT.OBJECTIVES
, TAV.START_DATE
, TAV.SUCCESS_CRITERIA
, HR_GENERAL.DECODE_LOOKUP('ACTIVITY_SUCCESS_CRITERIA'
, TAV.SUCCESS_CRITERIA )
, TAV.USER_STATUS
, HR_GENERAL.DECODE_LOOKUP('ACTIVITY_USER_STATUS'
, TAV.USER_STATUS)
, TAV.VENDOR_ID
, VEN.VENDOR_NAME
, TAV.ACTUAL_COST
, TAV.BUDGET_COST
, TAV.BUDGET_CURRENCY_CODE
, TAV.EXPENSES_ALLOWED
, TAV.PROFESSIONAL_CREDIT_TYPE
, HR_GENERAL.DECODE_LOOKUP('PROFESSIONAL_CREDIT_TYPE'
, TAV.PROFESSIONAL_CREDIT_TYPE)
, TAV.PROFESSIONAL_CREDITS
, TAV.MAXIMUM_INTERNAL_ATTENDEES
, 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
, OTA_GENERAL.FND_LANG_CODE(TAV.LANGUAGE_ID)
, OTA_GENERAL.FND_LANG_DESC(TAV.LANGUAGE_ID)
, TAV.INVENTORY_ITEM_ID
, TAV.ORGANIZATION_ID
, TAV.RCO_ID
, TAV.VERSION_CODE
, TAV.DATA_SOURCE
, AVT.KEYWORDS
, TAV.COMPETENCY_UPDATE_LEVEL
FROM OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL ADT
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PER_ALL_PEOPLE_F PRS
, PO_VENDORS VEN
, FND_SESSIONS SES
WHERE ORG.ORGANIZATION_ID = TAV.DEVELOPER_ORGANIZATION_ID
AND PRS.PERSON_ID (+) = TAV.CONTROLLING_PERSON_ID
AND SES.EFFECTIVE_DATE BETWEEN NVL(PRS.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND NVL(PRS.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)
AND VEN.VENDOR_ID(+) = TAV.VENDOR_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND ADT.ACTIVITY_ID = TAD.ACTIVITY_ID
AND ADT.LANGUAGE= USERENV('LANG')
AND AVT.ACTIVITY_VERSION_ID=TAV.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE= USERENV('LANG')
AND SES.SESSION_ID = USERENV('SESSIONID')
AND ORG.LANGUAGE=USERENV('LANG')