eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_FI_ELM_RNG_ORDS_V

Product:	IGS - Student System
Description:	Fetches Element Range Orders
Implementation/DBA Data:	APPS.IGS_FI_ELM_RNG_ORDS_V

View Text

SELECT FERO.ROWID
, FERO.ELM_RNG_ORDER_NAME
, FERO.ELM_RNG_ORDER_DESC
, FERO.ELM_RNG_ORDER_ATTR_CODE
, LKUP.MEANING
, FERO.CLOSED_FLAG
, FERO.CREATED_BY
, FERO.CREATION_DATE
, FERO.LAST_UPDATE_DATE
, FERO.LAST_UPDATED_BY
, FERO.LAST_UPDATE_LOGIN
FROM IGS_FI_ELM_RNG_ORDS FERO
, IGS_LOOKUP_VALUES LKUP
WHERE FERO.ELM_RNG_ORDER_ATTR_CODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'IGS_FI_UNIT_ATTRIBUTE'

Columns

Name
ROW_ID
ELM_RNG_ORDER_NAME
ELM_RNG_ORDER_DESC
ELM_RNG_ORDER_ATTR_CODE
ELM_RNG_ORDER_ATTR_CODE_DESC
CLOSED_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN