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


TABLE: APPLSYS.FND_OAM_DSCFG_OBJECTS

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

This table holds the Data Scrambling Intermediate Configuration Object objects. Each operation to be performed by the engine is stored as an object with one or more properties defining the type and parameters of that operation.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OAM_DSCFG_OBJECTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
FND_OAM_DSCFG_OBJECTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_INSTANCE_ID
ColumnSOURCE_PROC_ID
ColumnSOURCE_TYPE
ColumnSOURCE_ID
FND_OAM_DSCFG_OBJECTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_INSTANCE_ID
ColumnOBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER (15) Yes
CONFIG_INSTANCE_ID NUMBER (15) Yes
OBJECT_TYPE VARCHAR2 (30) Yes
PARENT_OBJECT_ID NUMBER (15)
SOURCE_PROC_ID NUMBER (15)
SOURCE_TYPE VARCHAR2 (30)
SOURCE_ID NUMBER (15)
TARGET_TYPE VARCHAR2 (30)
TARGET_ID NUMBER (15)
ERRORS_FOUND_FLAG VARCHAR2 (3)
MESSAGE VARCHAR2 (4000)
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 OBJECT_ID
,      CONFIG_INSTANCE_ID
,      OBJECT_TYPE
,      PARENT_OBJECT_ID
,      SOURCE_PROC_ID
,      SOURCE_TYPE
,      SOURCE_ID
,      TARGET_TYPE
,      TARGET_ID
,      ERRORS_FOUND_FLAG
,      MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_OAM_DSCFG_OBJECTS;

Dependencies

[top of page]

APPLSYS.FND_OAM_DSCFG_OBJECTS does not reference any database object

APPLSYS.FND_OAM_DSCFG_OBJECTS is referenced by following:

SchemaAPPS
SynonymFND_OAM_DSCFG_OBJECTS