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

VIEW: APPS.CZ_LOOKUP_VALUES_VL

Object Details
Object Name: CZ_LOOKUP_VALUES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_LOOKUP_VALUES_VL
Subobject Name:
Status: VALID


CZ_LOOKUP_VALUES_VL is a localized view collecting all sets of lookup values, organized into groups via its LIST_NAME column. This view underlies the "lookup views," which can be recognized by the suffix "_LKV". For example, CZ_CFG_SEARCHCRITERIA_LKV is a lookup view selecting data from CZ_LOOKUP_VALUES_VL using a 'search criteria' identifier for LIST_NAME.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LIST_NAME VARCHAR2 (50) Yes
DATA_VALUE VARCHAR2 (255) Yes
VALUE_SEQ NUMBER

DATA_TYPE_ID NUMBER
Yes
NULL_VALUE_FLAG VARCHAR2 (1)
VALUE_LABEL VARCHAR2 (255)
VALUE_DESCRIPTION VARCHAR2 (4000)
VALUE_NOTES CLOB (4000)
LANGUAGE VARCHAR2 (4) Yes
SOURCE_LANG VARCHAR2 (4) Yes
CREATION_DATE DATE
Yes Standard field recording the date this record was created
LAST_UPDATE_DATE DATE
Yes Standard field recording the date/time this record was last updated
CREATED_BY NUMBER (15) Yes Standard field recording the ID of the user that created this record
LAST_UPDATED_BY NUMBER (15) Yes Standard field recording the ID of the user that last updated this record
LAST_UPDATE_LOGIN NUMBER

NUMERIC_ID_VALUE NUMBER

Query Text

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


SELECT LIST_NAME
,      DATA_VALUE
,      VALUE_SEQ
,      DATA_TYPE_ID
,      NULL_VALUE_FLAG
,      VALUE_LABEL
,      VALUE_DESCRIPTION
,      VALUE_NOTES
,      LANGUAGE
,      SOURCE_LANG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NUMERIC_ID_VALUE
FROM APPS.CZ_LOOKUP_VALUES_VL;

Dependencies

[top of page]

APPS.CZ_LOOKUP_VALUES_VL references the following:

SchemaAPPS
SynonymCZ_LOOKUP_VALUES
SynonymCZ_LOOKUP_VALUES_TL
APPS.CZ_LOOKUP_VALUES_VL is referenced by following:

SchemaAPPS
ViewCZ_ACCESS_SUMMARY_LKV
ViewCZ_ACTIONDISPLAYUPDT_LKV
ViewCZ_ACTIONMODELINTER_LKV
ViewCZ_ACTIONNAV_LKV
ViewCZ_ACTIONONRULENODES_LKV
ViewCZ_ACTIONSESSIONCTRL_LKV
ViewCZ_ACTIONSONMODELNODES_LKV
ViewCZ_ACTIONSONREPOSITORYN_LKV
ViewCZ_ACTIONTYPEGROUP_LKV
ViewCZ_AMPM_LKV
ViewCZ_ANYALLTRUE_LKV
ViewCZ_ASSOCIATEDMODELNODE_LKV
ViewCZ_BASIC_LAYOUT_REGION_LKV
ViewCZ_BOOLFEATINITTYPES_LKV
ViewCZ_CAPCONFIGSYSPROP_LKV
ViewCZ_CAPMSGSYSPROP_LKV
ViewCZ_CAPNODESYSPROP_LKV
ViewCZ_CFGEXT_ARGS_SPEC_TYPE_LKV
ViewCZ_CFGEXT_EVENT_SCOPE_LKV
ViewCZ_CFGEXT_INST_SCOPE_LKV
ViewCZ_CFGEXT_SYSTEM_PARAMS_LKV
ViewCZ_CFG_SAVEASBEHAVIOR_LKV
ViewCZ_CFG_SEARCHCRITERIA_LKV
ViewCZ_CONFIG_SELECTION_TYPE_LKV
ViewCZ_COPYDESTINATION_LKV
ViewCZ_COPYSOURCE_LKV
ViewCZ_CREATEOPTIONPSNODETY_LKV
ViewCZ_CREATEPSNODEPSNODETY_LKV
ViewCZ_CREATEREPOSITORYOBJE_LKV
ViewCZ_CREATEUICONTENT_LKV
ViewCZ_DATATYPE_LKV
ViewCZ_DETAILEDRULETYPES_LKV
ViewCZ_DETLSELECTIONSTATE_LKV
ViewCZ_DOMAINORDERINGCHOICES_LKV
ViewCZ_DRILLDOWNTXTYPES_LKV
ViewCZ_EFFECTIVITYMETHODS_LKV
ViewCZ_EFFECTIVITYTYPE_LKV
ViewCZ_EXNEXPRTYPE_LKV
ViewCZ_FEATURETYPE_LKV
ViewCZ_GROUPED_ACTION_TYPES_V
ViewCZ_HORIZONTALALIGNMENT_LKV
ViewCZ_HOURS_LKV
ViewCZ_ICONLOOKUP_LKV
ViewCZ_IMAGEUSAGECODES_LKV
ViewCZ_ITEMMASTEROPS_LKV
ViewCZ_ITEMTYPEOPERATOR_LKV
ViewCZ_ITEMTYPE_LKV
ViewCZ_JAVASYSPROPVALS_LKV
ViewCZ_LAYOUTREGIONS_LKV
ViewCZ_LAYOUT_UI_STYLE_LKV
ViewCZ_LISTLAYOUTREGIONS_LKV
ViewCZ_LOGICRULE_LKV
ViewCZ_MDLNODE_CPDST_LKV
ViewCZ_MDLNODE_CPSRC_LKV
ViewCZ_MENUITEMTYPES_LKV
ViewCZ_MENUTYPES_LKV
ViewCZ_MINUTES_LKV
ViewCZ_MODEL_LOGICSTATE_PROPS_LKV
ViewCZ_MSGLISTLAYOUTREGIONS_LKV
ViewCZ_NODEINSTANTIABILITY_LKV
ViewCZ_NODELISTLAYOUTREGIONS_LKV
ViewCZ_NODELIST_LAYOUT_REGION_LKV
ViewCZ_OTHERCONTENT_LKV
ViewCZ_OUTERTEMPLAMN_LKV
ViewCZ_PAGE_ELEMENT_CHILDREN_CV
ViewCZ_PAGE_ELEMENT_CHILDREN_V
ViewCZ_PROCESSPAGECAPTIONTYPES_LKV
ViewCZ_PSNODERELATION_LKV
ViewCZ_PSNODETYPE_LKV
ViewCZ_PUBLICATIONMODE_LKV
ViewCZ_RECALCULATEPRICES_LKV
ViewCZ_REPOSCREATEOPS_LKV
ViewCZ_REPOSITORYCOPYDESTIN_LKV
ViewCZ_REPOSITORYCOPYMODELO_LKV
ViewCZ_RPOBJECTTYPES_LKV
ViewCZ_RTCONDCOMPAR_LKV
ViewCZ_RTCONDOBJSETTINGS_LKV
ViewCZ_RTCONDOBSET_FOR_SP_TEMP_LKV
ViewCZ_RTINFO_TEMPLTYPES_LKV
ViewCZ_RULERADIOGROUP_LKV
ViewCZ_RULETYPECODES_LKV
ViewCZ_RULEUNSATMESSAGECHOI_LKV
ViewCZ_RULEVIOLATIONMESSAGE_LKV
ViewCZ_RULE_CLASS_LKV
ViewCZ_SIGNATURETYPES_LKV
ViewCZ_SIMPLECONTROLS_LKV
ViewCZ_SORTORDER_LKV
ViewCZ_SOURCEENTITYTYPES_LKV
ViewCZ_STDBUTTON_ATTRS_LKV
ViewCZ_SUBTYPEBOMMODEL_LKV
ViewCZ_SUBTYPEBOMOPTIONCLAS_LKV
ViewCZ_SUBTYPEBOMSTDITEM_LKV
ViewCZ_SUBTYPECOMPONENT_LKV
ViewCZ_SUBTYPEFEATUREGROUP_LKV
ViewCZ_SUBTYPEFEATURE_LKV
ViewCZ_SUBTYPEOPTION_LKV
ViewCZ_SUBTYPEPRODUCT_LKV
ViewCZ_SUBTYPERESOURCE_LKV
ViewCZ_SUBTYPETOTAL_LKV
ViewCZ_TEXTINPUTCAPPROPS_LKV
ViewCZ_TLCOL_RT_COND_OBJS_LKV
ViewCZ_UCTMESSAGETYPE_LKV
ViewCZ_UCT_PARNTCONTTY_LKV
ViewCZ_UICOMPONENTS_LKV
ViewCZ_UICOPYDESTINATION_LKV
ViewCZ_UITEMPL_RTCOND_BINDSRC_LKV
ViewCZ_UI_HGRID_ACTIONS_LKV
ViewCZ_UI_ITEMSELECT_TYPES_V
ViewCZ_UI_MSTTMP_BOMCON_UILAY_LKV
ViewCZ_UI_MSTTMP_CNTRLLAYOUT_LKV
ViewCZ_UI_MSTTMP_NBOMCON_UILAY_LKV
ViewCZ_UI_MSTTMP_PAGINATION_LKV
ViewCZ_UI_MSTTMP_PAG_CMP_LKV
ViewCZ_UI_MSTTMP_PAG_DDNCTRL_LKV
ViewCZ_UI_MSTTMP_PAG_NOC_LKV
ViewCZ_UI_MSTTMP_PAG_REF_LKV
ViewCZ_UI_MSTTMP_PRINAV_LKV
ViewCZ_UI_MSTTMP_SUPDIS_LKV
ViewCZ_UI_MSTTMP_TMPUSG_LKV
ViewCZ_UI_MSTTMP_TMPUSG_MSGUTL_LKV
ViewCZ_VALIDRESULTFORCOMPON_LKV
ViewCZ_VALIDRESULTFOROPTFEA_LKV
ViewCZ_VALID_RESULT_TYPES_V
ViewCZ_VERTICALALIGNMENT_LKV
ViewCZ_VIEWBYSELECTION_LKV