[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_OBJECTS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.FND_OBJECTS
|
| Subobject Name: | |
| Status: | VALID |
Objects of data elements that can be secured in data security grants
Initially an object is a database table or view.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FND_OBJECTS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 OBJECT_ID
|
| FND_OBJECTS_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
OBJ_NAME
|
| SYS_IL0000132946C00032$$ | LOB | UNIQUE |
APPS_TS_SEED
|
|
| SYS_IL0000132946C00033$$ | LOB | UNIQUE |
APPS_TS_SEED
|
|
| FND_OBJECTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
IREP_PRODUCT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OBJECT_ID | NUMBER | (15) | Yes | PK Object ID |
| OBJ_NAME | VARCHAR2 | (430) | Yes | UK Table or View name |
| APPLICATION_ID | NUMBER | (15) | Yes | Application ID (Not in PK) |
| DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | name of database table |
| PK1_COLUMN_NAME | VARCHAR2 | (30) | Yes | Name of column 1 in object PK. Most selective columns first. |
| PK2_COLUMN_NAME | VARCHAR2 | (30) | Name of column 2 in object PK. | |
| PK3_COLUMN_NAME | VARCHAR2 | (30) | Name of column 3 in object PK. | |
| PK4_COLUMN_NAME | VARCHAR2 | (30) | Name of column 4 in object PK. | |
| PK5_COLUMN_NAME | VARCHAR2 | (30) | Name of column 5 in object PK. | |
| PK1_COLUMN_TYPE | VARCHAR2 | (8) | Yes | Data type of column 1: VARCHAR2, INTEGER, FLOAT, or DATE. |
| PK2_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 2: VARCHAR2, INTEGER, FLOAT, or DATE | |
| PK3_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 3: VARCHAR2, INTEGER, FLOAT, or DATE | |
| PK4_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 4: VARCHAR2, INTEGER, FLOAT, or DATE | |
| PK5_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 5: VARCHAR2, INTEGER, FLOAT, or DATE. | |
| CREATED_BY | NUMBER | (15) | Yes | CREATED_BY |
| CREATION_DATE | DATE | Yes | CREATED_DATE | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | LAST_UPDATED_BY |
| LAST_UPDATE_DATE | DATE | Yes | LAST_UPDATED_DATE | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | LAST_UPDATED_LOGIN |
| IREP_NAME | VARCHAR2 | (400) | Name (possibly non-unique) name of base object (used by irep). | |
| IREP_OBJECT_TYPE | VARCHAR2 | (30) | Technology type | |
| IREP_PRODUCT | VARCHAR2 | (8) | Product that owns interface | |
| LOAD_ERR | VARCHAR2 | (1) | Loading Error Flag | |
| LOAD_ERR_MSGS | VARCHAR2 | (4000) | Loading Error Buffer | |
| IREP_COMPATIBILITY | VARCHAR2 | (1) | Compatability Flag | |
| IREP_SCOPE | VARCHAR2 | (30) | Scope | |
| IREP_LIFECYCLE | VARCHAR2 | (30) | Lifecycle | |
| IREP_SOURCE_FILE_PRODUCT | VARCHAR2 | (8) | Product for Source File | |
| IREP_SOURCE_FILE_PATH | VARCHAR2 | (100) | Path for Source File | |
| IREP_SOURCE_FILE_NAME | VARCHAR2 | (36) | Source File Name | |
| IREP_SOURCE_FILE_VERSION | VARCHAR2 | (150) | Version of Source File | |
| IREP_DESCRIPTION | CLOB | (4000) | Description | |
| IREP_XML_DESCRIPTION | CLOB | (4000) | Schema | |
| IREP_STANDARD | VARCHAR2 | (30) | Standard Type | |
| IREP_STANDARD_VERSION | VARCHAR2 | (30) | Version of Standard | |
| IREP_STANDARD_SPEC | VARCHAR2 | (240) | Specification for Standard | |
| OPEN_INTERFACE_FLAG | VARCHAR2 | (1) | Open Interface Flag | |
| IREP_LDR_PP_FLAG | VARCHAR2 | (1) | Loader Post Processing Flag | |
| IREP_HIDE_SCHEMA | VARCHAR2 | (1) | Flag for Hide Schema | |
| IREP_DEF_CLASS | VARCHAR2 | (400) | Default Class | |
| IREP_CLASS_NAME | VARCHAR2 | (400) | Class Name | |
| IREP_FILTER_REQUIRED | VARCHAR2 | (1) | Filter Required Flag | |
| IREP_IS_FILTER | VARCHAR2 | (1) | Filter Flag | |
| IREP_IS_EXPRESSION | VARCHAR2 | (1) | Expression Flag | |
| IREP_LDR_INTERNAL_FLAG | VARCHAR2 | (1) | Used internally by the iRep loader | |
| CRAWL_CRAWLABLE | VARCHAR2 | (1) | Is this object to be crawled | |
| CRAWL_VISIBILITY_LEVEL | VARCHAR2 | (8) | Determine the visability of this Object (GLOBAL,GUEST,GROUP,USER) | |
| CRAWL_SEARCH_PLUGIN | VARCHAR2 | (4000) | Java class to implement the getACL and getSecurityKey | |
| CRAWL_UI_FUNCTION | VARCHAR2 | (240) | FND Form Function to construct linking url | |
| CRAWL_CHANGE_EVENT_NAME | VARCHAR2 | (4000) | Event name for event base change | |
| CRAWL_CHANGE_NOTIFICATION | VARCHAR2 | (1) | Y/N to indicate if we need to use the driving table as change notification | |
| CRAWL_DRIVING_TABLE | VARCHAR2 | (30) | Name for driving table | |
| CRAWL_SEARCHID | VARCHAR2 | (240) | Search engine identifier | |
| CRAWL_LASTCRAWLED | DATE | Useful for incremental |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, OBJ_NAME
, APPLICATION_ID
, DATABASE_OBJECT_NAME
, PK1_COLUMN_NAME
, PK2_COLUMN_NAME
, PK3_COLUMN_NAME
, PK4_COLUMN_NAME
, PK5_COLUMN_NAME
, PK1_COLUMN_TYPE
, PK2_COLUMN_TYPE
, PK3_COLUMN_TYPE
, PK4_COLUMN_TYPE
, PK5_COLUMN_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IREP_NAME
, IREP_OBJECT_TYPE
, IREP_PRODUCT
, LOAD_ERR
, LOAD_ERR_MSGS
, IREP_COMPATIBILITY
, IREP_SCOPE
, IREP_LIFECYCLE
, IREP_SOURCE_FILE_PRODUCT
, IREP_SOURCE_FILE_PATH
, IREP_SOURCE_FILE_NAME
, IREP_SOURCE_FILE_VERSION
, IREP_DESCRIPTION
, IREP_XML_DESCRIPTION
, IREP_STANDARD
, IREP_STANDARD_VERSION
, IREP_STANDARD_SPEC
, OPEN_INTERFACE_FLAG
, IREP_LDR_PP_FLAG
, IREP_HIDE_SCHEMA
, IREP_DEF_CLASS
, IREP_CLASS_NAME
, IREP_FILTER_REQUIRED
, IREP_IS_FILTER
, IREP_IS_EXPRESSION
, IREP_LDR_INTERNAL_FLAG
, CRAWL_CRAWLABLE
, CRAWL_VISIBILITY_LEVEL
, CRAWL_SEARCH_PLUGIN
, CRAWL_UI_FUNCTION
, CRAWL_CHANGE_EVENT_NAME
, CRAWL_CHANGE_NOTIFICATION
, CRAWL_DRIVING_TABLE
, CRAWL_SEARCHID
, CRAWL_LASTCRAWLED
FROM APPLSYS.FND_OBJECTS;
APPLSYS.FND_OBJECTS does not reference any database object
APPLSYS.FND_OBJECTS is referenced by following:
APPS
AMW_OPINION_LOG_MV
AMW_OPINION_MV
ENI_DBI_CO_OBJIDS_MV
FND_OBJECTS
|
|
|
|