DBA Data[Home] [Help]

VIEW: APPS.IGS_FI_ELM_RNG_ORDS_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'