VIEW: APPS.IGS_PE_SRC_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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