[Home] [Help]
VIEW: APPS.ICX_POR_REALMS_VL
Source
View Text - Preformatted
SELECT IPR.REALM_ID, IPR.AK_ATTRIBUTE_CODE, IPRT.REALM_NAME, IPRT.REALM_DESCRIPTION FROM ICX_POR_REALMS IPR, ICX_POR_REALMS_TL IPRT WHERE IPR.REALM_ID = IPRT.REALM_ID AND IPRT.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted
SELECT IPR.REALM_ID
, IPR.AK_ATTRIBUTE_CODE
, IPRT.REALM_NAME
, IPRT.REALM_DESCRIPTION
FROM ICX_POR_REALMS IPR
, ICX_POR_REALMS_TL IPRT
WHERE IPR.REALM_ID = IPRT.REALM_ID
AND IPRT.LANGUAGE = USERENV('LANG')