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

TABLE: APPLSYS.FND_OBJECTS

Object Details
Object Name: FND_OBJECTS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OBJECTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnOBJECT_ID
ColumnZD_EDITION_NAME
FND_OBJECTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnOBJ_NAME
ColumnZD_EDITION_NAME
SYS_IL0000132946C00032$$ LOB UNIQUE TablespaceAPPS_TS_SEED
SYS_IL0000132946C00033$$ LOB UNIQUE TablespaceAPPS_TS_SEED
FND_OBJECTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnIREP_PRODUCT
Columns
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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
,      ZD_EDITION_NAME
FROM APPLSYS.FND_OBJECTS;

Dependencies

[top of page]

APPLSYS.FND_OBJECTS does not reference any database object

APPLSYS.FND_OBJECTS is referenced by following:

SchemaAPPLSYS
ViewFND_OBJECTS#