VIEW: APPS.OTA_STUDENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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