[Home] [Help] [Dependency Information]
Object Name: | FND_OBJECTS# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | (15) | Yes | |
OBJ_NAME | VARCHAR2 | (430) | Yes | |
APPLICATION_ID | NUMBER | (15) | Yes | |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | |
PK1_COLUMN_NAME | VARCHAR2 | (30) | Yes | |
PK2_COLUMN_NAME | VARCHAR2 | (30) | ||
PK3_COLUMN_NAME | VARCHAR2 | (30) | ||
PK4_COLUMN_NAME | VARCHAR2 | (30) | ||
PK5_COLUMN_NAME | VARCHAR2 | (30) | ||
PK1_COLUMN_TYPE | VARCHAR2 | (8) | Yes | |
PK2_COLUMN_TYPE | VARCHAR2 | (8) | ||
PK3_COLUMN_TYPE | VARCHAR2 | (8) | ||
PK4_COLUMN_TYPE | VARCHAR2 | (8) | ||
PK5_COLUMN_TYPE | VARCHAR2 | (8) | ||
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 | |
IREP_NAME | VARCHAR2 | (400) | ||
IREP_OBJECT_TYPE | VARCHAR2 | (30) | ||
IREP_PRODUCT | VARCHAR2 | (8) | ||
LOAD_ERR | VARCHAR2 | (1) | ||
LOAD_ERR_MSGS | VARCHAR2 | (4000) | ||
IREP_COMPATIBILITY | VARCHAR2 | (1) | ||
IREP_SCOPE | VARCHAR2 | (30) | ||
IREP_LIFECYCLE | VARCHAR2 | (30) | ||
IREP_SOURCE_FILE_PRODUCT | VARCHAR2 | (8) | ||
IREP_SOURCE_FILE_PATH | VARCHAR2 | (100) | ||
IREP_SOURCE_FILE_NAME | VARCHAR2 | (36) | ||
IREP_SOURCE_FILE_VERSION | VARCHAR2 | (150) | ||
IREP_DESCRIPTION | CLOB | (4000) | ||
IREP_XML_DESCRIPTION | CLOB | (4000) | ||
IREP_STANDARD | VARCHAR2 | (30) | ||
IREP_STANDARD_VERSION | VARCHAR2 | (30) | ||
IREP_STANDARD_SPEC | VARCHAR2 | (240) | ||
OPEN_INTERFACE_FLAG | VARCHAR2 | (1) | ||
IREP_LDR_PP_FLAG | VARCHAR2 | (1) | ||
IREP_HIDE_SCHEMA | VARCHAR2 | (1) | ||
IREP_DEF_CLASS | VARCHAR2 | (400) | ||
IREP_CLASS_NAME | VARCHAR2 | (400) | ||
IREP_FILTER_REQUIRED | VARCHAR2 | (1) | ||
IREP_IS_FILTER | VARCHAR2 | (1) | ||
IREP_IS_EXPRESSION | VARCHAR2 | (1) | ||
IREP_LDR_INTERNAL_FLAG | VARCHAR2 | (1) | ||
CRAWL_CRAWLABLE | VARCHAR2 | (1) | ||
CRAWL_VISIBILITY_LEVEL | VARCHAR2 | (8) | ||
CRAWL_SEARCH_PLUGIN | VARCHAR2 | (4000) | ||
CRAWL_UI_FUNCTION | VARCHAR2 | (240) | ||
CRAWL_CHANGE_EVENT_NAME | VARCHAR2 | (4000) | ||
CRAWL_CHANGE_NOTIFICATION | VARCHAR2 | (1) | ||
CRAWL_DRIVING_TABLE | VARCHAR2 | (30) | ||
CRAWL_SEARCHID | VARCHAR2 | (240) | ||
CRAWL_LASTCRAWLED | DATE | |||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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#;
|
|
|