[Home] [Help]
View: IGS_OR_ORG_NOTE_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OON.ROWID ROW_ID
, OON.ORG_STRUCTURE_ID
, OON.ORG_STRUCTURE_TYPE
, OON.ORG_NOTE_TYPE
, ONT.NOTE_TYPE_DESCRIPTION
, OON.ORG_NOTE_SEQUENCE
, OON.START_DATE
, OON.END_DATE
, OON.NOTE_TEXT
, OON.CREATION_DATE
, OON.CREATED_BY
, OON.LAST_UPDATE_DATE
, OON.LAST_UPDATED_BY
, OON.LAST_UPDATE_LOGIN
FROM IGS_OR_ORG_NOTES OON
, IGS_OR_ORG_NOTE_TYPE ONT
WHERE OON.ORG_NOTE_TYPE = ONT.ORG_NOTES_TYPE
Columns
Name |
ROW_ID |
ORG_STRUCTURE_ID |
ORG_STRUCTURE_TYPE |
ORG_NOTE_TYPE |
NOTE_TYPE_DESCRIPTION |
ORG_NOTE_SEQUENCE |
START_DATE |
END_DATE |
NOTE_TEXT |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |