[Home] [Help]
View: IGS_OR_FUNC_FLTR_V
Product: | IGS - Student System (Obsolete) |
Description: | Organization Function Filter Details View |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT H.ROWID
, H.FUNC_FLTR_ID
, H.FUNC_CODE
, H.ATTR_TYPE
, L.MEANING ATTR_TYPE_M
, H.ATTR_VAL
, H.ATTR_VAL_DESC
, H.INST_ORG_VAL
, H.CREATED_BY
, H.CREATION_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_DATE
, H.LAST_UPDATE_LOGIN
FROM IGS_OR_FUNC_FLTR H
, IGS_LOOKUP_VALUES L
WHERE H.ATTR_TYPE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'OR_FTR_ATTR_TYPE'
Columns
Name |
ROW_ID |
FUNC_FLTR_ID |
FUNC_CODE |
ATTR_TYPE |
ATTR_TYPE_M |
ATTR_VAL |
ATTR_VAL_DESC |
INST_ORG_VAL |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |