VIEW: APPS.OTA_CTRNG_HISTORIES_V

Source

View Text - Preformatted

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 ,'OLM' 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

View Text - HTML Formatted

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
, 'OLM' 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