View: IGS_CO_S_PER_LTR_V

Product:	IGS - Student System
Description:	IGS_CO_S_PER_LTR_V describes the system letter to be produced for the person.
Implementation/DBA Data:	APPS.IGS_CO_S_PER_LTR_V

View Text

SELECT CSPL.ROW_ID ROW_ID
, CSPL.PERSON_ID PERSON_ID
, PV.PERSON_NUMBER PERSON_NUMBER
, PV.FULL_NAME NAME
, PV.SEX_MEANING SEX
, PV.BIRTH_DT BIRTH_DT
, CSPL.CORRESPONDENCE_TYPE CORRESPONDENCE_TYPE
, CT.DESCRIPTION DESCRIPTION
, CSPL.LETTER_REFERENCE_NUMBER LETTER_REFERENCE_NUMBER
, CSPL.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CSPL.CREATED_BY CREATED_BY
, CSPL.CREATION_DATE CREATION_DATE
, CSPL.LAST_UPDATED_BY LAST_UPDATED_BY
, CSPL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSPL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSPL.REQUEST_ID REQUEST_ID
, CSPL.PROGRAM_ID PROGRAM_ID
, CSPL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CSPL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CSPL.ORG_ID ORG_ID
FROM IGS_CO_S_PER_LTR CSPL
, IGS_PE_PERSON_V PV
, IGS_CO_TYPE CT
WHERE CSPL.PERSON_ID = PV.PERSON_ID
AND CSPL.CORRESPONDENCE_TYPE = CT.CORRESPONDENCE_TYPE

Columns