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: ViewFND.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:

SchemaAPPS
SynonymFND_DESCRIPTIVE_FLEXS
SynonymFND_DESCRIPTIVE_FLEXS_TL
APPS.FND_DESCRIPTIVE_FLEXS_VL is referenced by following:

SchemaAPPS
Package BodyAR_DEPOSIT_LIB_PVT - show dependent code
Package BodyAZ_FLEX_COMPILER - show dependent code
ViewBIS_FLEX_FIELDS_V
PL/SQL PackageBIS_VG_TYPES - show dependent code
PL/SQL PackageFND_DFLEX - show dependent code
Package BodyFND_DFLEX - show dependent code
ViewFND_FLEX_DESCR_SEG_VSET_V
Package BodyFND_FLEX_DESCVAL - show dependent code
Package BodyFND_FLEX_DIAGNOSE - show dependent code
Package BodyFND_FLEX_LOADER_APIS - show dependent code
Package BodyFND_FLEX_SERVER - show dependent code
Package BodyFND_FLEX_SERVER2 - show dependent code
Package BodyFND_FLEX_UPGRADE_UTILITIES - show dependent code
Package BodyFND_PROGRAM - show dependent code
Package BodyHRDYNDBI - show dependent code
Package BodyHR_ASSIGNMENT - show dependent code
Package BodyHR_DM_INIT - show dependent code
Package BodyHR_FLEXFIELD_INFO - show dependent code
PL/SQL PackageHR_FLEXFIELD_INFO - show dependent code
Package BodyHR_REPORTS - show dependent code
Package BodyINV_LOT_SEL_ATTR - show dependent code
Package BodyJTF_RS_GROUP_REPORT_PUB - show dependent code
Package BodyOE_BLANKET_UTIL - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOE_VERSION_BLANKET_COMP - show dependent code
Package BodyOE_VERSION_COMP - show dependent code
Package BodyOE_VERSION_PRICE_ADJUST_COMP - show dependent code
ViewPA_DRAFT_INVOICES_ALL_V
PL/SQL PackagePA_TRANSACTIONS_PUB - show dependent code
Package BodyPA_TRANSACTIONS_PUB - show dependent code
Package BodyPER_FR_UPGRADE_DATA_PKG - show dependent code
Package BodyPER_PTU_DFF_MIG - show dependent code
Package BodyPQP_GB_TP_PENSION_EXTRACTS - show dependent code
Package BodyPSB_HR_EXTRACT_DATA_PVT - show dependent code
Package BodyPSB_HR_POPULATE_DATA_PVT - show dependent code
PL/SQL PackageWIP_EAM_WORKREQUEST_PVT - show dependent code
Package BodyWIP_EAM_WORKREQUEST_PVT - show dependent code
Package BodyWSH_FLEXFIELD_UTILS - show dependent code
PL/SQL PackageWSH_FLEXFIELD_UTILS - show dependent code