View: IGS_IN_ENQ_STATUS_V

Product:	IGS - Student System
Description:	Obsolete
Implementation/DBA Data:	APPS.IGS_IN_ENQ_STATUS_V

View Text

SELECT ES.ROWID ROW_ID
, ES.ENQUIRY_STATUS ENQUIRY_STATUS
, ES.DESCRIPTION DESCRIPTION
, ES.S_ENQUIRY_STATUS S_ENQUIRY_STATUS
, ES.CLOSED_IND CLOSED_IND
, LKUP.MEANING MEANING
, LKUP.CLOSED_IND DSP_CLOSED_IND
, ES.CREATED_BY CREATED_BY
, ES.CREATION_DATE CREATION_DATE
, ES.LAST_UPDATED_BY LAST_UPDATED_BY
, ES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_IN_ENQ_STATUS ES
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_TYPE = 'ENQUIRY_STATUS'
AND LKUP.LOOKUP_CODE = ES.S_ENQUIRY_STATUS

Columns