VIEW: APPS.OTA_NOTRNG_HISTORIES_V

Source

View Text - Preformatted

SELECT NTH. ROWID ,NTH.PERSON_ID ,NTH.CONTACT_ID ,NTH.TRNG_TITLE ,NTH.PROVIDER ,NTH.TYPE ,NTH.CENTRE ,NTH.COMPLETION_DATE ,NTH.AWARD ,NTH.RATING ,NTH.DURATION ,NTH.DURATION_UNITS ,NTH.STATUS ,NTH.ACTIVITY_VERSION_ID ,NTH.VERIFIED_BY_ID ,NTH.LAST_UPDATE_DATE ,NTH.LAST_UPDATED_BY ,NTH.LAST_UPDATE_LOGIN ,NTH.CREATED_BY ,NTH.CREATION_DATE ,NTH.NTH_INFORMATION_CATEGORY ,NTH.NTH_INFORMATION1 ,NTH.NTH_INFORMATION2 ,NTH.NTH_INFORMATION3 ,NTH.NTH_INFORMATION4 ,NTH.NTH_INFORMATION5 ,NTH.NTH_INFORMATION6 ,NTH.NTH_INFORMATION7 ,NTH.NTH_INFORMATION8 ,NTH.NTH_INFORMATION9 ,NTH.NTH_INFORMATION10 ,NTH.NTH_INFORMATION11 ,NTH.NTH_INFORMATION12 ,NTH.NTH_INFORMATION13 ,NTH.NTH_INFORMATION14 ,NTH.NTH_INFORMATION15 ,NTH.NTH_INFORMATION16 ,NTH.NTH_INFORMATION17 ,NTH.NTH_INFORMATION18 ,NTH.NTH_INFORMATION19 ,NTH.NTH_INFORMATION20 ,NTH.ORG_ID ,NTH.BUSINESS_GROUP_ID ,NTH.OBJECT_VERSION_NUMBER ,TAV.VERSION_NAME ,NTH.ORGANIZATION_ID ,NTH.CUSTOMER_ID FROM OTA_NOTRNG_HISTORIES NTH, OTA_ACTIVITY_VERSIONS_TL TAV WHERE TAV.ACTIVITY_VERSION_ID(+) = NTH.ACTIVITY_VERSION_ID AND TAV.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT NTH. ROWID
, NTH.PERSON_ID
, NTH.CONTACT_ID
, NTH.TRNG_TITLE
, NTH.PROVIDER
, NTH.TYPE
, NTH.CENTRE
, NTH.COMPLETION_DATE
, NTH.AWARD
, NTH.RATING
, NTH.DURATION
, NTH.DURATION_UNITS
, NTH.STATUS
, NTH.ACTIVITY_VERSION_ID
, NTH.VERIFIED_BY_ID
, NTH.LAST_UPDATE_DATE
, NTH.LAST_UPDATED_BY
, NTH.LAST_UPDATE_LOGIN
, NTH.CREATED_BY
, NTH.CREATION_DATE
, NTH.NTH_INFORMATION_CATEGORY
, NTH.NTH_INFORMATION1
, NTH.NTH_INFORMATION2
, NTH.NTH_INFORMATION3
, NTH.NTH_INFORMATION4
, NTH.NTH_INFORMATION5
, NTH.NTH_INFORMATION6
, NTH.NTH_INFORMATION7
, NTH.NTH_INFORMATION8
, NTH.NTH_INFORMATION9
, NTH.NTH_INFORMATION10
, NTH.NTH_INFORMATION11
, NTH.NTH_INFORMATION12
, NTH.NTH_INFORMATION13
, NTH.NTH_INFORMATION14
, NTH.NTH_INFORMATION15
, NTH.NTH_INFORMATION16
, NTH.NTH_INFORMATION17
, NTH.NTH_INFORMATION18
, NTH.NTH_INFORMATION19
, NTH.NTH_INFORMATION20
, NTH.ORG_ID
, NTH.BUSINESS_GROUP_ID
, NTH.OBJECT_VERSION_NUMBER
, TAV.VERSION_NAME
, NTH.ORGANIZATION_ID
, NTH.CUSTOMER_ID
FROM OTA_NOTRNG_HISTORIES NTH
, OTA_ACTIVITY_VERSIONS_TL TAV
WHERE TAV.ACTIVITY_VERSION_ID(+) = NTH.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE(+) = USERENV('LANG')