Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Person source types form view |
Implementation/DBA Data: | Not implemented in this database |
SELECT ST.ROWID ROW_ID
, ST.SOURCE_TYPE_ID
, ST.SOURCE_TYPE
, ST.DESCRIPTION
, ST.SYSTEM_SOURCE_TYPE
, LK.MEANING TYPE_MEANING
, ST.ADMISSION_CAT
, AC.DESCRIPTION ADMISSION_CAT_DESC
, ST.CLOSED_IND
, ST.CREATED_BY
, ST.CREATION_DATE
, ST.LAST_UPDATED_BY
, ST.LAST_UPDATE_DATE
, ST.LAST_UPDATE_LOGIN
, ST.FEE_TYPE_ID
, CC1.NAME
, ST.FEE_CAL_TYPE
, ST.FEE_CI_SEQUENCE_NUMBER
, ST.PERSON_TYPE_CODE
, IPT.DESCRIPTION
, ST.ENQUIRY_SOURCE_TYPE
, FLKUP.MEANING
, ST.FUNNEL_STATUS
, LKP.MEANING
, NULL INQ_ENTRY_STAT_ID
, NULL INQ_ENTRY_STAT
, ST.INQUIRY_TYPE_ID INQUIRY_TYPE_ID
FROM IGS_PE_SRC_TYPES ST
, IGS_LOOKUPS_VIEW LK
, IGS_AD_CAT AC
, IGS_PE_PERSON_TYPES IPT
, IGS_AD_CODE_CLASSES CC1
, IGS_LOOKUPS_VIEW LKP
, FND_LOOKUP_VALUES FLKUP
WHERE ST.SYSTEM_SOURCE_TYPE= LK.LOOKUP_CODE AND LK.LOOKUP_TYPE = 'SYSTEM_SOURCE_TYPES' AND ST.ADMISSION_CAT = AC.ADMISSION_CAT (+)
AND ST.FUNNEL_STATUS = LKP.LOOKUP_CODE (+)
AND LKP.LOOKUP_TYPE (+) = 'PERSON_TYPE_FUNNEL_STATUS'
AND ST.FEE_TYPE_ID = CC1.CODE_ID (+)
AND CC1.CLASS (+) = 'SYS_FEE_TYPE'
AND ST.PERSON_TYPE_CODE = IPT.PERSON_TYPE_CODE (+)
AND ST.ENQUIRY_SOURCE_TYPE = FLKUP.LOOKUP_CODE(+)
AND FLKUP.LOOKUP_TYPE(+) = 'VEHICLE_RESPONSE_CODE'
AND FLKUP.LANGUAGE (+) = USERENV('LANG')
AND FLKUP.VIEW_APPLICATION_ID (+) = 279
AND FLKUP.SECURITY_GROUP_ID (+) = 0