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
ViewAMW_AUDIT_UNITS_V
ViewAMW_AUDIT_UNITS_V_ALL
Package BodyAMW_IMPORT_STMNTS_ACCS_PKG - show dependent code
ViewAMW_LEGAL_HIER_V
ViewAMW_MANAG_HIER_V
ViewAMW_NATURAL_ACCT_V
Package BodyAMW_SCOPE_PVT - show dependent code
Package BodyAP_BAL_PKG - show dependent code
Package BodyAR_DEP_BAL_RPT_PKG - show dependent code
ViewBIL_DIMV_CREDIT_TYPE
ViewBIL_DIMV_RATING_FACTORS
ViewBIL_DIMV_TOP_BOTTOM
ViewBIS_GL_COMPANIES_V
ViewBIS_GL_SECONDARY_MEASURES_V
Package BodyCSF_TRIPS_PUB - show dependent code
Package BodyEDW_GL_ACCT_M_C - 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
ViewFII_COMPANY_VALUES_V
ViewFII_COST_CENTER_VALUES_V
Package BodyFND_FLEX_DIAGNOSE - 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
PL/SQL PackageFND_VSET - show dependent code
Package BodyFND_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_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
Package BodyIGI_EXP_HOLDS - show dependent code
Package BodyIGS_FI_GEN_007 - show dependent code
Package BodyJAI_AP_TDS_ETDS_PKG - show dependent code
Package BodyJAI_CMN_MTAX_PKG - show dependent code
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
ViewJL_CO_GL_NIT_ACCTS_V
Package BodyLNS_BILLING_BATCH_PUB - 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 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_WF_PO_CHARGE_ACC - show dependent code
Package BodyPSB_FLEX_MAPPING_PVT - show dependent code
ViewPSB_FLEX_MAPPING_SET_VALUES_V
Package BodyXLA_FLEX_PKG - show dependent code