FND Design Data [Home] [Help]

View: FND_OBJECTS_VL

Product: FND - Application Object Library
Description: FND_OBJECTS_VL
Implementation/DBA Data: ViewAPPS.FND_OBJECTS_VL
View Text

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')

Columns

Name
ROW_ID
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
DISPLAY_NAME
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
IREP_NAME
IREP_OBJECT_TYPE
IREP_PRODUCT
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
LOAD_ERR
LOAD_ERR_MSGS
IREP_DEF_CLASS
IREP_CLASS_NAME
IREP_IS_FILTER
IREP_IS_EXPRESSION
IREP_LDR_PP_FLAG
IREP_HIDE_SCHEMA