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.

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

TABLE: JTF.JTF_IH_BULK_RECOVERY

Object Details

Object Name:	JTF_IH_BULK_RECOVERY
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_IH_BULK_RECOVERY
Subobject Name:
Status:	VALID

Interaction History Bilk Recovery Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000328633C00008$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
RECOVERY_ID	NUMBER		Yes	Recovery Identifier
REQUEST_ID	NUMBER		Yes	Request Identifier
MSG_ID	RAW	(16)	Yes	Message Identifier
BULK_WRITER_CODE	VARCHAR2	(240)		Bulk Writer Code
BULK_BATCH_TYPE	VARCHAR2	(240)		Bulk Batch Type
BULK_BATCH_ID	NUMBER			Bulk Batch Identifier
BULK_INTERACTION_ID	NUMBER			Bulk Interaction Identifier
BULK_INTERACTION_REQUEST	CLOB	(4000)		Bulk Interaction Request column
NUM_INT_PROCESSED	NUMBER			Number of process
CREATION_DATE	DATE		Yes	Creation Date required field
CREATED_BY	NUMBER	(15)	Yes	Creation By required field
LAST_UPDATE_DATE	DATE		Yes	Last Update Date required field
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who updated required field
LAST_UPDATE_LOGIN	NUMBER	(15)		Who updated required field
PROGRAM_APPLICATION_ID	NUMBER			The Program Application Identifier
PROGRAM_ID	NUMBER			Program Identifier
PROGRAM_UPDATE_DATE	DATE			Program Update Date

Query Text

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


SELECT RECOVERY_ID
,      REQUEST_ID
,      MSG_ID
,      BULK_WRITER_CODE
,      BULK_BATCH_TYPE
,      BULK_BATCH_ID
,      BULK_INTERACTION_ID
,      BULK_INTERACTION_REQUEST
,      NUM_INT_PROCESSED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM JTF.JTF_IH_BULK_RECOVERY;

Dependencies

[top of page]

JTF.JTF_IH_BULK_RECOVERY does not reference any database object

JTF.JTF_IH_BULK_RECOVERY is referenced by following:

JTF: JTF_IH_BULK_RECOVERY#