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

TABLE: ICX.ICX_POR_THIRD_PARTY_LOG_VALUES

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


Table to store detail log information of the Third Party Authoring changes performed on behalf of Suppliers for Items and Prices.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes Log ID
DESCRIPTOR_KEY VARCHAR2 (250) Yes Descriptor Key for the descriptor which was updated
OLD_VALUE VARCHAR2 (2000)
Value stored in the descriptor/attribute prior to the update.
NEW_VALUE VARCHAR2 (2000)
Value stored in the descriptor/attribute after the update.
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 LOG_ID
,      DESCRIPTOR_KEY
,      OLD_VALUE
,      NEW_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_THIRD_PARTY_LOG_VALUES;

Dependencies

[top of page]

ICX.ICX_POR_THIRD_PARTY_LOG_VALUES does not reference any database object

ICX.ICX_POR_THIRD_PARTY_LOG_VALUES is referenced by following:

SchemaAPPS
SynonymICX_POR_THIRD_PARTY_LOG_VALUES