Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_PE_MATCH_SET_DATA_V |
SELECT SD.ROWID ROW_ID
, SD.MATCH_SET_DATA_ID
, SD.MATCH_SET_ID
, SD.DATA_ELEMENT
, SD.VALUE
, SD.EXACT_INCLUDE
, SD.PARTIAL_INCLUDE
, SD.DROP_IF_NULL
, LK.MEANING DATA_MEANING
, LK.TAG DATA_ELEMENT_TAG
, SD.CREATED_BY
, SD.CREATION_DATE
, SD.LAST_UPDATED_BY
, SD.LAST_UPDATE_DATE
, SD.LAST_UPDATE_LOGIN
FROM IGS_PE_MTCH_SET_DATA SD
, IGS_LOOKUP_VALUES LK
WHERE SD.DATA_ELEMENT = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'DUPLICATE_DATA_ELEMENTS'