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


TABLE: PJI.PJI_HELPER_420

Object Details
Object Name: PJI_HELPER_420
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_HELPER_420
Subobject Name:
Status: VALID

This is an temporary table that is used
to spawn helper batches for step 420. This is a persistent table.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_HELPER_420_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnWORKER_ID
ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

BATCH_ID NUMBER

WORKER_ID NUMBER

LEVEL_420 VARCHAR2 (30)
PARTIAL_MODE_420 VARCHAR2 (30)
FPM_UPGRADE_420 VARCHAR2 (30)
Query Text

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


SELECT PROJECT_ID
,      BATCH_ID
,      WORKER_ID
,      LEVEL_420
,      PARTIAL_MODE_420
,      FPM_UPGRADE_420
FROM PJI.PJI_HELPER_420;

Dependencies

[top of page]

PJI.PJI_HELPER_420 does not reference any database object

PJI.PJI_HELPER_420 is referenced by following:

SchemaPJI
ViewPJI_HELPER_420#