DBA Data[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')