DBA Data[Home] [Help]

VIEW: APPS.ICX_PAGES_VL

Source

View Text - Preformatted

SELECT ip.page_id, ip.page_code, ip.refresh_rate, ip.sequence_number, ip.page_type, ip.main_region_id, ip.user_id, ip.responsibility_id, ipt.page_name, ipt.page_description FROM icx_pages ip, icx_pages_tl ipt WHERE ip.page_id = ipt.page_id AND ipt.language = userenv('LANG')
View Text - HTML Formatted

SELECT IP.PAGE_ID
, IP.PAGE_CODE
, IP.REFRESH_RATE
, IP.SEQUENCE_NUMBER
, IP.PAGE_TYPE
, IP.MAIN_REGION_ID
, IP.USER_ID
, IP.RESPONSIBILITY_ID
, IPT.PAGE_NAME
, IPT.PAGE_DESCRIPTION
FROM ICX_PAGES IP
, ICX_PAGES_TL IPT
WHERE IP.PAGE_ID = IPT.PAGE_ID
AND IPT.LANGUAGE = USERENV('LANG')