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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: ICX.ICX_POR_ITEMS_TL#

Object Details

Object Name:	ICX_POR_ITEMS_TL#
Object Type:	VIEW
Owner:	ICX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RT_ITEM_ID	NUMBER		Yes
LANGUAGE	VARCHAR2	(4)	Yes
SOURCE_LANG	VARCHAR2	(4)	Yes
CTX_DESC	VARCHAR2	(4000)
A6	VARCHAR2	(700)
A7	VARCHAR2	(2000)
A8	VARCHAR2	(700)
A9	VARCHAR2	(700)
CTX_AR	VARCHAR2	(4000)
CTX_CS	VARCHAR2	(4000)
CTX_D	VARCHAR2	(4000)
CTX_DK	VARCHAR2	(4000)
CTX_E	VARCHAR2	(4000)
CTX_EL	VARCHAR2	(4000)
CTX_ESA	VARCHAR2	(4000)
CTX_F	VARCHAR2	(4000)
CTX_FRC	VARCHAR2	(4000)
CTX_GB	VARCHAR2	(4000)
CTX_HU	VARCHAR2	(4000)
CTX_IW	VARCHAR2	(4000)
CTX_JA	VARCHAR2	(4000)
CTX_KO	VARCHAR2	(4000)
CTX_N	VARCHAR2	(4000)
CTX_NL	VARCHAR2	(4000)
CTX_PL	VARCHAR2	(4000)
CTX_PT	VARCHAR2	(4000)
CTX_PTB	VARCHAR2	(4000)
CTX_RO	VARCHAR2	(4000)
CTX_RU	VARCHAR2	(4000)
CTX_S	VARCHAR2	(4000)
CTX_SF	VARCHAR2	(4000)
CTX_SK	VARCHAR2	(4000)
CTX_TH	VARCHAR2	(4000)
CTX_TR	VARCHAR2	(4000)
CTX_US	VARCHAR2	(4000)
CTX_ZHT	VARCHAR2	(4000)
CTX_ZHS	VARCHAR2	(4000)
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
A23	VARCHAR2	(2000)
A30	VARCHAR2	(240)
CTX_BG	VARCHAR2	(4000)
CTX_CA	VARCHAR2	(4000)
CTX_EG	VARCHAR2	(4000)
CTX_HR	VARCHAR2	(4000)
CTX_I	VARCHAR2	(4000)
CTX_IS	VARCHAR2	(4000)
CTX_LT	VARCHAR2	(4000)
CTX_SL	VARCHAR2	(4000)
REBUILD_CTX_JOBNO	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RT_ITEM_ID
,      LANGUAGE
,      SOURCE_LANG
,      CTX_DESC
,      A6
,      A7
,      A8
,      A9
,      CTX_AR
,      CTX_CS
,      CTX_D
,      CTX_DK
,      CTX_E
,      CTX_EL
,      CTX_ESA
,      CTX_F
,      CTX_FRC
,      CTX_GB
,      CTX_HU
,      CTX_IW
,      CTX_JA
,      CTX_KO
,      CTX_N
,      CTX_NL
,      CTX_PL
,      CTX_PT
,      CTX_PTB
,      CTX_RO
,      CTX_RU
,      CTX_S
,      CTX_SF
,      CTX_SK
,      CTX_TH
,      CTX_TR
,      CTX_US
,      CTX_ZHT
,      CTX_ZHS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      A23
,      A30
,      CTX_BG
,      CTX_CA
,      CTX_EG
,      CTX_HR
,      CTX_I
,      CTX_IS
,      CTX_LT
,      CTX_SL
,      REBUILD_CTX_JOBNO
FROM ICX.ICX_POR_ITEMS_TL#;

Dependencies

[top of page]

ICX.ICX_POR_ITEMS_TL# references the following:

ICX: ICX_POR_ITEMS_TL

ICX.ICX_POR_ITEMS_TL# is referenced by following:

APPS: ICX_POR_ITEMS_TL