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


TABLE: APPLSYS.FND_OBJECT_DEFINITIONS

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000455650C00017$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000455650C00019$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
OBJECT_DEFINITION_ID NUMBER
Yes
APPLICATION_ID NUMBER
Yes
OBJECT_ID NUMBER
Yes
OBJECT_DEFINITION_TYPE VARCHAR2 (30) Yes
OBJECT_VERSION VARCHAR2 (80) Yes
OBJECT_EXTENSION_VERSION VARCHAR2 (80)
STATUS VARCHAR2 (1) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
START_DATE_ACTIVE DATE
Yes
END_DATE_ACTIVE DATE

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
OBJECT_DEFINITION XMLTYPE (2000)
OBJECT_REFERENCE XMLTYPE (2000)
Query Text

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


SELECT OBJECT_DEFINITION_ID
,      APPLICATION_ID
,      OBJECT_ID
,      OBJECT_DEFINITION_TYPE
,      OBJECT_VERSION
,      OBJECT_EXTENSION_VERSION
,      STATUS
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_DEFINITION
,      OBJECT_REFERENCE
FROM APPLSYS.FND_OBJECT_DEFINITIONS;

Dependencies

[top of page]

APPLSYS.FND_OBJECT_DEFINITIONS references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
APPLSYS.FND_OBJECT_DEFINITIONS is referenced by following:

SchemaAPPS
SynonymFND_OBJECT_DEFINITIONS