VIEW: APPS.OTA_ACTIVITY_VERSIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')