View: PER_LETTER_REQUEST_LINES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_LETTER_REQUEST_LINES_V

View Text

SELECT PLRL.ROWID
, PLRL.LETTER_REQUEST_LINE_ID
, PLRL.BUSINESS_GROUP_ID
, PLRL.LETTER_REQUEST_ID
, PLRL.PERSON_ID
, PLRL.ASSIGNMENT_ID
, PLRL.ASSIGNMENT_STATUS_TYPE_ID
, PLRL.DATE_FROM
, PLRL.REQUEST_ID
, PLRL.PROGRAM_APPLICATION_ID
, PLRL.PROGRAM_ID
, PLRL.PROGRAM_UPDATE_DATE
, PLRL.LAST_UPDATE_DATE
, PLRL.LAST_UPDATED_BY
, PLRL.LAST_UPDATE_LOGIN
, PLRL.CREATED_BY
, PLRL.CREATION_DATE
, PP.FULL_NAME
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, ORGTL.NAME
, PLRL.OTA_BOOKING_STATUS_TYPE_ID
, PLRL.OTA_BOOKING_ID
, PLRL.OTA_EVENT_ID
, PLRL.CONTRACT_ID
FROM PER_LETTER_REQUEST_LINES PLRL
, PER_ASSIGNMENTS ASS
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, PER_ALL_PEOPLE PP
WHERE PLRL.PERSON_ID = PP.PERSON_ID
AND ASS.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ASS.ASSIGNMENT_ID = PLRL.ASSIGNMENT_ID
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG') UNION /* OUTER CASE */ SELECT PLRL.ROWID
, PLRL.LETTER_REQUEST_LINE_ID
, PLRL.BUSINESS_GROUP_ID
, PLRL.LETTER_REQUEST_ID
, PLRL.PERSON_ID
, PLRL.ASSIGNMENT_ID
, PLRL.ASSIGNMENT_STATUS_TYPE_ID
, PLRL.DATE_FROM
, PLRL.REQUEST_ID
, PLRL.PROGRAM_APPLICATION_ID
, PLRL.PROGRAM_ID
, PLRL.PROGRAM_UPDATE_DATE
, PLRL.LAST_UPDATE_DATE
, PLRL.LAST_UPDATED_BY
, PLRL.LAST_UPDATE_LOGIN
, PLRL.CREATED_BY
, PLRL.CREATION_DATE
, PP.FULL_NAME
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, NULL
, PLRL.OTA_BOOKING_STATUS_TYPE_ID
, PLRL.OTA_BOOKING_ID
, PLRL.OTA_EVENT_ID
, PLRL.CONTRACT_ID
FROM PER_LETTER_REQUEST_LINES PLRL
, PER_PEOPLE PP
WHERE PLRL.PERSON_ID = PP.PERSON_ID
AND NOT EXISTS (SELECT 1
FROM PER_ASSIGNMENTS ASS
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE ASS.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ASS.ASSIGNMENT_ID = PLRL.ASSIGNMENT_ID ) UNION SELECT /* --------------------------------------------------------- THIS HALF OF THE VIEW RETRIEVES LETTER REQUEST INFO FOR STUDENT ENROLLMENTS IN OTA --------------------------------------------------------- */ PLRL.ROWID
, PLRL.LETTER_REQUEST_LINE_ID
, PLRL.BUSINESS_GROUP_ID
, PLRL.LETTER_REQUEST_ID
, PLRL.PERSON_ID
, PLRL.ASSIGNMENT_ID
, PLRL.ASSIGNMENT_STATUS_TYPE_ID
, PLRL.DATE_FROM
, PLRL.REQUEST_ID
, PLRL.PROGRAM_APPLICATION_ID
, PLRL.PROGRAM_ID
, PLRL.PROGRAM_UPDATE_DATE
, PLRL.LAST_UPDATE_DATE
, PLRL.LAST_UPDATED_BY
, PLRL.LAST_UPDATE_LOGIN
, PLRL.CREATED_BY
, PLRL.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, PLRL.OTA_BOOKING_STATUS_TYPE_ID
, PLRL.OTA_BOOKING_ID
, PLRL.OTA_EVENT_ID
, PLRL.CONTRACT_ID
FROM PER_LETTER_REQUEST_LINES PLRL
WHERE (PLRL.OTA_EVENT_ID IS NOT NULL OR PLRL.OTA_BOOKING_ID IS NOT NULL)
AND PLRL.PERSON_ID IS NULL

Columns