[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 |