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

TABLE: ICX.ICX_POR_THIRD_PARTY_LOGS

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


Table that stores historical data of Third Party Content Provider activity on Suppliers' catalogs.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes Log ID
THIRD_PARTY_ID NUMBER
Yes Third Party Content Provider ID
THIRD_PARTY_NAME VARCHAR2 (255) Yes Third Party Content Provider Name
THIRD_PARTY_USER_ID NUMBER
Yes Third Party Content Provider User ID
SUPPLIER_ID NUMBER
Yes Supplier ID
SUPPLIER_NAME VARCHAR2 (255) Yes Supplier Name
ACTION VARCHAR2 (30) Yes Action performed on the Item or Price
ITEM_ID NUMBER
Yes Item ID
ITEM_NUMBER VARCHAR2 (200)
Supplier Item Number
ITEM_DESCRIPTION VARCHAR2 (2000)
Item Description
PRICE_LIST_ID NUMBER
Yes Price List ID
PRICE_LIST_NAME VARCHAR2 (90)
Price List Name
LANGUAGE VARCHAR2 (255) Yes Language
LOG_DATE DATE
Yes Log Date
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
,      THIRD_PARTY_ID
,      THIRD_PARTY_NAME
,      THIRD_PARTY_USER_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      ACTION
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      PRICE_LIST_ID
,      PRICE_LIST_NAME
,      LANGUAGE
,      LOG_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_THIRD_PARTY_LOGS;

Dependencies

[top of page]

ICX.ICX_POR_THIRD_PARTY_LOGS does not reference any database object

ICX.ICX_POR_THIRD_PARTY_LOGS is referenced by following:

SchemaICX
ViewICX_POR_THIRD_PARTY_LOGS#