[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
ICX.ICX_POR_CATEGORY_DATA_SOURCES does not reference any database object
ICX.ICX_POR_CATEGORY_DATA_SOURCES is referenced by following:
|
|
|