View: OTA_CTRNG_HISTORIES_V

Product:	OTA - Learning Management
Description:	This view is used as the data source for the combined training history displayed in the training histories form. (OTA_DELEGATE_BOOKINGS - "HISTORY" button)
Implementation/DBA Data:	APPS.OTA_CTRNG_HISTORIES_V

View Text

SELECT EVT.COURSE_END_DATE REFERENCE_DATE
, ENT.TITLE REFERENCE_TITLE
, ORG.NAME EVENT_CENTER_MEANING
, TAV.VERSION_NAME EVENT_ACTIVITY_VERSION_NAME
, BST.NAME REFERENCE_STATUS
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, TDB.SUCCESSFUL_ATTENDANCE_FLAG) SUCCESSFUL_ATTENDANCE_MEANING
, HR_GENERAL.DECODE_LOOKUP ('DELEGATE_FAILURE_REASON'
, TDB.FAILURE_REASON) FAILURE_REASON_MEANING
, TO_CHAR(TDB.SCORE) SCHOLASTIC_RATING
, VEN.VENDOR_NAME PROVIDER
, 'OTA' TRAINING_REFERENCE
, TDB.DELEGATE_PERSON_ID PERSON_ID
, TDB.DELEGATE_CONTACT_ID CONTACT_ID
, EVT.DURATION DURATION
, HR_GENERAL.DECODE_LOOKUP ('OTA_DURATION_UNITS'
, EVT.DURATION_UNITS) DURATION_UNITS
, TDB.LAST_UPDATE_DATE
, TDB.LAST_UPDATED_BY
, TDB.LAST_UPDATE_LOGIN
, TDB.CREATION_DATE
, TDB.CREATED_BY
, TDB.ORGANIZATION_ID
, TDB.CUSTOMER_ID
FROM OTA_DELEGATE_BOOKINGS TDB
, OTA_BOOKING_STATUS_TYPES_TL BST
, OTA_ACTIVITY_VERSIONS_TL TAV
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, PO_VENDORS VEN
, HR_ALL_ORGANIZATION_UNITS_TL ORG
WHERE EVT.EVENT_ID = TDB.EVENT_ID
AND ENT.EVENT_ID = EVT.EVENT_ID
AND ENT.LANGUAGE = USERENV ('LANG')
AND TAV.ACTIVITY_VERSION_ID(+) = EVT.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE (+) = USERENV ('LANG')
AND BST.BOOKING_STATUS_TYPE_ID = TDB.BOOKING_STATUS_TYPE_ID
AND BST.LANGUAGE = USERENV ('LANG')
AND EVT.VENDOR_ID = VEN.VENDOR_ID (+)
AND ORG.LANGUAGE (+) = USERENV ('LANG')
AND ORG.ORGANIZATION_ID (+) = EVT.TRAINING_CENTER_ID UNION SELECT NTHV.COMPLETION_DATE
, NTHV.TRNG_TITLE
, NTHV.CENTRE
, NTHV.VERSION_NAME
, HR_GENERAL.DECODE_LOOKUP ('OTA_TRAINING_STATUSES'
, NTHV.STATUS)
, NULL
, NULL
, NTHV.RATING
, NTHV.PROVIDER
, 'ADDITIONAL'
, NTHV.PERSON_ID
, NTHV.CONTACT_ID
, NTHV.DURATION DURATION
, HR_GENERAL.DECODE_LOOKUP ('OTA_DURATION_UNITS'
, NTHV.DURATION_UNITS) DURATION_UNITS
, NTHV.LAST_UPDATE_DATE
, NTHV.LAST_UPDATED_BY
, NTHV.LAST_UPDATE_LOGIN
, NTHV.CREATION_DATE
, NTHV.CREATED_BY
, NTHV.ORGANIZATION_ID
, NTHV.CUSTOMER_ID
FROM OTA_NOTRNG_HISTORIES_V NTHV

Columns