VIEW: APPS.FND_OBJECTS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.OBJECT_ID, B.OBJ_NAME, B.APPLICATION_ID, B.DATABASE_OBJECT_NAME, B.PK1_COLUMN_NAME, B.PK2_COLUMN_NAME, B.PK3_COLUMN_NAME, B.PK4_COLUMN_NAME, B.PK5_COLUMN_NAME, B.PK1_COLUMN_TYPE, B.PK2_COLUMN_TYPE, B.PK3_COLUMN_TYPE, B.PK4_COLUMN_TYPE, B.PK5_COLUMN_TYPE, T.DISPLAY_NAME, T.DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.IREP_NAME, B.IREP_OBJECT_TYPE, B.IREP_PRODUCT, B.IREP_COMPATIBILITY, B.IREP_SCOPE, B.IREP_LIFECYCLE, B.IREP_SOURCE_FILE_PRODUCT, B.IREP_SOURCE_FILE_PATH, B.IREP_SOURCE_FILE_NAME, B.IREP_SOURCE_FILE_VERSION, B.IREP_DESCRIPTION, B.IREP_XML_DESCRIPTION, B.IREP_STANDARD, B.IREP_STANDARD_VERSION, B.IREP_STANDARD_SPEC, B.open_interface_flag, B.load_err, B.LOAD_ERR_MSGS, B.IREP_DEF_CLASS, B.IREP_CLASS_NAME, B.IREP_IS_FILTER, B.IREP_IS_EXPRESSION, B.IREP_LDR_PP_FLAG, B.IREP_HIDE_SCHEMA from FND_OBJECTS_TL T, FND_OBJECTS B WHERE B.OBJECT_ID = T.OBJECT_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.OBJECT_ID
, B.OBJ_NAME
, B.APPLICATION_ID
, B.DATABASE_OBJECT_NAME
, B.PK1_COLUMN_NAME
, B.PK2_COLUMN_NAME
, B.PK3_COLUMN_NAME
, B.PK4_COLUMN_NAME
, B.PK5_COLUMN_NAME
, B.PK1_COLUMN_TYPE
, B.PK2_COLUMN_TYPE
, B.PK3_COLUMN_TYPE
, B.PK4_COLUMN_TYPE
, B.PK5_COLUMN_TYPE
, T.DISPLAY_NAME
, T.DESCRIPTION
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.IREP_NAME
, B.IREP_OBJECT_TYPE
, B.IREP_PRODUCT
, B.IREP_COMPATIBILITY
, B.IREP_SCOPE
, B.IREP_LIFECYCLE
, B.IREP_SOURCE_FILE_PRODUCT
, B.IREP_SOURCE_FILE_PATH
, B.IREP_SOURCE_FILE_NAME
, B.IREP_SOURCE_FILE_VERSION
, B.IREP_DESCRIPTION
, B.IREP_XML_DESCRIPTION
, B.IREP_STANDARD
, B.IREP_STANDARD_VERSION
, B.IREP_STANDARD_SPEC
, B.OPEN_INTERFACE_FLAG
, B.LOAD_ERR
, B.LOAD_ERR_MSGS
, B.IREP_DEF_CLASS
, B.IREP_CLASS_NAME
, B.IREP_IS_FILTER
, B.IREP_IS_EXPRESSION
, B.IREP_LDR_PP_FLAG
, B.IREP_HIDE_SCHEMA
FROM FND_OBJECTS_TL T
, FND_OBJECTS B
WHERE B.OBJECT_ID = T.OBJECT_ID
AND T.LANGUAGE = USERENV('LANG')