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


VIEW: APPS.FND_DESCR_FLEX_COL_USAGE_VL

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

View Type

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


FND_DESCR_FLEX_COL_USAGE_VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
RUNTIME_PROPERTY_FUNCTION VARCHAR2 (2000)
RUNTIME_PROPERTY_FUNCTION
APPLICATION_ID NUMBER (10) Yes Application identifier
DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2 (40) Yes Descriptive flexfield name
DESCRIPTIVE_FLEX_CONTEXT_CODE VARCHAR2 (30) Yes Descriptive flexfield structure name
APPLICATION_COLUMN_NAME VARCHAR2 (30) Yes Column name
END_USER_COLUMN_NAME VARCHAR2 (30) Yes The 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) Yes Standard Who column
COLUMN_SEQ_NUM NUMBER (3) Yes The corresponding segment number for the column
ENABLED_FLAG VARCHAR2 (1) Yes Flag to indicate if the descriptive flexfield segment is enabled
REQUIRED_FLAG VARCHAR2 (1) Yes Flag to indicate whether a value must be entered for this segment
SECURITY_ENABLED_FLAG VARCHAR2 (1) Yes Flag to tell if security is enabled for this segment
DISPLAY_FLAG VARCHAR2 (1) Yes Flag to indicate whether to display the segment
DISPLAY_SIZE NUMBER (3) Yes The display size for the segment
MAXIMUM_DESCRIPTION_LEN NUMBER (3) Yes The maximum size of the segment value description in flexfield window
CONCATENATION_DESCRIPTION_LEN NUMBER (3) Yes The number of characters in the segment value description
FLEX_VALUE_SET_ID NUMBER (10)
Flexfield value set identifier
RANGE_CODE VARCHAR2 (1)
Code to indicate if this segment is a High or Low segment
DEFAULT_TYPE VARCHAR2 (1)
The type of the default value
DEFAULT_VALUE VARCHAR2 (2000)
The default value for the segment
SRW_PARAM VARCHAR2 (30)
The name of the Oracle Reports report parameter
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
,      RUNTIME_PROPERTY_FUNCTION
,      APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      APPLICATION_COLUMN_NAME
,      END_USER_COLUMN_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COLUMN_SEQ_NUM
,      ENABLED_FLAG
,      REQUIRED_FLAG
,      SECURITY_ENABLED_FLAG
,      DISPLAY_FLAG
,      DISPLAY_SIZE
,      MAXIMUM_DESCRIPTION_LEN
,      CONCATENATION_DESCRIPTION_LEN
,      FLEX_VALUE_SET_ID
,      RANGE_CODE
,      DEFAULT_TYPE
,      DEFAULT_VALUE
,      SRW_PARAM
,      FORM_LEFT_PROMPT
,      FORM_ABOVE_PROMPT
,      DESCRIPTION
FROM APPS.FND_DESCR_FLEX_COL_USAGE_VL;

Dependencies

[top of page]

APPS.FND_DESCR_FLEX_COL_USAGE_VL references the following:

SchemaAPPS
SynonymFND_DESCR_FLEX_COLUMN_USAGES
SynonymFND_DESCR_FLEX_COL_USAGE_TL
APPS.FND_DESCR_FLEX_COL_USAGE_VL is referenced by following:

SchemaAPPS
Package BodyAP_BAL_PKG - show dependent code
Package BodyAP_CHECK_PAYMT_SUPP_RPT_PKG - show dependent code
Package BodyAP_WEB_DB_EXPLINE_PKG - show dependent code
PL/SQL PackageAP_WEB_DFLEX_PKG - show dependent code
Package BodyAP_WEB_DISC_PKG - show dependent code
PL/SQL PackageAP_WEB_DISC_PKG - show dependent code
Package BodyAR_DEP_BAL_RPT_PKG - show dependent code
Package BodyCSM_MULTI_MOBQRY_PKG - show dependent code
Package BodyCSP_SHIP_TO_ADDRESS_PVT - show dependent code
Package BodyCS_SR_COST_CP - show dependent code
Package BodyCS_SR_PURGE_CP - show dependent code
Package BodyEDR_STANDARD - show dependent code
Package BodyEGO_PUBLICATION_PKG - show dependent code
Package BodyFA_RX_PUBLISH - show dependent code
PL/SQL PackageFND_DFLEX - show dependent code
Package BodyFND_DFLEX - show dependent code
ViewFND_FLEX_CONC_PARAM_VSET_V
ViewFND_FLEX_DESCR_SEG_VSET_V
Package BodyFND_FLEX_DIAGNOSE - show dependent code
Package BodyFND_FLEX_DSC_API - show dependent code
Package BodyFND_FLEX_UPGRADE_UTILITIES - show dependent code
Package BodyFND_PROGRAM - show dependent code
Package BodyFV_PO_VALIDATE_GRP - show dependent code
Package BodyGHG_EMISSION_RATES_PKG - show dependent code
Package BodyGHG_TRANSACTIONS_API_PKG - show dependent code
Package BodyHRI_OPL_JOBH - show dependent code
Package BodyHR_360_MESSAGE - show dependent code
Package BodyHR_CN_API - show dependent code
Package BodyHR_DESCR_FLEX_CONTEXT_INFO - show dependent code
Package BodyHR_REPORTS - show dependent code
Package BodyHXC_LOAD_PKG - show dependent code
PL/SQL PackageINV_LOT_SEL_ATTR - show dependent code
Package BodyINV_LOT_SEL_ATTR - show dependent code
ViewINV_LOT_SERIAL_COLUMNS_V
Package BodyINV_LOT_SERIAL_DATE_EVENT_PKG - show dependent code
Package BodyINV_MWB_TREE - show dependent code
Package BodyINV_MWB_TREE1 - show dependent code
Package BodyINV_UOM_API_PUB - show dependent code
Package BodyJA_CN_UTILITY - show dependent code
Package BodyJTF_RS_GROUP_REPORT_PUB - show dependent code
ViewMTL_LOT_SERIAL_DFF_ERV
Package BodyOE_AUDIT_HISTORY_PVT - 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
Package BodyOKC_QA_DATA_INTEGRITY - show dependent code
Package BodyOKC_RDS_PVT - show dependent code
ViewOKC_RULE_ATTS_BLK_V
Package BodyOKC_RULE_PUB - show dependent code
Package BodyOKC_RUL_PVT - show dependent code
Package BodyOKC_TIME_UTIL_PVT - show dependent code
Package BodyOKE_K_USER_ATTRIBUTES_PUB - show dependent code
Package BodyOKE_K_USER_ATTR_UTILS - show dependent code
Package BodyOKL_DEAL_CREAT_PVT - show dependent code
Package BodyOKL_LA_SALES_TAX_PVT - show dependent code
Package BodyOKL_RULE_APIS_PVT - show dependent code
Package BodyOKL_RULE_EXTRACT_PVT - show dependent code
PL/SQL PackageOKL_RULE_EXTRACT_PVT - show dependent code
Package BodyOKL_RULE_PUB - show dependent code
Package BodyOTA_CLASSIC_UPGRADE - show dependent code
Package BodyOTA_TRAINING_PLAN_UPGRADE - show dependent code
Package BodyOZF_OFFER_PVT - show dependent code
Package BodyPAY_AC_ACTION_ARCH - show dependent code
Package BodyPAY_AE_RULES - show dependent code
Package BodyPAY_ARCHIVE_CHEQUEWRITER - show dependent code
Package BodyPAY_CN_DEDUCTIONS - show dependent code
Package BodyPAY_DK_RULES - show dependent code
Package BodyPAY_FI_RULES - show dependent code
Package BodyPAY_GB_P11D_ARCHIVE_SS - show dependent code
Package BodyPAY_NL_NWR_XML_EXTRACT_PKG - show dependent code
Package BodyPAY_NO_RULES - show dependent code
Package BodyPAY_PAYROLL_XML_EXTRACT_PKG - show dependent code
Package BodyPAY_SE_RULES - show dependent code
Package BodyPAY_US_GEOCODE_REPORT_PKG - show dependent code
Package BodyPAY_US_PAYSLIP_SIMULATION_MAIN - show dependent code
Package BodyPER_PTU_DFF_MIG - show dependent code
Package BodyPER_RI_CONFIG_TECH_SUMMARY - show dependent code
Package BodyPER_RI_CONFIG_UTILITIES - show dependent code
Package BodyPER_RI_RT_UTIL_PKG - show dependent code
Package BodyPER_SSHR_CHANGE_PAY - show dependent code
Package BodyPN_INDEX_RENT_PVT - show dependent code
Package BodyPN_LEASE_PVT - show dependent code
Package BodyPN_VAREN_PVT - show dependent code
Package BodyPO_EDA_PKG - show dependent code
Package BodyPO_UDA_TEMPLATES_UTIL - show dependent code
TYPE BODYPO_UDA_USAGE_OBJECT
PL/SQL PackagePQP_UTILITIES - show dependent code
Package BodyQP_PRICE_LIST_LINE_UTIL - show dependent code
ViewQP_QUALIFIER_CONTEXT_V
PL/SQL PackageQP_UTIL - show dependent code
Package BodyQP_UTIL - show dependent code
Package BodyRLM_RD_SV - show dependent code
PL/SQL PackageWIP_EAM_WORKREQUEST_PVT - show dependent code
Package BodyWIP_EAM_WORKREQUEST_PVT - show dependent code
PL/SQL PackageWMS_ASN_LOT_ATT - show dependent code
Package BodyXTR_XTRMDTRP_XMLP_PKG - show dependent code