[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_SEARCHABLE_CHANGE_LOG

Object Details

Object Name:	FND_SEARCHABLE_CHANGE_LOG
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_SEARCHABLE_CHANGE_LOG
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_SEARCHABLE_CHANGE_ID_IDX	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_INSTANCE_ID
FND_SEARCHABLE_CHANGE_IDX	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_NAME CHANGE_TYPE CRAWL_STATUS

Columns

Query Text

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

SELECT EVENT_INSTANCE_ID
,      OBJECT_NAME
,      CHANGE_TYPE
,      ID_TYPE
,      ROW_FROM
,      ROW_TO
,      PK_NAME_1
,      PK_VALUE_1
,      PK_NAME_2
,      PK_VALUE_2
,      PK_NAME_3
,      PK_VALUE_3
,      PK_NAME_4
,      PK_VALUE_4
,      PK_NAME_5
,      PK_VALUE_5
,      CRAWL_STATUS
,      DATA_FEED_URL
,      CHANGE_DATE
FROM APPLSYS.FND_SEARCHABLE_CHANGE_LOG;

Dependencies

[top of page]

APPLSYS.FND_SEARCHABLE_CHANGE_LOG does not reference any database object

APPLSYS.FND_SEARCHABLE_CHANGE_LOG is referenced by following:

APPS

FND_SEARCHABLE_CHANGE_LOG