View: IGS_AD_DSCP_ATTR_V

Product:	IGS - Student System
Description:	This view is created using a join condition between IGS_AD_DSCP_ATTR and IGS_LOOKUPS_VIEW
Implementation/DBA Data:	APPS.IGS_AD_DSCP_ATTR_V

View Text

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'

Columns