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


TABLE: JTF.JTF_TASK_PURGE

Object Details
Object Name: JTF_TASK_PURGE
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_TASK_PURGE
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_TASK_PURGE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_ID
JTF_TASK_PURGE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONCURRENT_REQUEST_ID
ColumnWORKER_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (80) Yes
OBJECT_ID NUMBER (15) Yes
CONCURRENT_REQUEST_ID NUMBER

WORKER_ID NUMBER

PROCESS_FLAG VARCHAR2 (1)
PURGE_STATUS VARCHAR2 (1)
PURGE_ERROR_MESSAGE VARCHAR2 (4000)
Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_ID
,      CONCURRENT_REQUEST_ID
,      WORKER_ID
,      PROCESS_FLAG
,      PURGE_STATUS
,      PURGE_ERROR_MESSAGE
FROM JTF.JTF_TASK_PURGE;

Dependencies

[top of page]

JTF.JTF_TASK_PURGE does not reference any database object

JTF.JTF_TASK_PURGE is referenced by following:

SchemaAPPS
SynonymJTF_TASK_PURGE