VIEW: APPS.IGS_CO_S_PER_LTR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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