[Home] [Help]
View: IGS_DA_CNFG_SRT_ORD_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT S.ROWID ROW_ID
, F1.LOOKUP_CODE SORT_ORDER_TYPE
, F1.MEANING SORT_ORDER_DESCR
, NVL(S.SORT_ORDER_VAL
, 1) SORT_ORDER_VAL
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_DATE
FROM IGS_DA_CNFG_SRT_ORD S
, IGS_LOOKUPS_VIEW F1
WHERE F1.LOOKUP_CODE = S.SORT_ORDER_TYPE (+)
AND F1.LOOKUP_TYPE = 'IGS_DA_SORT_UNT_OPTS'
Columns
Name |
ROW_ID |
SORT_ORDER_TYPE |
SORT_ORDER_DESCR |
SORT_ORDER_VAL |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |