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]

TABLE: ICX.ICX_POR_ITEMS

Object Details

Object Name:	ICX_POR_ITEMS
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_POR_ITEMS
Subobject Name:
Status:	VALID

Stores information and root descriptors for non translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may be generated through the use of the application.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	RT_ITEM_ID STATUS
ICX_POR_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORC_ITEM_ID
ICX_POR_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	A3
ICX_POR_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SUPPLIER_ID
ICX_POR_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	STATUS
ICX_POR_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	BATCH_JOB_NUM STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
RT_ITEM_ID	NUMBER		Yes	Internally generated Item identifier
ORC_ITEM_ID	NUMBER			Item unique identifier in Oracle (IP only)
ORC_ITEM_NUM	VARCHAR2	(700)		Item number in Oracle (IP only)
TITLE	VARCHAR2	(500)		ID of the Originating system data source/publishing entity set to 'Oracle' for Oracle-sourced data
TYPE	NUMBER			Not used
A1	VARCHAR2	(700)		Reserved for Supplier name
A2	VARCHAR2	(700)		Reserved for Supplier ID
A3	VARCHAR2	(700)		Reserved for Supplier Item Number
A4	VARCHAR2	(700)		Reserved for Manufactuer (Not used in WR4)
A5	VARCHAR2	(700)		Reserved for Manufactuer Part Number (Not used in WR4)
A10	NUMBER			Not used
A11	VARCHAR2	(700)		Not used
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Extended Who Column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who Column
PROGRAM_ID	NUMBER			Extended Who Column
PROGRAM_UPDATE_DATE	DATE			Extended Who Column
SUPPLIER_ID	NUMBER			Unique identifier for the supplier owning the item.
BATCH_JOB_NUM	NUMBER			Batch job number that created/updated the item
QUERY	VARCHAR2	(240)		Not used
A12	VARCHAR2	(700)		Reserved for Internal Item Number (IP only)
A13	VARCHAR2	(700)		Reserved for Picture or Image file name (PICTURE)
A14	VARCHAR2	(700)		Reserved for Picture or image URL (PICTURE_URL)
A15	VARCHAR2	(700)		Reserved for Contract Number (IP only)
A16	VARCHAR2	(700)		Reserved for Contract Line (IP only)
A17	VARCHAR2	(700)		Reserved for Contract Price (IP only)
A18	VARCHAR2	(700)		Reserved for Contract Currency (IP only)
A19	VARCHAR2	(700)		Reserved for Contract Rate Type (IP only)
A20	VARCHAR2	(700)		Reserved for Contract Rate Date (IP Only)
A21	VARCHAR2	(700)		Reserved for Contract Rate (IP only)
A22	VARCHAR2	(700)		Reserved for attachment URL (ATTACHMENT_URL)
A24	VARCHAR2	(700)		Reserved for UNSPSC code (UNSPSC)
A25	VARCHAR2	(700)		Reserved for Availability
A26	NUMBER			Reserved for order lead time (LEAD_TIME). specified in days
A27	VARCHAR2	(700)		Reserved for Functional Currency Price (IP only)
A28	VARCHAR2	(700)		Reserved for Functional Currency (IP only)
A29	VARCHAR2	(700)		Reserved for item type (ITEM_TYPE)
A30	VARCHAR2	(700)		Reserved for sellable item (SELLABLE_ITEM). Product Development specific attribute. If set to N, the item will not be visible in the standard catalog.
A31	VARCHAR2	(700)		Reserved for development item (DEVELOPMENT_ITEM). Product development specific attribute.
A32	NUMBER			Reserved for Owner Party Id. Product development specific attribute. Should be populated if A31 is Yes.
A33	VARCHAR2	(700)		Reserved for Minimum Inventory Quantity
A34	VARCHAR2	(700)		Reserved for Maximum Inventory Quantity
A35	VARCHAR2	(700)		Reserved for pricing attributes.
A36	VARCHAR2	(700)		Reserved for pricing attributes.
ACTION	VARCHAR2	(30)		Action last taken on the item. Possible values are ADD and UPDATE.
STATUS	VARCHAR2	(30)		Status of the item relative to publication. Possible values are PUBLISHED and UNPUBLISHED.
ITEM_SOURCE_TYPE	VARCHAR2	(8)		Item Source type
SEARCH_TYPE	VARCHAR2	(8)		Search type

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 does not reference any database object

ICX.ICX_POR_ITEMS is referenced by following:

APPS: ICX_POR_ITEMS