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_CAT_R12_UPGRADE

Object Details

Object Name:	ICX_CAT_R12_UPGRADE
Object Type:	TABLE
Owner:	ICX
Subobject Name:
Status:	VALID

This table is used in R12 upgrade to keep track of:
- Bulkloaded items that are upgraded to po schema
- Favorite list lines upgrade
- Base and Local attributes upgrade to po schema

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_R12_UPGRADE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RT_ITEM_ID SUPPLIER_SITE_ID CURRENCY PRICE_CONTRACT_ID
ICX_CAT_R12_UPGRADE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_INTERFACE_HEADER_ID
ICX_CAT_R12_UPGRADE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_INTERFACE_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUPPLIER_SITE_ID	NUMBER		Yes	Supplier_site_id
CURRENCY	VARCHAR2	(15)	Yes	Currency of the item
PRICE_CONTRACT_ID	NUMBER		Yes	Contract_id of the item from icx_cat_item_prices.
SRC_CONTRACT_ID	NUMBER		Yes	Contract_id, the item was sourced from, during r12 upgrade
CPA_REFERENCE	NUMBER		Yes	Cpa reference the item is created in po data model
PO_CATEGORY_ID	VARCHAR2	(2000)	Yes	Po_category_id of the item in the catalog.
RT_ITEM_ID	NUMBER		Yes	Rt_item_id used to identify the item in the catalog
PO_INTERFACE_HEADER_ID	NUMBER			Interface header id from po_headers_interface
PO_INTERFACE_LINE_ID	NUMBER			Interface line id from po_lines_interface
PO_HEADER_ID	NUMBER			PO Header Id
CREATED_LANGUAGE	VARCHAR2	(4)		Created Language of the GBPA Header
PO_LINE_ID	NUMBER			PO Line Id
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
REQUEST_ID	NUMBER			Standard Concurrent Request Column
INTERNAL_REQUEST_ID	NUMBER			Internal_request_id to track the changes done in a job. Different from request_id, because source of the items may not always be concurrent jobs.
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Request Column
PROGRAM_ID	NUMBER			Standard Concurrent Request Column
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Request Column

Query Text

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


SELECT SUPPLIER_SITE_ID
,      CURRENCY
,      PRICE_CONTRACT_ID
,      SRC_CONTRACT_ID
,      CPA_REFERENCE
,      PO_CATEGORY_ID
,      RT_ITEM_ID
,      PO_INTERFACE_HEADER_ID
,      PO_INTERFACE_LINE_ID
,      PO_HEADER_ID
,      CREATED_LANGUAGE
,      PO_LINE_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      INTERNAL_REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ICX.ICX_CAT_R12_UPGRADE;

Dependencies

[top of page]

ICX.ICX_CAT_R12_UPGRADE does not reference any database object

ICX.ICX_CAT_R12_UPGRADE is referenced by following:

ICX: ICX_CAT_R12_UPGRADE#