DBA Data[Home] [Help]

VIEW: APPS.IGS_OR_FUNC_FLTR_V

Source

View Text - Preformatted

SELECT H.ROWID, H.FUNC_FLTR_ID, H.FUNC_CODE, H.ATTR_TYPE, L.MEANING ATTR_TYPE_M, H.ATTR_VAL, H.ATTR_VAL_DESC, H.INST_ORG_VAL, H.CREATED_BY, H.CREATION_DATE, H.LAST_UPDATED_BY, H.LAST_UPDATE_DATE, H.LAST_UPDATE_LOGIN FROM IGS_OR_FUNC_FLTR H, IGS_LOOKUP_VALUES L WHERE H.ATTR_TYPE = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'OR_FTR_ATTR_TYPE'
View Text - HTML Formatted

SELECT H.ROWID
, H.FUNC_FLTR_ID
, H.FUNC_CODE
, H.ATTR_TYPE
, L.MEANING ATTR_TYPE_M
, H.ATTR_VAL
, H.ATTR_VAL_DESC
, H.INST_ORG_VAL
, H.CREATED_BY
, H.CREATION_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_DATE
, H.LAST_UPDATE_LOGIN
FROM IGS_OR_FUNC_FLTR H
, IGS_LOOKUP_VALUES L
WHERE H.ATTR_TYPE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'OR_FTR_ATTR_TYPE'