Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Application Type Components |
Implementation/DBA Data: | Not implemented in this database |
SELECT ASAC.ROWID ROW_ID
, ASAC.ADMISSION_APPLICATION_TYPE
, ASAC.PAGE_NAME
, LKV1.MEANING PAGE_DESC
, ASAC.COMPONENT_CODE
, LKV2.MEANING COMPONENT_DESC
, ASAC.COMP_DISP_NAME
, ASAC.INCLUDE_FLAG
, ASAC.REQUIRED_FLAG
, ASAC.CREATED_BY
, ASAC.CREATION_DATE
, ASAC.LAST_UPDATED_BY
, ASAC.LAST_UPDATE_DATE
, ASAC.LAST_UPDATE_LOGIN
FROM IGS_AD_SS_APPL_COMPS ASAC
, IGS_LOOKUP_VALUES LKV1
, IGS_LOOKUP_VALUES LKV2
WHERE ASAC.PAGE_NAME=LKV1.LOOKUP_CODE
AND LKV1.LOOKUP_TYPE = 'SS_APPL_SELFSERVICE_PAGES'
AND ASAC.COMPONENT_CODE=LKV2.LOOKUP_CODE
AND LKV2.LOOKUP_TYPE = 'IGS_AD_SS_PG_COMPS'