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_DESCRIPTIVE_FLEXS_VL

Object Details

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

View Type

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

FND_DESCRIPTIVE_FLEXS_VL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW_ID
CONCATENATED_SEGS_VIEW_NAME	VARCHAR2	(30)
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
APPLICATION_TABLE_NAME	VARCHAR2	(30)	Yes	Table name
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	APPLICATION_TABLE_NAME
TABLE_APPLICATION_ID	NUMBER	(10)	Yes	Application to which table belongs
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(10)		Standard Who column
CONTEXT_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the descriptive flexfield requires a reference field
CONTEXT_COLUMN_NAME	VARCHAR2	(30)	Yes	The name of the structure defining column for the flexfield
CONTEXT_USER_OVERRIDE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if users can override the value in the reference field
CONCATENATED_SEGMENT_DELIMITER	VARCHAR2	(1)	Yes	The delimiter used to separate different segment values in the concatenated value
FREEZE_FLEX_DEFINITION_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the descriptive flexfield is frozen
PROTECTED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether this is a protected descriptive flexfield
DEFAULT_CONTEXT_FIELD_NAME	VARCHAR2	(200)		The name of the reference field
DEFAULT_CONTEXT_VALUE	VARCHAR2	(30)		The default value for the reference field
CONTEXT_DEFAULT_TYPE	VARCHAR2	(1)		CONTEXT_DEFAULT_TYPE
CONTEXT_DEFAULT_VALUE	VARCHAR2	(2000)		CONTEXT_DEFAULT_VALUE
CONTEXT_OVERRIDE_VALUE_SET_ID	NUMBER	(10)
CONTEXT_RUNTIME_PROPERTY_FUNCT	VARCHAR2	(2000)
CONTEXT_SYNCHRONIZATION_FLAG	VARCHAR2	(1)	Yes	Synchronize Context with Reference field?
TITLE	VARCHAR2	(60)	Yes	Descriptive flexfield title
FORM_CONTEXT_PROMPT	VARCHAR2	(45)	Yes	Reference field prompt
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT ROW_ID
,      CONCATENATED_SEGS_VIEW_NAME
,      APPLICATION_ID
,      APPLICATION_TABLE_NAME
,      DESCRIPTIVE_FLEXFIELD_NAME
,      TABLE_APPLICATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONTEXT_REQUIRED_FLAG
,      CONTEXT_COLUMN_NAME
,      CONTEXT_USER_OVERRIDE_FLAG
,      CONCATENATED_SEGMENT_DELIMITER
,      FREEZE_FLEX_DEFINITION_FLAG
,      PROTECTED_FLAG
,      DEFAULT_CONTEXT_FIELD_NAME
,      DEFAULT_CONTEXT_VALUE
,      CONTEXT_DEFAULT_TYPE
,      CONTEXT_DEFAULT_VALUE
,      CONTEXT_OVERRIDE_VALUE_SET_ID
,      CONTEXT_RUNTIME_PROPERTY_FUNCT
,      CONTEXT_SYNCHRONIZATION_FLAG
,      TITLE
,      FORM_CONTEXT_PROMPT
,      DESCRIPTION
FROM APPS.FND_DESCRIPTIVE_FLEXS_VL;

Dependencies

[top of page]

APPS.FND_DESCRIPTIVE_FLEXS_VL references the following:

APPS: FND_DESCRIPTIVE_FLEXS; FND_DESCRIPTIVE_FLEXS_TL

APPS.FND_DESCRIPTIVE_FLEXS_VL is referenced by following:

APPS: AHL_LTP_REQST_MATRL_PVT - show dependent code; AR_DEPOSIT_LIB_PVT - show dependent code; AZ_FLEX_COMPILER - show dependent code; BIS_FLEX_FIELDS_V; BIS_VG_TYPES - show dependent code; FND_DFLEX - show dependent code; FND_DFLEX - show dependent code; FND_FLEX_DESCR_SEG_VSET_V; FND_FLEX_DESCVAL - show dependent code; FND_FLEX_DFF_SEG_VSET_V; FND_FLEX_DIAGNOSE - show dependent code; FND_FLEX_LOADER_APIS - show dependent code; FND_FLEX_SERVER - show dependent code; FND_FLEX_SERVER2 - show dependent code; FND_FLEX_UPGRADE_UTILITIES - show dependent code; FND_PROGRAM - show dependent code; HRDYNDBI - show dependent code; HR_ASSIGNMENT - show dependent code; HR_DM_INIT - show dependent code; HR_FLEXFIELD_INFO - show dependent code; HR_FLEXFIELD_INFO - show dependent code; HR_REPORTS - show dependent code; INV_LOT_SEL_ATTR - show dependent code; JTF_RS_GROUP_REPORT_PUB - show dependent code; OE_BLANKET_UTIL - show dependent code; OE_VALIDATE_LINE - show dependent code; OE_VERSION_BLANKET_COMP - show dependent code; OE_VERSION_COMP - show dependent code; OE_VERSION_PRICE_ADJUST_COMP - show dependent code; PA_DRAFT_INVOICES_ALL_V; PA_TRANSACTIONS_PUB - show dependent code; PA_TRANSACTIONS_PUB - show dependent code; PER_FR_UPGRADE_DATA_PKG - show dependent code; PER_PTU_DFF_MIG - show dependent code; PQP_GB_TP_PENSION_EXTRACTS - show dependent code; WIP_EAM_WORKREQUEST_PVT - show dependent code; WIP_EAM_WORKREQUEST_PVT - show dependent code; WSH_FLEXFIELD_UTILS - show dependent code; WSH_FLEXFIELD_UTILS - show dependent code