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_CATEGORY_DATA_SOURCES

Object Details

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

This table stores a list of external category data sources like Requisition Templates and item categories from Oracle.
This is updated during Catalog loading. It is also updated by the Category Merger admin utility.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_CATEGORY_DATA_SRCS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXTERNAL_SOURCE EXTERNAL_SOURCE_KEY
ICX_POR_CATEGORY_DATA_SRCS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY_KEY	VARCHAR2	(250)	Yes	We load the primary key of the category in the originating system
EXTERNAL_SOURCE	VARCHAR2	(250)		Original system data source/publishing entity. Set to Oracle for Oracle-source data.
EXTERNAL_SOURCE_KEY	VARCHAR2	(250)		This is the primary key of the category in the orginating system
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			Request unique identifier
PROGRAM_APPLICATION_ID	NUMBER			Program application unique identifier
PROGRAM_ID	NUMBER			Program unique identifier
PROGRAM_UPDATE_DATE	DATE			Program update date
RT_CATEGORY_ID	NUMBER			The iP Category ID

Query Text

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


SELECT CATEGORY_KEY
,      EXTERNAL_SOURCE
,      EXTERNAL_SOURCE_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RT_CATEGORY_ID
FROM ICX.ICX_POR_CATEGORY_DATA_SOURCES;

Dependencies

[top of page]

ICX.ICX_POR_CATEGORY_DATA_SOURCES does not reference any database object

ICX.ICX_POR_CATEGORY_DATA_SOURCES is referenced by following:

ICX: ICX_POR_CATEGORY_DATA_SOURCES#