View: OTFV_EXT_TRAINING_EVENT_ENROLS

Product:	OTA - Learning Management
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.OTFV_EXT_TRAINING_EVENT_ENROLS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, DECODE(CON.CONTACT_ID
, NULL
, NULL
, CON.LAST_NAME || '
, ' || INITCAP(CON.TITLE) || ' ' || CON.FIRST_NAME ) PERSON_NAME
, EVT.TITLE EVENT_NAME
, EVT.COMMENTS EVENT_COMMENTS
, EVT.COURSE_START_DATE COURSE_START_DATE
, EVT.COURSE_END_DATE COURSE_END_DATE
, TDB.DATE_BOOKING_PLACED DATE_BOOKING_PLACED
, ORGT1.NAME TRAINING_CENTER
, TDB.ATTENDANCE_RESULT ATTENDANCE_RESULT
, DECODE(TDB.FAILURE_REASON
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('DELEGATE_FAILURE_REASON'
, TDB.FAILURE_REASON)) FAILURE_REASON
, DECODE(TDB.SUCCESSFUL_ATTENDANCE_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TDB.SUCCESSFUL_ATTENDANCE_FLAG)) SUCCESSFUL_ATTENDANCE_FLAG
, TDB.TOTAL_TRAINING_TIME TOTAL_TRAINING_TIME
, DECODE(TDB.CONTENT_PLAYER_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('OTA_CONTENT_PLAYER_STATUS'
, TDB.CONTENT_PLAYER_STATUS)) PLAYER_STATUS
, TDB.SCORE TEST_SCORE
, TDB.COMPLETED_CONTENT NUMBER_OF_MODULES_COMPLETED
, TDB.TOTAL_CONTENT TOTAL_MODULES
, CUS.CUSTOMER_NAME CUSTOMER_NAME
, BST.NAME BOOKING_STATUS
, TAD.NAME ACTIVITY_TYPE
, TAV.VERSION_NAME ACTIVITY_NAME
, TDB.NUMBER_OF_PLACES NUMBER_OF_PLACES
, (TDB.NUMBER_OF_PLACES * DECODE(TDB.SUCCESSFUL_ATTENDANCE_FLAG
, 'Y'
, 1
, 'N'
, 0
, 0)) NUMBER_OF_SUCCESSFUL_PLACES
, TDB.COMMENTS ENROLMENT_COMMENTS
, TDB.SPECIAL_BOOKING_INSTRUCTIONS SPECIAL_REQUIREMENTS
, DECODE(TDB.SOURCE_OF_BOOKING
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('BOOKING_SOURCE'
, TDB.SOURCE_OF_BOOKING)) SOURCE_OF_BOOKING_MEANING
, DECODE(TDB.CORESPONDENT
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('CORRESPONDENT'
, TDB.CORESPONDENT)) CORRESPONDENCE_MEANING
, TDB.DELEGATE_CONTACT_PHONE CORRESPONDENCE_PHONE
, TDB.DELEGATE_CONTACT_FAX CORRESPONDENCE_FAX
, TDB.DELEGATE_CONTACT_EMAIL CORRESPONDENCE_EMAIL
, CAD.ADDRESS1||DECODE(CAD.ADDRESS1
, NULL
, ''
, '
, ')|| CAD.ADDRESS2||DECODE(CAD.ADDRESS2
, NULL
, ''
, '
, ')|| CAD.ADDRESS3||DECODE(CAD.ADDRESS3
, NULL
, ''
, '
, ')|| CAD.ADDRESS4||DECODE(CAD.ADDRESS4
, NULL
, ''
, '
, ')|| CAD.CITY||DECODE(CAD.CITY
, NULL
, ''
, '
, ')|| CAD.STATE||DECODE(CAD.STATE
, NULL
, ''
, '
, ')|| CAD.PROVINCE||DECODE(CAD.PROVINCE
, NULL
, ''
, '
, ')|| CAD.COUNTY||DECODE(CAD.COUNTY
, NULL
, ''
, '
, ')|| CAD.POSTAL_CODE||DECODE(CAD.POSTAL_CODE
, NULL
, ''
, '
, ')|| CAD.COUNTRY CORRESPONDENCE_ADDRESS
, '_DF:OTA:OTA_DELEGATE_BOOKINGS:TDB'
, TDB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, TAD.ACTIVITY_ID ACTIVITY_ID
, TDB.BOOKING_STATUS_TYPE_ID BOOKING_STATUS_TYPE_ID
, TDB.CUSTOMER_ID CUSTOMER_ID
, TDB.DELEGATE_CONTACT_ID DELEGATE_CONTACT_ID
, TDB.BOOKING_ID ENROLLMENT_ID
, EVT.EVENT_ID EVENT_ID
, EVT.TRAINING_CENTER_ID TRAINING_CENTER_ID
, TAV.RCO_ID RCO_ID
, EVT.OFFERING_ID OFFERING_ID
FROM RA_CUSTOMERS CUS
, RA_CONTACTS CON
, OTA_BOOKING_STATUS_TYPES BST
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_EVENTS EVT
, HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_DELEGATE_BOOKINGS TDB
, RA_ADDRESSES CAD
, HR_ALL_ORGANIZATION_UNITS_TL ORGT1
WHERE EVT.EVENT_TYPE = 'SCHEDULED'
AND EVT.TRAINING_CENTER_ID = ORGT1.ORGANIZATION_ID (+)
AND DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, ORGT1.LANGUAGE)= DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, USERENV('LANG'))
AND TDB.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TDB.EVENT_ID = EVT.EVENT_ID
AND EVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND TDB.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID
AND TDB.CUSTOMER_ID = CUS.CUSTOMER_ID
AND TDB.DELEGATE_CONTACT_ID = CON.CONTACT_ID (+)
AND TDB.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TDB.BUSINESS_GROUP_ID)
AND TDB.CONTACT_ADDRESS_ID = CAD.ADDRESS_ID (+) WITH READ ONLY

Columns