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

TABLE: ICX.ICX_POR_CATEGORY_ORDER_MAP

Object Details
Object Name: ICX_POR_CATEGORY_ORDER_MAP
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_CATEGORY_ORDER_MAP
Subobject Name:
Status: VALID


Mapping of internal categories to external categories, for example maps BugsEye categories to item categories in the Oracle Purchasing category set. This table is necessary because Oracle Purchasing requires an item category on the requisition and PO line. When an item is selected from the catalog, this table is used to determine which PO item category to use on the requisition.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_POR_CATEGORY_ORDER__MAP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRT_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
RT_CATEGORY_ID NUMBER
Yes Category name
EXTERNAL_SOURCE VARCHAR2 (2000)
//Oracle template, Oracle category or Oracle catalog group??
EXTERNAL_SOURCE_KEY VARCHAR2 (2000)
//category_id, catalog_group_id, or template_name??
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
Query Text

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


SELECT RT_CATEGORY_ID
,      EXTERNAL_SOURCE
,      EXTERNAL_SOURCE_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_CATEGORY_ORDER_MAP;

Dependencies

[top of page]

ICX.ICX_POR_CATEGORY_ORDER_MAP does not reference any database object

ICX.ICX_POR_CATEGORY_ORDER_MAP is referenced by following:

SchemaICX
ViewICX_POR_CATEGORY_ORDER_MAP#