View: OTA_STUDENTS_V

Product:	OTA - Learning Management
Description:	View to list all Internal Persons.
Implementation/DBA Data:	APPS.OTA_STUDENTS_V

View Text

SELECT PPF.ROWID
, PPF.PERSON_ID
, PPF.EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE
, PPF.BUSINESS_GROUP_ID
, DECODE(BG.LEGISLATION_CODE
, 'JP'
, PPF.PER_INFORMATION18
, PPF.LAST_NAME)
, DECODE(BG.LEGISLATION_CODE
, 'JP'
, PPF.PER_INFORMATION19
, PPF.FIRST_NAME)
, PPF.FULL_NAME
, PPF.MIDDLE_NAMES
, PPF.DATE_OF_BIRTH
, PPF.TITLE
, HR_GENERAL.DECODE_LOOKUP ('TITLE'
, PPF.TITLE)
, PPF.EMPLOYEE_NUMBER
, PPF.APPLICANT_NUMBER
, PPF.WORK_TELEPHONE
, NULL
, NULL
FROM PER_ALL_PEOPLE_F PPF
, PER_BUSINESS_GROUPS BG
WHERE BG.BUSINESS_GROUP_ID = PPF.BUSINESS_GROUP_ID

Columns