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


VIEW: APPS.FND_DESCR_FLEX_CONTEXTS_VL

Object Details
Object Name: FND_DESCR_FLEX_CONTEXTS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.FND_DESCR_FLEX_CONTEXTS_VL
Subobject Name:
Status: VALID

View Type

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


FND_DESCR_FLEX_CONTEXTS_VL is a view that joins the translated,
language specific values from FND_DESCR_FLEX_CONTEXTS_TL with the
non-displayed data from FND_DESCR_FLEX_CONTEXTS to form complete
descriptive flexfield context entities. Oracle Application Object
Library uses this view to display information in languages that are
installed at your site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
APPLICATION_ID NUMBER (10) Yes Application identifier
DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2 (40) Yes Descriptive flexfield name
DESCRIPTIVE_FLEX_CONTEXT_CODE VARCHAR2 (30) Yes The context field value
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 (15)
Standard Who column
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
GLOBAL_FLAG VARCHAR2 (1) Yes Flag to indicate whether the context field value identifies a global segment structure
DESCRIPTION VARCHAR2 (240)
Description
DESCRIPTIVE_FLEX_CONTEXT_NAME VARCHAR2 (80) Yes Translatable name for the context
Query Text

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


SELECT ROW_ID
,      APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      GLOBAL_FLAG
,      DESCRIPTION
,      DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM APPS.FND_DESCR_FLEX_CONTEXTS_VL;

Dependencies

[top of page]

APPS.FND_DESCR_FLEX_CONTEXTS_VL references the following:

SchemaAPPS
SynonymFND_DESCR_FLEX_CONTEXTS
SynonymFND_DESCR_FLEX_CONTEXTS_TL
APPS.FND_DESCR_FLEX_CONTEXTS_VL is referenced by following:

SchemaAPPS
Package BodyAP_WEB_DB_EXPLINE_PKG - show dependent code
Package BodyBIS_VG_DESC_FLEX - show dependent code
Package BodyEAM_ASSETATTR_GRP_PUB - show dependent code
Package BodyEAM_ASSETATTR_VALUE_PUB - show dependent code
Package BodyEDW_GEN_VIEW - 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_DIAGNOSE - show dependent code
Package BodyFND_FLEX_SERVER4 - show dependent code
Package BodyFND_FLEX_UPGRADE_UTILITIES - show dependent code
Package BodyHRI_BPL_SETUP_DIAGNOSTIC - show dependent code
Package BodyHRI_OPL_JOBH - show dependent code
Package BodyHR_DESCR_FLEX_CONTEXT_INFO - show dependent code
Package BodyHR_DM_INIT - show dependent code
Package BodyHR_LOC_BUS - show dependent code
Package BodyHR_PERSON_RECORD - show dependent code
ViewHXC_ALIAS_DEFINITIONS_V
Package BodyHXC_ALIAS_DEFN_UPLOAD_PKG - show dependent code
Package BodyHXC_ALIAS_TYPES_UPLOAD_PKG - show dependent code
ViewHXC_ALIAS_TYPES_V
Package BodyHXC_CREATE_FLEX_MAPPINGS - show dependent code
PL/SQL PackageHXC_DEPOSIT_WRAPPER_UTILITIES - show dependent code
Package BodyHXC_DEPOSIT_WRAPPER_UTILITIES - show dependent code
Package BodyHXC_HAD_BUS - show dependent code
Package BodyHXC_HPH_UPLOAD_PKG - show dependent code
Package BodyHXC_LOAD_PKG - show dependent code
Package BodyHXC_OTL_INFO_TYPE_HELPER - show dependent code
ViewHXC_PREF_HIERARCHIES_V
ViewHXC_RESOURCE_ALL_ELIG_PREF_V
Package BodyHZ_GEO_STRUCT_MAP_PUB - show dependent code
Package BodyINV_LOT_SEL_ATTR - show dependent code
ViewINV_LOT_SERIAL_CONTEXT_V
Package BodyINV_MWB_TREE - show dependent code
Package BodyINV_MWB_TREE1 - show dependent code
Package BodyJL_ZZ_AP_LIBRARY_1_PKG - show dependent code
Package BodyJL_ZZ_INV_LIBRARY_1_PKG - show dependent code
Package BodyJL_ZZ_OE_LIBRARY_1_PKG - show dependent code
Package BodyJL_ZZ_PO_LIBRARY_1_PKG - show dependent code
ViewMTL_EAM_ASSET_ATTR_GROUPS_V
Package BodyOKC_RLD_PVT - show dependent code
Package BodyOKC_RUL_PVT - show dependent code
ViewOKE_ATTRIBUTE_GROUPS_V
Package BodyOKL_RULE_EXTRACT_PVT - show dependent code
Package BodyOTA_CLASSIC_UPGRADE - show dependent code
Package BodyOTA_TRAINING_PLAN_UPGRADE - show dependent code
Package BodyPA_PAGE_LAYOUT_UTILS - show dependent code
ViewPA_PAGE_REGIONS_V
PL/SQL PackagePA_TRANSACTIONS_PUB - show dependent code
ViewPA_UDS_SECTIONS_V
Package BodyPER_ADDRESSES_PKG - show dependent code
Package BodyPER_APPLICANT_PKG - show dependent code
ViewPER_INFO_TYPES_V
ViewPER_INFO_TYPE_SECURITY_V
Package BodyPER_JP_DEPENDENT_PKG - show dependent code
Package BodyPER_PTU_DFF_MIG - show dependent code
Package BodyPER_QH_MAINTAIN_QUERY - show dependent code
Package BodyPOR_LOAD_LOCATION - show dependent code
Package BodyPQH_GENERIC_HIERARCHY_PACKAGE - show dependent code
Package BodyPQH_PEI_DDF - show dependent code
Package BodyPQH_UTILITY - show dependent code
Package BodyPQP_GB_PSI_SERVICE_HISTORY - show dependent code
Package BodyPQP_SS_VEHICLE_TRANSACTIONS - show dependent code
Package BodyPSB_HR_EXTRACT_DATA_PVT - show dependent code
Package BodyPSB_HR_POPULATE_DATA_PVT - show dependent code