VIEW: APPLSYS.FND_OBJECTS#

Source

View Text - Preformatted

select OBJECT_ID OBJECT_ID, OBJ_NAME OBJ_NAME, APPLICATION_ID APPLICATION_ID, DATABASE_OBJECT_NAME DATABASE_OBJECT_NAME, PK1_COLUMN_NAME PK1_COLUMN_NAME, PK2_COLUMN_NAME PK2_COLUMN_NAME, PK3_COLUMN_NAME PK3_COLUMN_NAME, PK4_COLUMN_NAME PK4_COLUMN_NAME, PK5_COLUMN_NAME PK5_COLUMN_NAME, PK1_COLUMN_TYPE PK1_COLUMN_TYPE, PK2_COLUMN_TYPE PK2_COLUMN_TYPE, PK3_COLUMN_TYPE PK3_COLUMN_TYPE, PK4_COLUMN_TYPE PK4_COLUMN_TYPE, PK5_COLUMN_TYPE PK5_COLUMN_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IREP_NAME IREP_NAME, IREP_OBJECT_TYPE IREP_OBJECT_TYPE, IREP_PRODUCT IREP_PRODUCT, LOAD_ERR LOAD_ERR, LOAD_ERR_MSGS LOAD_ERR_MSGS, IREP_COMPATIBILITY IREP_COMPATIBILITY, IREP_SCOPE IREP_SCOPE, IREP_LIFECYCLE IREP_LIFECYCLE, IREP_SOURCE_FILE_PRODUCT IREP_SOURCE_FILE_PRODUCT, IREP_SOURCE_FILE_PATH IREP_SOURCE_FILE_PATH, IREP_SOURCE_FILE_NAME IREP_SOURCE_FILE_NAME, IREP_SOURCE_FILE_VERSION IREP_SOURCE_FILE_VERSION, IREP_DESCRIPTION IREP_DESCRIPTION, IREP_XML_DESCRIPTION IREP_XML_DESCRIPTION, IREP_STANDARD IREP_STANDARD, IREP_STANDARD_VERSION IREP_STANDARD_VERSION, IREP_STANDARD_SPEC IREP_STANDARD_SPEC, OPEN_INTERFACE_FLAG OPEN_INTERFACE_FLAG, IREP_LDR_PP_FLAG IREP_LDR_PP_FLAG, IREP_HIDE_SCHEMA IREP_HIDE_SCHEMA, IREP_DEF_CLASS IREP_DEF_CLASS, IREP_CLASS_NAME IREP_CLASS_NAME, IREP_FILTER_REQUIRED IREP_FILTER_REQUIRED, IREP_IS_FILTER IREP_IS_FILTER, IREP_IS_EXPRESSION IREP_IS_EXPRESSION, IREP_LDR_INTERNAL_FLAG IREP_LDR_INTERNAL_FLAG, CRAWL_CRAWLABLE CRAWL_CRAWLABLE, CRAWL_VISIBILITY_LEVEL CRAWL_VISIBILITY_LEVEL, CRAWL_SEARCH_PLUGIN CRAWL_SEARCH_PLUGIN, CRAWL_UI_FUNCTION CRAWL_UI_FUNCTION, CRAWL_CHANGE_EVENT_NAME CRAWL_CHANGE_EVENT_NAME, CRAWL_CHANGE_NOTIFICATION CRAWL_CHANGE_NOTIFICATION, CRAWL_DRIVING_TABLE CRAWL_DRIVING_TABLE, CRAWL_SEARCHID CRAWL_SEARCHID, CRAWL_LASTCRAWLED CRAWL_LASTCRAWLED, ZD_EDITION_NAME ZD_EDITION_NAME from "APPLSYS"."FND_OBJECTS"

View Text - HTML Formatted

SELECT OBJECT_ID OBJECT_ID
, OBJ_NAME OBJ_NAME
, APPLICATION_ID APPLICATION_ID
, DATABASE_OBJECT_NAME DATABASE_OBJECT_NAME
, PK1_COLUMN_NAME PK1_COLUMN_NAME
, PK2_COLUMN_NAME PK2_COLUMN_NAME
, PK3_COLUMN_NAME PK3_COLUMN_NAME
, PK4_COLUMN_NAME PK4_COLUMN_NAME
, PK5_COLUMN_NAME PK5_COLUMN_NAME
, PK1_COLUMN_TYPE PK1_COLUMN_TYPE
, PK2_COLUMN_TYPE PK2_COLUMN_TYPE
, PK3_COLUMN_TYPE PK3_COLUMN_TYPE
, PK4_COLUMN_TYPE PK4_COLUMN_TYPE
, PK5_COLUMN_TYPE PK5_COLUMN_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IREP_NAME IREP_NAME
, IREP_OBJECT_TYPE IREP_OBJECT_TYPE
, IREP_PRODUCT IREP_PRODUCT
, LOAD_ERR LOAD_ERR
, LOAD_ERR_MSGS LOAD_ERR_MSGS
, IREP_COMPATIBILITY IREP_COMPATIBILITY
, IREP_SCOPE IREP_SCOPE
, IREP_LIFECYCLE IREP_LIFECYCLE
, IREP_SOURCE_FILE_PRODUCT IREP_SOURCE_FILE_PRODUCT
, IREP_SOURCE_FILE_PATH IREP_SOURCE_FILE_PATH
, IREP_SOURCE_FILE_NAME IREP_SOURCE_FILE_NAME
, IREP_SOURCE_FILE_VERSION IREP_SOURCE_FILE_VERSION
, IREP_DESCRIPTION IREP_DESCRIPTION
, IREP_XML_DESCRIPTION IREP_XML_DESCRIPTION
, IREP_STANDARD IREP_STANDARD
, IREP_STANDARD_VERSION IREP_STANDARD_VERSION
, IREP_STANDARD_SPEC IREP_STANDARD_SPEC
, OPEN_INTERFACE_FLAG OPEN_INTERFACE_FLAG
, IREP_LDR_PP_FLAG IREP_LDR_PP_FLAG
, IREP_HIDE_SCHEMA IREP_HIDE_SCHEMA
, IREP_DEF_CLASS IREP_DEF_CLASS
, IREP_CLASS_NAME IREP_CLASS_NAME
, IREP_FILTER_REQUIRED IREP_FILTER_REQUIRED
, IREP_IS_FILTER IREP_IS_FILTER
, IREP_IS_EXPRESSION IREP_IS_EXPRESSION
, IREP_LDR_INTERNAL_FLAG IREP_LDR_INTERNAL_FLAG
, CRAWL_CRAWLABLE CRAWL_CRAWLABLE
, CRAWL_VISIBILITY_LEVEL CRAWL_VISIBILITY_LEVEL
, CRAWL_SEARCH_PLUGIN CRAWL_SEARCH_PLUGIN
, CRAWL_UI_FUNCTION CRAWL_UI_FUNCTION
, CRAWL_CHANGE_EVENT_NAME CRAWL_CHANGE_EVENT_NAME
, CRAWL_CHANGE_NOTIFICATION CRAWL_CHANGE_NOTIFICATION
, CRAWL_DRIVING_TABLE CRAWL_DRIVING_TABLE
, CRAWL_SEARCHID CRAWL_SEARCHID
, CRAWL_LASTCRAWLED CRAWL_LASTCRAWLED
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "APPLSYS"."FND_OBJECTS"