View: OTA_LETTER_REQUEST_LINES_V

Product:	OTA - Learning Management
Description:	View to list all the letter request lines generated for Student Enrollments
Implementation/DBA Data:	APPS.OTA_LETTER_REQUEST_LINES_V

View Text

SELECT LRL.ROWID
, LRL.LETTER_REQUEST_LINE_ID
, LRL.BUSINESS_GROUP_ID
, LRL.LETTER_REQUEST_ID
, TDB.BOOKING_ID
, TDB.BOOKING_STATUS_TYPE_ID
, EVT.EVENT_ID
, ENT.TITLE
, EVT.COURSE_START_DATE
, PER.PERSON_ID
, PER.FULL_NAME
, LRL.DATE_FROM
, LRL.CREATED_BY
, LRL.CREATION_DATE
, LRL.LAST_UPDATE_DATE
, LRL.LAST_UPDATED_BY
, LRL.LAST_UPDATE_LOGIN
FROM OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, PER_ALL_PEOPLE_F PER
, OTA_DELEGATE_BOOKINGS TDB
, PER_LETTER_REQUEST_LINES LRL
WHERE LRL.OTA_BOOKING_ID = TDB.BOOKING_ID
AND TDB.EVENT_ID = EVT.EVENT_ID
AND ENT.EVENT_ID = EVT.EVENT_ID
AND ENT.LANGUAGE= USERENV('LANG')
AND TDB.DELEGATE_PERSON_ID = PER.PERSON_ID(+)
AND LRL.DATE_FROM BETWEEN NVL(PER.EFFECTIVE_START_DATE
, LRL.DATE_FROM)
AND NVL(PER.EFFECTIVE_END_DATE
, LRL.DATE_FROM) UNION SELECT LRL.ROWID
, LRL.LETTER_REQUEST_LINE_ID
, LRL.BUSINESS_GROUP_ID
, LRL.LETTER_REQUEST_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, EVT.EVENT_ID
, ENT.TITLE
, EVT.COURSE_START_DATE
, TO_NUMBER(NULL)
, NULL
, LRL.DATE_FROM
, LRL.CREATED_BY
, LRL.CREATION_DATE
, LRL.LAST_UPDATE_DATE
, LRL.LAST_UPDATED_BY
, LRL.LAST_UPDATE_LOGIN
FROM OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, PER_LETTER_REQUEST_LINES LRL
WHERE LRL.OTA_EVENT_ID = EVT.EVENT_ID
AND ENT.EVENT_ID = EVT.EVENT_ID
AND ENT.LANGUAGE= USERENV('LANG')

Columns