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


VIEW: APPS.FND_ID_FLEX_SEGMENTS_VL

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

View Type

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


FND_ID_FLEX_SEGMENTS_VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
ADDITIONAL_WHERE_CLAUSE VARCHAR2 (4000)
APPLICATION_ID NUMBER (10) Yes Application identifier
ID_FLEX_CODE VARCHAR2 (4) Yes Key flexfield code
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure number
APPLICATION_COLUMN_NAME VARCHAR2 (30) Yes Flexfield column name
SEGMENT_NAME VARCHAR2 (30) Yes Segment name
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
SEGMENT_NUM NUMBER (3) Yes Segment number
APPLICATION_COLUMN_INDEX_FLAG VARCHAR2 (1) Yes Flag to indicate if the flexfield column is indexed
ENABLED_FLAG VARCHAR2 (1) Yes Flag to indicate if the segment is enabled
REQUIRED_FLAG VARCHAR2 (1) Yes Flag to indicate if a value must be entered for this segment
DISPLAY_FLAG VARCHAR2 (1) Yes Flag to indicate if the segment should be displayed
DISPLAY_SIZE NUMBER (3) Yes The display size of the segment
SECURITY_ENABLED_FLAG VARCHAR2 (1) Yes Flag to indicate if security is enabled for the segment
MAXIMUM_DESCRIPTION_LEN NUMBER (3) Yes The maximum description size for the segment
CONCATENATION_DESCRIPTION_LEN NUMBER (3) Yes The size of the concatenated flexfield description
FLEX_VALUE_SET_ID NUMBER (10)
Flexfield value set identifier
RANGE_CODE VARCHAR2 (1)
Range code can be High or Low
DEFAULT_TYPE VARCHAR2 (1)
Type of default value
DEFAULT_VALUE VARCHAR2 (2000)
The default value for the segment
RUNTIME_PROPERTY_FUNCTION VARCHAR2 (2000)
FORM_LEFT_PROMPT VARCHAR2 (80) Yes The left prompt for the segment in the flexfield window
FORM_ABOVE_PROMPT VARCHAR2 (80) Yes The above prompt for the segment in the flexfield window
DESCRIPTION VARCHAR2 (240)
Description
Query Text

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


SELECT ROW_ID
,      ADDITIONAL_WHERE_CLAUSE
,      APPLICATION_ID
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      APPLICATION_COLUMN_NAME
,      SEGMENT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SEGMENT_NUM
,      APPLICATION_COLUMN_INDEX_FLAG
,      ENABLED_FLAG
,      REQUIRED_FLAG
,      DISPLAY_FLAG
,      DISPLAY_SIZE
,      SECURITY_ENABLED_FLAG
,      MAXIMUM_DESCRIPTION_LEN
,      CONCATENATION_DESCRIPTION_LEN
,      FLEX_VALUE_SET_ID
,      RANGE_CODE
,      DEFAULT_TYPE
,      DEFAULT_VALUE
,      RUNTIME_PROPERTY_FUNCTION
,      FORM_LEFT_PROMPT
,      FORM_ABOVE_PROMPT
,      DESCRIPTION
FROM APPS.FND_ID_FLEX_SEGMENTS_VL;

Dependencies

[top of page]

APPS.FND_ID_FLEX_SEGMENTS_VL references the following:

SchemaAPPS
SynonymFND_ID_FLEX_SEGMENTS
SynonymFND_ID_FLEX_SEGMENTS_TL
APPS.FND_ID_FLEX_SEGMENTS_VL is referenced by following:

SchemaAPPS
Package BodyAP_CARD_UTILITY_PKG - show dependent code
Package BodyAP_WEB_ACCTG_PKG - show dependent code
Package BodyARP_FLEX - show dependent code
Package BodyCSP_ASL_PUB - show dependent code
Package BodyFLM_UTIL - show dependent code
Package BodyFND_FLEX_APIS - show dependent code
Package BodyFND_FLEX_DIAGNOSE - show dependent code
PL/SQL PackageFND_FLEX_KEY_API - show dependent code
Package BodyFND_FLEX_KEY_API - show dependent code
ViewFND_FLEX_KEY_SEG_VSET_V
Package BodyFND_FLEX_LOADER_APIS - show dependent code
Package BodyFND_FLEX_UPGRADE_UTILITIES - show dependent code
Package BodyFV_CFS_PKG - show dependent code
Package BodyFV_FUNDS_AVAILABLE_PKG - show dependent code
Package BodyFV_GEN_ARTRX_REIMB_PROC - show dependent code
Package BodyFV_REIMB_ACTIVITY_PROCESS - show dependent code
Package BodyFV_STATUS_OF_FUNDS_PKG - show dependent code
Package BodyFV_UTILITY - show dependent code
Package BodyGHG_ORGANIZATION_MAPPINGS_PKG - show dependent code
Package BodyGHG_ORG_ACCOUNT_MAPPINGS_PKG - show dependent code
Package BodyGHR_UTILITY - show dependent code
PL/SQL PackageGHR_UTILITY - show dependent code
Package BodyGL_GLWACCTR_XMLP_PKG - show dependent code
Package BodyGL_HISTORICAL_RATES_PKG - show dependent code
ViewHRFV_DETAILED_SPECIAL_INFO
Package BodyHRI_OPL_JOBH - show dependent code
Package BodyHR_ENTRY - show dependent code
Package BodyHR_ID_FLEX_STRUCTURE_INFO - show dependent code
Package BodyHR_KFLEX_UTILITY - show dependent code
Package BodyHR_MEE_VIEWS_GEN - show dependent code
Package BodyHR_REPORTS - show dependent code
Package BodyINVKBCGN - show dependent code
Package BodyINV_UTILITIES - show dependent code
Package BodyJA_CN_FA_ACS_EXPORT_PKG - show dependent code
Package BodyJA_CN_FSG_XML_BANK_PKG - show dependent code
Package BodyJA_CN_GL_BANK_EXP_PKG - show dependent code
Package BodyJA_CN_SI_BANK_DET_PKG - show dependent code
Package BodyJA_CN_SYSOPS_BANK_PKG - show dependent code
Package BodyJE_JEFIASDR_XMLP_PKG - show dependent code
Package BodyJE_ZZ_AUDIT_AP_PKG - show dependent code
Package BodyJTF_DIAGNOSTIC_COREAPI - show dependent code
Package BodyLNS_BILLING_BATCH_PUB - show dependent code
Package BodyOE_INLINE_FLEX - show dependent code
Package BodyOKL_ACCOUNTING_UTIL - show dependent code
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
Package BodyOKS_REV_DISTR_PUB - show dependent code
Package BodyOM_SETUP_VALID_PKG - show dependent code
Package BodyPAY_COST_ALLOCATION_SWI - show dependent code
Package BodyPAY_PAYGBSOE_XMLP_PKG - show dependent code
Package BodyPAY_PAYMENT_XML_PKG - show dependent code
Package BodyPAY_PAYROLL_XML_EXTRACT_PKG - show dependent code
Package BodyPAY_SLA_PKG - show dependent code
PL/SQL PackagePA_HR_COMPETENCE_UTILS - show dependent code
Package BodyPA_HR_COMPETENCE_UTILS - show dependent code
Package BodyPER_ASSIGNMENTS_F1_PKG - show dependent code
PL/SQL PackagePER_RI_CONFIG_TECH_SUMMARY - show dependent code
Package BodyPOS_PRODUCT_SERVICE_UTL_PKG - show dependent code
Package BodyPO_EDA_DATATEMPLATE_PKG - show dependent code
ViewPO_RULE_EXPENSE_ACCOUNTS_V
Package BodyPO_WF_PO_RULE_ACC - show dependent code
Package BodyPQP_HROSS_INTEGRATION - show dependent code
Package BodyPQP_OSS_DFF_UTILS - show dependent code
ViewPSP_LAYOUT_LOOKUP_CODE_V
Package BodyWMS_DEPLOY - show dependent code
Package BodyXLA_FLEX_PKG - show dependent code
Package BodyXLA_FLEX_UTIL - show dependent code
Package BodyXLA_JE_VALIDATION_PKG - show dependent code
Package BodyXLA_LINE_DEFINITIONS_PVT - show dependent code
ViewXLA_LINE_DEFN_ADR_ASSGNS_F_V
ViewXLA_MPA_JLT_ADR_ASSGNS_F_V
ViewXLA_PAD_INQ_LINES_AC_SD_FVL
ViewXLA_PAD_INQ_LINES_AF_FVL
ViewXLA_PAD_INQ_LINES_SD_FVL
ViewXLA_PAD_INQ_SEG_RULES_FVL
ViewXLA_PROD_SEG_RULES_FVL
ViewXLA_SEG_RULES_FVL
Package BodyZX_GEO_JUR_MIGR_PKG - show dependent code