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#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
RT_ITEM_ID	NUMBER		Yes
ORC_ITEM_ID	NUMBER
ORC_ITEM_NUM	VARCHAR2	(700)
TITLE	VARCHAR2	(500)
TYPE	NUMBER
A1	VARCHAR2	(700)
A2	VARCHAR2	(700)
A3	VARCHAR2	(700)
A4	VARCHAR2	(700)
A5	VARCHAR2	(700)
A10	NUMBER
A11	VARCHAR2	(700)
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
SUPPLIER_ID	NUMBER
BATCH_JOB_NUM	NUMBER
QUERY	VARCHAR2	(240)
A12	VARCHAR2	(700)
A13	VARCHAR2	(700)
A14	VARCHAR2	(700)
A15	VARCHAR2	(700)
A16	VARCHAR2	(700)
A17	VARCHAR2	(700)
A18	VARCHAR2	(700)
A19	VARCHAR2	(700)
A20	VARCHAR2	(700)
A21	VARCHAR2	(700)
A22	VARCHAR2	(700)
A24	VARCHAR2	(700)
A25	VARCHAR2	(700)
A26	NUMBER
A27	VARCHAR2	(700)
A28	VARCHAR2	(700)
A29	VARCHAR2	(700)
A30	VARCHAR2	(700)
A31	VARCHAR2	(700)
A32	NUMBER
A33	VARCHAR2	(700)
A34	VARCHAR2	(700)
A35	VARCHAR2	(700)
A36	VARCHAR2	(700)
ACTION	VARCHAR2	(30)
STATUS	VARCHAR2	(30)
ITEM_SOURCE_TYPE	VARCHAR2	(8)
SEARCH_TYPE	VARCHAR2	(8)

Query Text

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


SELECT RT_ITEM_ID
,      ORC_ITEM_ID
,      ORC_ITEM_NUM
,      TITLE
,      TYPE
,      A1
,      A2
,      A3
,      A4
,      A5
,      A10
,      A11
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUPPLIER_ID
,      BATCH_JOB_NUM
,      QUERY
,      A12
,      A13
,      A14
,      A15
,      A16
,      A17
,      A18
,      A19
,      A20
,      A21
,      A22
,      A24
,      A25
,      A26
,      A27
,      A28
,      A29
,      A30
,      A31
,      A32
,      A33
,      A34
,      A35
,      A36
,      ACTION
,      STATUS
,      ITEM_SOURCE_TYPE
,      SEARCH_TYPE
FROM ICX.ICX_POR_ITEMS#;

Dependencies

[top of page]

ICX.ICX_POR_ITEMS# references the following:

ICX: ICX_POR_ITEMS

ICX.ICX_POR_ITEMS# is referenced by following:

APPS: ICX_POR_ITEMS