Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT DOAC.ROWID ROW_ID
, DOAC.DT_ALIAS DT_ALIAS
, DOAC.OFFSET_DT_ALIAS OFFSET_DT_ALIAS
, DOAC.S_DT_OFFSET_CONSTRAINT_TYPE S_DT_OFFSET_CONSTRAINT_TYPE
, LKUP.MEANING MEANING
, LKUP.CLOSED_IND CLOSED_IND
, DOAC.CONSTRAINT_CONDITION CONSTRAINT_CONDITION
, DOAC.CONSTRAINT_RESOLUTION CONSTRAINT_RESOLUTION
, DOAC.CREATED_BY CREATED_BY
, DOAC.CREATION_DATE CREATION_DATE
, DOAC.LAST_UPDATED_BY LAST_UPDATED_BY
, DOAC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DOAC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_DA_OFFCNT DOAC
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_CODE = DOAC.S_DT_OFFSET_CONSTRAINT_TYPE
AND (LKUP.CLOSED_IND = 'N' OR LKUP.LOOKUP_CODE =DOAC.S_DT_OFFSET_CONSTRAINT_TYPE)
AND LKUP.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE'