eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_PAGES_VL

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.ICX_PAGES_VL

View Text

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')

Columns

Name
PAGE_ID
PAGE_CODE
REFRESH_RATE
SEQUENCE_NUMBER
PAGE_TYPE
MAIN_REGION_ID
USER_ID
RESPONSIBILITY_ID
PAGE_NAME
PAGE_DESCRIPTION