[Home] [Help]
View: IGS_FI_ER_ORD_DTLS_V
Product: | IGS - Student System (Obsolete) |
Description: | Fetches Element Range Order Details |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT EOD.ROWID
, EOD.ORDER_ID
, EOD.ELM_RNG_ORDER_NAME
, EOD.ORDER_NUM
, EOD.ORDER_ATTR_VALUE
, UTL.DESCRIPTION
, EOD.CREATED_BY
, EOD.CREATION_DATE
, EOD.LAST_UPDATE_DATE
, EOD.LAST_UPDATED_BY
, EOD.LAST_UPDATE_LOGIN
FROM IGS_FI_ER_ORD_DTLS EOD
, IGS_PS_UNIT_TYPE_LVL UTL
WHERE EOD.ORDER_ATTR_VALUE = TO_CHAR (UTL.UNIT_TYPE_ID)
Columns
Name |
ROW_ID |
ORDER_ID |
ELM_RNG_ORDER_NAME |
ORDER_NUM |
ORDER_ATTR_VALUE |
ORDER_ATTR_VALUE_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |