VIEW: APPS.OTA_LETTER_REQUEST_LINES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')