[Home] [Help]
[Dependency Information]
| Object Name: | FND_OBJECT_DEFINITIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: | FND.FND_OBJECT_DEFINITIONS
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| SYS_IL0000455650C00017$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| SYS_IL0000455650C00019$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
| 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) |
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;
SYS
STANDARD
- show dependent code
XMLTYPE
APPS
FND_OBJECT_DEFINITIONS
|
|
|
|