Product: | OTA - Learning Management |
---|---|
Description: | View for Student Non OTA Histories |
Implementation/DBA Data: | APPS.OTA_NOTRNG_HISTORIES_V |
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')