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.

[Home] [Help]

Table: ICX_PO_REVISIONS_TEMP

Product:	ICX - Oracle iProcurement
Description:	Comparison results of two revisions of a PO
Implementation/DBA Data:	ICX.ICX_PO_REVISIONS_TEMP

Primary Key: ICX_PO_REVISIONS_TEMP_PK1

LINE_SEQ
REVISION_NUM
HEADER_ID
RELEASE_ID
LINE_ID
LOCATION_ID
DISTRIBUTION_ID
LEVEL_ALTERED
FIELD_ALTERED

Foreign Keys

Table	Foreign Table	Foreign Key Column
ICX_PO_REVISIONS_TEMP	PO_HEADERS_ARCHIVE_ALL	ICX_PO_REVISIONS_TEMP.HEADER_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM
ICX_PO_REVISIONS_TEMP	PO_RELEASES_ARCHIVE_ALL	ICX_PO_REVISIONS_TEMP.RELEASE_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM
ICX_PO_REVISIONS_TEMP	PO_DISTRIBUTIONS_ARCHIVE_ALL	ICX_PO_REVISIONS_TEMP.DISTRIBUTION_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM
ICX_PO_REVISIONS_TEMP	PO_LINE_LOCATIONS_ARCHIVE_ALL	ICX_PO_REVISIONS_TEMP.LOCATION_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM
ICX_PO_REVISIONS_TEMP	PO_LINES_ARCHIVE_ALL	ICX_PO_REVISIONS_TEMP.LINE_ID ICX_PO_REVISIONS_TEMP.REVISION_NUM