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_PO_REVISIONS_TEMP

Object Details

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

ICX_PO_REVISIONS_TEMP contains comparison results of two different
revisions of a specific purchase order. Every row contains the name
of the altered field, the previous value, and the new value, in
addition to relevant information about the purchase order, such as
HEADER_ID, LINE_ID. The results are grouped for each compared pair by
a sequence number, LINE_SEQ.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_PO_REVISIONS_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	LINE_SEQ
ICX_PO_REVISIONS_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	LEVEL_ALTERED

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_SEQ	NUMBER		Yes	Unique identifier for comparison results of two PO revisions
CREATION_DATE	DATE		Yes	Time stamp of the comparison
HEADER_ID	NUMBER		Yes	Unique identifier of the corresponding PO headers record
RELEASE_ID	NUMBER			Unique identifier of the corresponding PO release record
LINE_ID	NUMBER			Unique identifier of the corresponding PO line record
LOCATION_ID	NUMBER			Unique identifier of the corresponding PO line location record
DISTRIBUTION_ID	NUMBER			Unique identifier of the corresponding PO distribution record
ITEM_ID	NUMBER			Unique identifier for the corresponding line item record
PO_NUM	VARCHAR2	(80)		PO number
REVISION_NUM	NUMBER		Yes	Revision number for the PO
LINE_NUM	NUMBER			Corresponding PO line number
LOCATION_NUM	NUMBER			Location number of the corresponding PO line
DISTRIBUTION_NUM	NUMBER			Distribution number of the corresponding PO line
LEVEL_ALTERED	VARCHAR2	(40)	Yes	Level alteration. Possible values are for header, line, location, or distribution.
FIELD_ALTERED	VARCHAR2	(40)	Yes	Field alteration, such as quantity, amount, or promised date
CHANGES_FROM	VARCHAR2	(2000)		Old value of the altered field
CHANGES_TO	VARCHAR2	(2000)		New value of the altered field
ENABLED_ORG_NAME	VARCHAR2	(240)		Enabled Organization name

Query Text

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


SELECT LINE_SEQ
,      CREATION_DATE
,      HEADER_ID
,      RELEASE_ID
,      LINE_ID
,      LOCATION_ID
,      DISTRIBUTION_ID
,      ITEM_ID
,      PO_NUM
,      REVISION_NUM
,      LINE_NUM
,      LOCATION_NUM
,      DISTRIBUTION_NUM
,      LEVEL_ALTERED
,      FIELD_ALTERED
,      CHANGES_FROM
,      CHANGES_TO
,      ENABLED_ORG_NAME
FROM ICX.ICX_PO_REVISIONS_TEMP;

Dependencies

[top of page]

ICX.ICX_PO_REVISIONS_TEMP does not reference any database object

ICX.ICX_PO_REVISIONS_TEMP is referenced by following:

APPS: ICX_PO_REVISIONS_TEMP