Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is for Admission Applications Setup |
Implementation/DBA Data: | Not implemented in this database |
SELECT AAS.ROWID ROW_ID
, AAS.ADMAPPL_SETUP_ID
, LK1.LOOKUP_CODE ALIAS_TYPE
, LK1.MEANING ALIAS_TYPE_DESC
, AAS.PERSON_ID_TYPE
, PIT.DESCRIPTION PERSON_ID_TYPE_DESC
, AAS.PERMANENT_ADDR_TYPE
, AAS.MAILING_ADDR_TYPE
, AAS.PS_NOTE_TYPE_ID
, PSNT.NOTE_TYPE PS_NOTE_TYPE
, PSNT.DESCRIPTION PS_NOTE_TYPE_DESC
, AAS.WE_NOTE_TYPE_ID
, WENT.NOTE_TYPE WE_NOTE_TYPE
, WENT.DESCRIPTION WE_NOTE_TYPE_DESC
, AAS.ACT_NOTE_TYPE_ID
, ACTNT.NOTE_TYPE ACT_NOTE_TYPE
, ACTNT.DESCRIPTION ACT_NOTE_TYPE_DESC
, AAS.DEPENDENT_OF_VETERAN
, CC1.CODE DEPENDENT_OF_VETEREN_TYPE
, CC1.DESCRIPTION DEPENDENT_OF_VETEREN_DESC
, AAS.APP_SOURCE_ID
, CC2.NAME APP_SOURCE_NAME
, CC2.DESCRIPTION APP_SOURCE_DESC
, AAS.CREATED_BY
, AAS.CREATION_DATE
, AAS.LAST_UPDATED_BY
, AAS.LAST_UPDATE_DATE
, AAS.LAST_UPDATE_LOGIN
FROM IGS_SS_ADMAPPL_SETUP AAS
, IGS_LOOKUPS_VIEW LK1
, IGS_PE_PERSON_ID_TYP PIT
, IGS_AD_NOTE_TYPES PSNT
, IGS_AD_NOTE_TYPES WENT
, IGS_AD_NOTE_TYPES ACTNT
, IGS_PE_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
WHERE AAS.ALIAS_TYPE = LK1.LOOKUP_CODE (+)
AND LK1.LOOKUP_TYPE (+) = 'PE_ALIAS_TYPE'
AND LK1.ENABLED_FLAG (+) = 'Y'
AND AAS.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE (+)
AND AAS.PS_NOTE_TYPE_ID = PSNT.NOTES_TYPE_ID(+)
AND AAS.WE_NOTE_TYPE_ID = WENT.NOTES_TYPE_ID(+)
AND AAS.ACT_NOTE_TYPE_ID = ACTNT.NOTES_TYPE_ID(+)
AND AAS.DEPENDENT_OF_VETERAN = CC1.CODE_CLASSES_ID (+)
AND AAS.APP_SOURCE_ID = CC2.CODE_ID (+)