[Home] [Help]
View: IGS_SC_OBJ_ATTR_MTHS_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Self-Service view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AT.OBJ_GROUP_ID
, TB.OBJECT_ID
, AT.OBJ_ATTRIB_ID
, AT.OBJ_ATTRIB_NAME
, MT.OBJ_ATTRIB_TYPE
, MT.STATIC_TYPE
, MT.NULL_ALLOW_FLAG
, MT. SELECT_TEXT
, AT.CREATION_DATE
, AT.CREATED_BY
, AT.LAST_UPDATED_BY
, AT.LAST_UPDATE_DATE
, AT.LAST_UPDATE_LOGIN
FROM IGS_SC_OBJ_ATT_MTHS MT
, IGS_SC_OBJ_ATTRIBS AT
, IGS_SC_OBJECTS TB
WHERE TB.OBJECT_ID (+) = MT.OBJECT_ID
AND TB.OBJ_GROUP_ID = AT.OBJ_GROUP_ID
AND AT.OBJ_ATTRIB_ID (+)= MT.OBJ_ATTRIB_ID UNION SELECT AT.OBJ_GROUP_ID
, TB.OBJECT_ID
, AT.OBJ_ATTRIB_ID
, AT.OBJ_ATTRIB_NAME
, ''
, ''
, 'N'
, ''
, AT.CREATION_DATE
, AT.CREATED_BY
, AT.LAST_UPDATED_BY
, AT.LAST_UPDATE_DATE
, AT.LAST_UPDATE_LOGIN
FROM IGS_SC_OBJ_ATTRIBS AT
, IGS_SC_OBJECTS TB
WHERE TB.OBJ_GROUP_ID = AT.OBJ_GROUP_ID
AND AT.OBJ_ATTRIB_ID NOT IN ( SELECT AT.OBJ_ATTRIB_ID
FROM IGS_SC_OBJ_ATT_MTHS MT
WHERE AT.OBJ_ATTRIB_ID = MT.OBJ_ATTRIB_ID
AND MT.OBJECT_ID = TB.OBJECT_ID )
Columns
| Name |
| OBJ_GROUP_ID |
| OBJECT_ID |
| OBJ_ATTRIB_ID |
| OBJ_ATTRIB_NAME |
| OBJ_ATTRIB_TYPE |
| STATIC_TYPE |
| NULL_ALLOW_FLAG |
| SELECT_TEXT |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |