CZ Subschemas

This appendix lists the CZ tables that make up each of the subschemas in the CZ schema. For table details, see the CZ eTRM on MetaLink, Oracle’s technical support Web site.

This appendix covers the following topics:

• Oracle Configurator Subschemas

Oracle Configurator Subschemas

The following sections list the tables in each subschema. For detailed information about these and other tables, see the CZ eTRM on MetaLink, Oracle’s technical support Web site.

ADMN Administrative Tables

These tables are uses for customizable site parameters and auditing information.

• CZ_DB_LOGS

• CZ_DB_SETTINGS

• CZ_DB_SIZES

CNFG Configuration Tables

These tables hold configuration information.

• CZ_CONFIG_ATTRIBUTES

• CZ_CONFIG_CONTENTS_V

• CZ_CONFIG_DETAILS_V

• CZ_CONFIG_EXT_ATTRIBUTES

• CZ_CONFIG_HDRS

• CZ_CONFIG_HDRS_V

• CZ_CONFIG_INPUTS

• CZ_CONFIG_ITEMS

• CZ_CONFIG_ITEMS_V

• CZ_CONFIG_MESSAGES

• CZ_CONFIG_MESSAGES_V

• CZ_CONFIG_USAGES

ITEM Item-Master Tables

Thefollowing tables store information about Items that are used to build a Model:

• CZ_IMP_ITEM_MASTER

• CZ_IMP_ITEM_PROPERTY_VALUE

• CZ_IMP_ITEM_TYPE

• CZ_IMP_ITEM_TYPE_PROPERTY

• CZ_IMP_PROPERTY

• CZ_ITEM_MASTERS

• CZ_ITEM_PROPERTY_VALUES

• CZ_ITEM_TYPES

• CZ_ITEM_TYPE_PROPERTIES

• CZ_PROPERTIES

LCE Logic for Configuration Tables

These tables store the generated logic for a Model.

• CZ_LCE_CLOBS

• CZ_LCE_HEADERS

• CZ_LCE_LINES

• CZ_LCE_LOAD_SPECS

• CZ_LCE_OPERANDS

• CZ_LCE_TEXTS

PB Publication Tables

These tables store information that is used when publishing a Model.

• CZ_EFFECTIVITY_SETS

• CZ_EXT_APPLICATIONS

• CZ_EXT_APPLICATIONS_V

• CZ_MODEL_PUBLICATIONS

• CZ_MODEL_USAGES

• CZ_MODEL_USAGES_TL

• CZ_PB_CLIENT_APPS

• CZ_PB_LANGUAGES

• CZ_PB_MODEL_EXPORTS

• CZ_PB_TEMP_IDS

• CZ_PUBLICATION_USAGES

• CZ_SRC_MODEL_PUBLICATIONS_V

PRC Pricing Tables

These tables are used to pass pricing and configuration information to a PL/SQL callback procedure that is used for calculating ATP (availability-to-promise).

• CZ_ATP_REQUESTS

• CZ_PRICING_STRUCTURES

PROJ Project Structure Tables

These tables are used to store project information in Oracle Configurator Developer for building configuration models.

• CZ_COMMON_CHILDNDPROPS_V

• CZ_CONVERSION_RELS_V

• CZ_DATA_TYPES_V

• CZ_DEVL_PROJECTS

• CZ_EXPLMODEL_NODES_V

• CZ_EXPLNODES_WITHIMAGES_V

• CZ_FUNC_COMP_SPECS

• CZ_IMP_DEVL_PROJECT

• CZ_IMP_MODEL_REF_EXPLS

• CZ_IMP_PS_NODES

• CZ_MODELS_V

• CZ_MODEL_ARCHIVES_V

• CZ_MODEL_BOMREF_COUNTS_V

• CZ_MODEL_REF_EXPLS

• CZ_NODE_CAPTION_PROPERTIES_V

• CZ_NODE_JAVA_PROPERTIES_V

• CZ_NODE_NO_PROPERTIES_V

• CZ_NODE_RULE_PROPERTIES_V

• CZ_NODE_USER_PROPERTIES_V

• CZ_POPULATORS

• CZ_PSNODE_REFRULE_IMAGES_V

• CZ_PSNODE_REFUI_IMAGES_V

• CZ_PSNODE_RULE_REFS_V

• CZ_PSNODE_WITH_UIREFS_V

• CZ_PS_NODES

• CZ_PS_PROP_VALS

• CZ_SRC_DEVL_PROJECTS_V

• CZ_SYSTEM_PROPERTIES_V

• CZ_SYSTEM_PROPERTY_RELS_V

• CZ_TEMPLATE_DEFS_V

• CZ_TERMINATE_MSGS

• CZ_TERMINATE_MSGS_V

• CZ_TGT_MODEL_PUBLICATIONS_V

RP Repository Tables

These tables are used for actions performed in the Repository as well as references to Models, Effectivity Sets, and Usages.

• CZ_ACCESS_SUMMARY_LKV

• CZ_ACTIONDISPLAYUPDT_LKV

• CZ_ACTIONMODELINTER_LKV

• CZ_ACTIONNAV_LKV

• CZ_ACTIONRULENODES_LKV

• CZ_ACTIONSESSIONCTRL_LKV

• CZ_ACTIONSONMODELNODES_LKV

• CZ_ACTIONSONREPOSITORYN_LKV

• CZ_ACTIONTYPEGROUP_LKV

• CZ_AMPM_LKV

• CZ_ANYALLTRUE_LKV

• CZ_ARCHIVES

• CZ_ARCHIVES_PICKER_V

• CZ_ARCHIVE_REFS

• CZ_ASSOCIATEDMODELNODE_LKV

• CZ_BASIC_LAYOUT_REGION_LKV

• CZ_CAPCONFIGSYSPROP_LKV

• CZ_CAPMSGSYSPROP_LKV

• CZ_CAPNODESYSPROP_LKV

• CZ_CFGEXT_ARGS_SPEC_TYPE_LKV

• CZ_CFGEXT_EVENT_SCOPE_LKV

• CZ_CFGEXT_INST_SCOPE_LKV

• CZ_CFGEXT_SYSTEM_PARAMS_LKV

• CZ_CFG_SAVEASBEHAVIOR_LKV

• CZ_CFG_SEARCHCRITERIA_LKV

• CZ_COMPAT_TEMPL_SIGS_V

• CZ_COPYDESTINATION_LKV

• CZ_COPYSOURCE_LKV

• CZ_CREATEOPTIONPSNODETY_LKV

• CZ_CREATEPSNODEPSNODETY_LKV

• CZ_CREATEREPOSITORYOBJE_LKV

• CZ_CREATERULEOBJECT_LKV

• CZ_DATATYPE_LKV

• CZ_DETAILEDRULETYPES_LKV

• CZ_DETLSELECTIONSTATE_LKV

• CZ_EFFECTIVITYMETHODS_LKV

• CZ_EFFECTIVITYTYPE_LKV

• CZ_EFFSETS_PICKER_V

• CZ_EVENTTYPES_LKV

• CZ_EXNEXPRTYPE_LKV

• CZ_FEATURETYPE_LKV

• CZ_HORIZONTALALIGNMENT_LKV

• CZ_HOURS_LKV

• CZ_ICONLOOKUP_LKV

• CZ_IMAGELOOKUPS_V

• CZ_ITEMMASTEROPS_LKV

• CZ_ITEMTYPEOPERATOR_LKV

• CZ_ITEMTYPE_LKV

• CZ_JAVASYSPROPVALS_LKV

• CZ_LAYOUTREGIONS_LKV

• CZ_LAYOUT_UI_STYLE_LKV

• CZ_LISTLAYOUTREGIONS_LKV

• CZ_LOCK_HISTORY

• CZ_LOGICRULE_LKV

• CZ_LOOKUP_VALUES

• CZ_LOOKUP_VALUES_VL

• CZ_MDLNODE_CPDST_LKV

• CZ_MDLNODE_CPSRC_LKV

• CZ_MENUITEMTYPES_LKV

• CZ_MENUTYPES_LKV

• CZ_MINUTES_LKV

• CZ_MODEL_REFERENCES_PICKER_V

• CZ_MSGLISTLAYOUTREGIONS_LKV

• CZ_NODEINSTANTIABILITY_LKV

• CZ_NODELISTLAYOUTREGIONS_LKV

• CZ_NODELIST_LAYOUT_REGION_LKV

• CZ_OTHERCONTENT_LKV

• CZ_PROPERTY_PICKER_V

• CZ_PSNODERELATION_LKV

• CZ_PSNODETYPE_LKV

• CZ_PUBLICATIONMODE_LKV

• CZ_RECALCULATEPRICES_LKV

• CZ_REPOSCREATEOPS_LKV

• CZ_REPOSITORYCOPYDESTIN_LKV

• CZ_REPOSITORYCOPYMODELO_LKV

• CZ_REPOSITORY_MAIN_HGRID_V

• CZ_REPOS_TREE_V

• CZ_RPOBJECTTYPES_LKV

• CZ_RP_BOM_MODELS_V

• CZ_RP_DIRECTORY_V

• CZ_RP_EFF_DIRECTORY_V

• CZ_RP_ENTRIES

• CZ_RP_PRJ_DIRECTORY_V

• CZ_RP_USG_DIRECTORY_V

• CZ_RTCONDCOMPAR_LKV

• CZ_RTCONDOBJSETTINGS_LKV

• CZ_RULERADIOGROUP_LKV

• CZ_RULETYPECODES_LKV

• CZ_RULEUNSATMESSAGECHOI_LKV

• CZ_RULEVIOLATIONMESSAGE_LKV

• CZ_SERVERS

• CZ_SIMPLECONTROLS_LKV

• CZ_SORTORDER_LKV

• CZ_SOURCEENTITYTYPES_LKV

• CZ_SUBTYPEBOMMODEL_LKV

• CZ_SUBTYPEBOMOPTIONCLAS_LKV

• CZ_SUBTYPEBOMSTDITEM_LKV

• CZ_SUBTYPECOMPONENT_LKV

• CZ_SUBTYPEFEATURE_LKV

• CZ_SUBTYPEFEATUREGROUP_LKV

• CZ_SUBTYPEOPTION_LKV

• CZ_SUBTYPEPRODUCT_LKV

• CZ_SUBTYPERESOURCE_LKV

• CZ_SUBTYPETOTAL_LKV

• CZ_UCTMESSAGETYPE_LKV

• CZ_UCT_PARNTCONTTY_LKV

• CZ_UI_HGRID_ACTIONS_LKV

• CZ_UI_MSTTMP_BOMCON_UILAY_LKV

• CZ_UI_MSTTMP_CNTRLLAYOUT_LKV

• CZ_UI_MSTTMP_NBOMCON_UILAY_LKV

• CZ_UI_MSTTMP_PAGINATION_LKV

• CZ_UI_MSTTMP_PAG_CMP_LKV

• CZ_UI_MSTTMP_PAG_DDNCTRL_LKV

• CZ_UI_MSTTMP_PAG_NOC_LKV

• CZ_UI_MSTTMP_PAG_REF_LKV

• CZ_UI_MSTTMP_PRINAV_LKV

• CZ_UI_MSTTMP_SUPDIS_LKV

• CZ_UI_MSTTMP_TMPUSG_LKV

• CZ_UI_MSTTMP_TMPUSG_MSGUTL_LKV

• CZ_USAGES_PICKER_V

• CZ_VALIDRESULTFORCOMPON_LKV

• CZ_VALIDRESULTFOROPTFEA_LKV

• CZ_VERTICALALIGNMENT_LKV

• CZ_VIEWBYSELECTION_LKV

RULE Rule Tables

These tables hold Rule information and information on the participants in a rule.

• CZ_COMBO_FEATURES

• CZ_COMPATCELL_NODE_V

• CZ_DES_CHART_CELLS

• CZ_DES_CHART_COLUMNS

• CZ_DES_CHART_FEATURES

• CZ_EXPRESSION_NODES

• CZ_FILTER_SETS

• CZ_GRID_CELLS

• CZ_GRID_COLS

• CZ_GRID_DEFS

• CZ_IMP_RULES

• CZ_MODELRULEFOLDER_IMAGES_V

• CZ_MODEL_ALL_RULEFOLDERS_V

• CZ_NODETYPE_SYSPROPS_V

• CZ_NODE_USAGE_IN_RULES_V

• CZ_PSN_TYPED_RULE_REFS_V

• CZ_RULES

• CZ_RULES_WITH_ARGS_V

• CZ_RULETEMPLS_BYLABEL_V

• CZ_RULE_EXPRDETLS_V

• CZ_RULE_EXPRESSION_V

• CZ_RULE_FOLDERS

• CZ_RULE_PARTICIPANTS_V

• CZ_RUL_TYPEDPSN_V

• CZ_TYPED_RULES_V

TXT - Text Tables

These tables store the text that is displayed during runtime Configurator as well as MLS information.

• CZ_IMP_LOCALIZED_TEXTS

• CZ_LOCALIZED_TEXTS

TYP - Data Typing

These tables store the various types of Model nodes, the structure of rule templates, and the elements contained in generated User Interfaces.

• CZ_DATA_SUBTYPES_V

• CZ_NODETYPE_PROPERTIES_V

• CZ_NODE_DISPCOND_PROPERTIES_V

• CZ_PARENT_CHILD_RELS_V

• CZ_TYPE_RELATIONSHIPS

• CZ_VALID_RESULT_TYPES_V

UI User Interface Tables

These tables store information that is used in the User Interfaces, such as image information, UI actions, messages, User Interface references, and so on.

• CZ_JRAD_CHUNKS

• CZ_PS_UI_CTRL_MAPS

• CZ_PSNODETYPE_IMAGES_V

• CZ_RULETYPE_IMAGES_V

• CZ_UIDEF_SIGNATURE_TEMPLS_V

• CZ_UIELEMENT_IMAGES_V

• CZ_UITEMPLS_FOR_PSNODES_V

• CZ_UITEMPL_CONTROLS_V

• CZ_UITEMPL_MESSAGES_V

• CZ_UITEMPL_UTILITY_V

• CZ_UI_ACTIONS

• CZ_UI_COLLECT_TMPLS_V

• CZ_UI_CONT_TYPE_TEMPLS

• CZ_UI_CONT_TYPE_TEMPLS_VV

• CZ_UI_DEFS

• CZ_UI_ELEMENT_ATTRIBUTES_V

• CZ_UI_IMAGES

• CZ_UI_NODES

• CZ_UI_NODE_PROPS

• CZ_UI_PAGES

• CZ_UI_PAGE_ELEMENTS

• CZ_UI_PAGE_REFS

• CZ_UI_PAGE_SETS

• CZ_UI_PATHED_IMAGES_V

• CZ_UI_PROPERTIES

• CZ_UI_REFS

• CZ_UI_REF_TEMPLATES

• CZ_UI_TEMPLATES_VV

• CZ_UI_TEMPLATES

• CZ_UI_TYPEDPSN_V

• CZ_UI_XMLS

XFR Transfer Specifications and Control Tables

These tables contain information that is used during import.

• CZ_XFR_FIELDS

• CZ_XFR_PROJECT_BILLS

• CZ_XFR_RUN_INFOS

• CZ_XFR_RUN_RESULTS

• CZ_XFR_STATUS_CODES

• CZ_XFR_TABLES