eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.FND_OBJECTS_VL

Object Details

Object Name:	FND_OBJECTS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_OBJECTS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

FND_OBJECTS_VL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW_ID
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
DISPLAY_NAME	VARCHAR2	(240)	Yes	Object display name
DESCRIPTION	VARCHAR2	(2000)	Yes	Object description
CREATED_BY	NUMBER	(15)	Yes	CREATED_BY
CREATION_DATE	DATE		Yes	CREATION_DATE
LAST_UPDATED_BY	NUMBER	(15)	Yes	LAST_UPDATED_BY
LAST_UPDATE_DATE	DATE		Yes	LAST_UPDATE_DATE
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	LAST_UPDATE_LOGIN
IREP_NAME	VARCHAR2	(400)
IREP_OBJECT_TYPE	VARCHAR2	(30)
IREP_PRODUCT	VARCHAR2	(8)
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)
LOAD_ERR	VARCHAR2	(1)
LOAD_ERR_MSGS	VARCHAR2	(4000)
IREP_DEF_CLASS	VARCHAR2	(400)
IREP_CLASS_NAME	VARCHAR2	(400)
IREP_IS_FILTER	VARCHAR2	(1)
IREP_IS_EXPRESSION	VARCHAR2	(1)
IREP_LDR_PP_FLAG	VARCHAR2	(1)
IREP_HIDE_SCHEMA	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.FND_OBJECTS_VL;

Dependencies

[top of page]

APPS.FND_OBJECTS_VL references the following:

APPS: FND_OBJECTS; FND_OBJECTS_TL

APPS.FND_OBJECTS_VL is referenced by following:

APPS: EGO_IMPORT_BATCHES_PKG - show dependent code; EGO_IMPORT_BATCH_DETAILS_V; ENG_CHANGE_ROUTE_PEOPLE_UTIL - show dependent code; ENG_VAL_TO_ID - show dependent code; FND_IREP_ALL_INTERFACES; GL_DEFAS_ASSIGNMENTS_V; GL_GLXDFUSR_XMLP_PKG - show dependent code; HZ_DSS_SEL_ENTITIES_V; HZ_DSS_UTIL_PUB - show dependent code; MTL_CATEGORY_GRANTS_V; MTL_OBJECT_GRANTS_V; PON_UDA_IMPORT_PKG - show dependent code; POR_UDA_PKG - show dependent code; PO_UDA_DEFAULTING_PKG - show dependent code; SOA_GENERATE - show dependent code