FND_SEARCH_BULK_BOSS

Details

Name	Datatype	Length	Not-null	Comments
TABLE_NAME	VARCHAR2	30	Yes	Source Table name
PK_COL1_NAME	VARCHAR2	30	Yes	Name of Primary Key Column 1.
PK_COL1_VALUE	VARCHAR2	4000	Yes	Value of Primary Key Column 1.
PK_COL2_NAME	VARCHAR2	30		Name of Primary Key Column 2 if available.
PK_COL2_VALUE	VARCHAR2	4000		Value of Primary Key Column 2.
PK_COL3_NAME	VARCHAR2	30		Name of Primary Key Column 3 if available.
PK_COL3_VALUE	VARCHAR2	4000		Value of Primary Key Column 3.
PK_COL4_NAME	VARCHAR2	30		Name of Primary Key Column 4 if available.
PK_COL4_VALUE	VARCHAR2	4000		Value of Primary Key Column 4.
PK_COL5_NAME	VARCHAR2	30		Name of Primary Key Column 5 if available.
PK_COL5_VALUE	VARCHAR2	4000		Value of Primary Key Column 5.
OPERATION	VARCHAR2	20	Yes	Operation. Values allowed are INSERT,UPDATE,DELETE.
STATUS	VARCHAR2	20		Status of the record
UPDATED_TIME	TIMESTAMP			Updated time of the record in the source table.
SOURCE_LANGUAGE	VARCHAR2	10		Source language code.
CREATION_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32		Who column: indicates the session login associated to the user who last updated the row.

Index	Uniqueness	Tablespace	Columns
FND_SEARCH_BULK_BOSS_SYNC_N1	Non Unique	Default	TABLE_NAME, LAST_UPDATE_DATE