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

TABLE: APPLSYS.FND_OAM_DSCRAM_BUNDLES

Object Details
Object Name: FND_OAM_DSCRAM_BUNDLES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_OAM_DSCRAM_BUNDLES
Subobject Name:
Status: VALID

This table holds the Data Scrambling Engine Bundle object. Each engine run is composed of one or more bundles which identify a set of tasks which belong to a specific host participating in the execution of the run.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OAM_DSCRAM_BUNDLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUNDLE_ID
FND_OAM_DSCRAM_BUNDLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_ID
Columns
Name Datatype Length Mandatory Comments
BUNDLE_ID NUMBER (15) Yes
RUN_ID NUMBER (15) Yes
BUNDLE_STATUS VARCHAR2 (30) Yes
TARGET_HOSTNAME VARCHAR2 (256)
WEIGHT NUMBER

WORKERS_ALLOWED NUMBER (15) Yes
WORKERS_ASSIGNED NUMBER (15) Yes
BATCH_SIZE NUMBER (15) Yes
MIN_PARALLEL_UNIT_WEIGHT NUMBER

STATS_FINISHED VARCHAR2 (3)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
Query Text

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


SELECT BUNDLE_ID
,      RUN_ID
,      BUNDLE_STATUS
,      TARGET_HOSTNAME
,      WEIGHT
,      WORKERS_ALLOWED
,      WORKERS_ASSIGNED
,      BATCH_SIZE
,      MIN_PARALLEL_UNIT_WEIGHT
,      STATS_FINISHED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_OAM_DSCRAM_BUNDLES;

Dependencies

[top of page]

APPLSYS.FND_OAM_DSCRAM_BUNDLES does not reference any database object

APPLSYS.FND_OAM_DSCRAM_BUNDLES is referenced by following:

SchemaAPPS
SynonymFND_OAM_DSCRAM_BUNDLES