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


VIEW: APPS.FND_FLEX_VALUES_VL

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

View Type

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
FLEX_VALUE_SET_ID NUMBER (10) Yes
FLEX_VALUE_ID NUMBER (15) Yes
FLEX_VALUE VARCHAR2 (150) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
ENABLED_FLAG VARCHAR2 (1) Yes
SUMMARY_FLAG VARCHAR2 (1) Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

PARENT_FLEX_VALUE_LOW VARCHAR2 (60)
PARENT_FLEX_VALUE_HIGH VARCHAR2 (60)
STRUCTURED_HIERARCHY_LEVEL NUMBER (15)
HIERARCHY_LEVEL VARCHAR2 (30)
COMPILED_VALUE_ATTRIBUTES VARCHAR2 (2000)
VALUE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE21 VARCHAR2 (240)
ATTRIBUTE22 VARCHAR2 (240)
ATTRIBUTE23 VARCHAR2 (240)
ATTRIBUTE24 VARCHAR2 (240)
ATTRIBUTE25 VARCHAR2 (240)
ATTRIBUTE26 VARCHAR2 (240)
ATTRIBUTE27 VARCHAR2 (240)
ATTRIBUTE28 VARCHAR2 (240)
ATTRIBUTE29 VARCHAR2 (240)
ATTRIBUTE30 VARCHAR2 (240)
ATTRIBUTE31 VARCHAR2 (240)
ATTRIBUTE32 VARCHAR2 (240)
ATTRIBUTE33 VARCHAR2 (240)
ATTRIBUTE34 VARCHAR2 (240)
ATTRIBUTE35 VARCHAR2 (240)
ATTRIBUTE36 VARCHAR2 (240)
ATTRIBUTE37 VARCHAR2 (240)
ATTRIBUTE38 VARCHAR2 (240)
ATTRIBUTE39 VARCHAR2 (240)
ATTRIBUTE40 VARCHAR2 (240)
ATTRIBUTE41 VARCHAR2 (240)
ATTRIBUTE42 VARCHAR2 (240)
ATTRIBUTE43 VARCHAR2 (240)
ATTRIBUTE44 VARCHAR2 (240)
ATTRIBUTE45 VARCHAR2 (240)
ATTRIBUTE46 VARCHAR2 (240)
ATTRIBUTE47 VARCHAR2 (240)
ATTRIBUTE48 VARCHAR2 (240)
ATTRIBUTE49 VARCHAR2 (240)
ATTRIBUTE50 VARCHAR2 (240)
FLEX_VALUE_MEANING VARCHAR2 (150) Yes
DESCRIPTION VARCHAR2 (240)
ATTRIBUTE_SORT_ORDER NUMBER (15)
Sort Order for Flex Values
Query Text

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


SELECT ROW_ID
,      FLEX_VALUE_SET_ID
,      FLEX_VALUE_ID
,      FLEX_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      SUMMARY_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PARENT_FLEX_VALUE_LOW
,      PARENT_FLEX_VALUE_HIGH
,      STRUCTURED_HIERARCHY_LEVEL
,      HIERARCHY_LEVEL
,      COMPILED_VALUE_ATTRIBUTES
,      VALUE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      ATTRIBUTE41
,      ATTRIBUTE42
,      ATTRIBUTE43
,      ATTRIBUTE44
,      ATTRIBUTE45
,      ATTRIBUTE46
,      ATTRIBUTE47
,      ATTRIBUTE48
,      ATTRIBUTE49
,      ATTRIBUTE50
,      FLEX_VALUE_MEANING
,      DESCRIPTION
,      ATTRIBUTE_SORT_ORDER
FROM APPS.FND_FLEX_VALUES_VL;

Dependencies

[top of page]

APPS.FND_FLEX_VALUES_VL references the following:

SchemaAPPS
SynonymFND_FLEX_VALUES
SynonymFND_FLEX_VALUES_TL
APPS.FND_FLEX_VALUES_VL is referenced by following:

SchemaAPPS
Package BodyAP_BAL_PKG - show dependent code
Package BodyAR_DEP_BAL_RPT_PKG - show dependent code
Package BodyCSF_TRIPS_PUB - show dependent code
ViewEGO_ITEMS_V
Package BodyEGO_ITEM_USER_ATTRS_CP_PUB - show dependent code
ViewEGO_VALUE_SET_VALUES_V
Package BodyENI_VALUESET_CATEGORY - show dependent code
Package BodyFA_RX_FLEX_PKG - show dependent code
Package BodyFND_FLEX_DIAGNOSE - show dependent code
Package BodyFND_FLEX_HIERARCHY_COMPILER - show dependent code
Package BodyFND_FLEX_SERVER1 - show dependent code
ViewFND_FLEX_VALUE_CHILDREN_V
ViewFND_FLEX_VALUE_DESTINATION_V
Package BodyFND_FLEX_VAL_API - show dependent code
Package BodyFND_VSET - show dependent code
PL/SQL PackageFND_VSET - show dependent code
Package BodyFV_FACTS2_DERIVE_BALANCES - show dependent code
Package BodyFV_FACTS_TBAL_TRX - show dependent code
Package BodyFV_UTILITY - show dependent code
Package BodyFV_YE_CLOSE - show dependent code
Package BodyGL_CHART_OF_ACCOUNTS_API_PKG - show dependent code
Package BodyGL_DRM_INTEGRATION_PKG - show dependent code
Package BodyGL_MC_INFO - show dependent code
Package BodyGMF_FND_GET_SEGMENT_VAL - show dependent code
Package BodyGMF_GET_MAPPINGS - show dependent code
Package BodyGMF_UTILITIES_GRP - show dependent code
Package BodyHR_CAL_ENTRY_VALUE_API - show dependent code
Package BodyHR_GL_COST_CENTERS - show dependent code
Package BodyHR_GL_SYNC_ORGS - show dependent code
PL/SQL PackageHXC_ABS_RETRIEVAL_PKG - show dependent code
Package BodyIGI_EXP_HOLDS - show dependent code
Package BodyJAI_AP_TDS_ETDS_PKG - show dependent code
Package BodyJAI_CMN_MTAX_PKG - show dependent code
Package BodyJAI_ETCS_PKG - show dependent code
Package BodyJA_CN_FA_ACS_EXPORT_PKG - show dependent code
Package BodyJA_CN_GL_BANK_EXP_PKG - show dependent code
Package BodyJA_CN_PS_SI_SM_EXPORT_PKG - show dependent code
Package BodyJA_CN_SI_BANK_DET_PKG - show dependent code
Package BodyJA_CN_SM_EXPORT_PKG - show dependent code
Package BodyJA_CN_SYSOPS_BANK_PKG - show dependent code
ViewJA_CN_SYSTEM_BANK_PARAMS_ALL_V
Package BodyJA_JAINARDR_XMLP_PKG - show dependent code
Package BodyJA_JAINBBR_XMLP_PKG - show dependent code
Package BodyJA_JAINJVR_XMLP_PKG - show dependent code
Package BodyJE_JEFIASDR_XMLP_PKG - show dependent code
Package BodyJE_ZZ_AUDIT_AP_PKG - show dependent code
Package BodyJG_GL_ACCT_HIER_PKG - show dependent code
Package BodyJG_ZZ_SUMMARY_ALL_PKG - show dependent code
Package BodyJL_BR_SPED_DATA_EXTRACT_PKG - show dependent code
ViewJL_CO_GL_NIT_ACCTS_V
Package BodyLNS_BILLING_BATCH_PUB - show dependent code
Package BodyOKC_TERMS_MIGRATE_GRP - show dependent code
Package BodyOKC_TERMS_UTIL_PVT - show dependent code
Package BodyOKC_XPRT_CUSTOM_PACKAGE - show dependent code
Package BodyOKC_XPRT_IMPORT_TEMPLATE_PVT - show dependent code
Package BodyOKC_XPRT_QA_PVT - show dependent code
Package BodyOKC_XPRT_UTIL_PVT - show dependent code
Package BodyOKE_K_USER_ATTRIBUTES_PUB - show dependent code
Package BodyOKL_ACCOUNTING_UTIL - show dependent code
Package BodyOKL_REPORT_PVT - show dependent code
Package BodyPAY_HR_OTC_RETRIEVAL_INTERFACE - show dependent code
Package BodyPAY_MX_TRR_PKG - show dependent code
Package BodyPOS_PRODUCT_SERVICE_UTL_PKG - show dependent code
Package BodyPO_UDA_TEMPLATES_UTIL - show dependent code
Package BodyPO_WF_PO_CHARGE_ACC - show dependent code
Package BodyRRS_ATTR_PANE - show dependent code
Package BodyXLA_FLEX_PKG - show dependent code