Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is created using a join condition between IGS_AD_DSCP_ATTR and IGS_LOOKUPS_VIEW |
Implementation/DBA Data: | Not implemented in this database |
SELECT DA.ROWID ROW_ID
, DA.DISCREPANCY_ATTR_ID
, DA.SRC_CAT_ID
, DA.ATTRIBUTE_NAME
, LK1.MEANING ATTRIBUTE_NAME_MEANING
, DA.DISCREPANCY_RULE_CD
, LK2.MEANING DICREPANCY_RULE_CD_MEANING
, DA.LAST_UPDATED_BY
, DA.LAST_UPDATE_DATE
, DA.LAST_UPDATE_LOGIN
, DA.CREATED_BY
, DA.CREATION_DATE
FROM IGS_AD_DSCP_ATTR DA
, IGS_LOOKUPS_VIEW LK1
, IGS_LOOKUPS_VIEW LK2
WHERE DA. ATTRIBUTE_NAME= LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'IGS_PE_DTL_ATTR_DISCRP_RULE'
AND DA.DISCREPANCY_RULE_CD = LK2.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'DISCREPANCY_RULE'