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

VIEW: APPS.CZ_UI_TYPEDPSN_V

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


CZ_UI_TYPEDPSN_V lists each Configurator Model Nodes with its 'detailed' type, that is, the node subtype that is the most precise description of that node's characteristics. This view interprets the node from the standpoint of UI Generation and Refresh. (See also CZ_RUL_TYPEDPSN_V).


[View Source]

Columns
Name Datatype Length Mandatory Comments
PS_NODE_ID NUMBER (15) Yes PK. PSNode identifier
DEVL_PROJECT_ID NUMBER (15)
Identifier of the project (root psnode ID)
NAME VARCHAR2 (1000)
Name for this product-structure node. Can be used for UI gen, otherwise used only in modelling.
PARENT_ID NUMBER (15)
Node identifier of the parent node
PS_NODE_TYPE NUMBER (9) Yes Product node type: ROOT = 256; FOLDER =257; PRODUCT = 258; COMPONENT = 259; FEATURE_GROUP = 260; FEATURE = 261; OPTION = 262; MODEL-REFERENCE = 263; TOTAL = 272; RESOURCE = 273; BOM_MODEL = 436; BOM_OPTION_CLASS = 437; BOM_STD_ITEM = 438
FEATURE_TYPE NUMBER (9)
Feature type: 0-option;1-integer;2-decimal;3-boolean;4-text
REFERENCE_ID NUMBER (15)
For reference-type nodes, identifies the model/root node to which this reference points
COUNTED_OPTIONS_FLAG VARCHAR2 (1)
Flag indicating if option can be counted vs. selected
TREE_SEQ NUMBER (9) Yes Provides an ordering of this node among other nodes with the same PARENT_ID
PRODUCT_FLAG VARCHAR2 (1)
Flag indicating if node is a product type node
RESOURCE_FLAG VARCHAR2 (1)
Flag indicating if node is a resource node type
COMPONENT_ID NUMBER
Yes Enclosing component of ps node. Populated by new procedure cz_refs.populate_component_id. Will be made NOT NULL in next schema revision.
INITIAL_NUM_VALUE NUMBER

For storage of numeric initial values
INITIAL_VALUE VARCHAR2 (4000)
Node initial value
INSTANTIABLE_FLAG VARCHAR2 (1)
From underlying CZ_PS_NODES record. INSTANTIABLE_FLAG records the user's intended instantiation behavior for Component and Reference structure nodes. '1' indicates an Optional node (minimum 0 instances, maximum 1 instance); '2' indicates a Mandatory or Single instance (1, 1) node; '4' indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. Also, the value '3' is used for Connectors.
MAXIMUM NUMBER

For BOM Models and BOM Option Classes: maximum count of this node when it is selected. For Component nodes: maximum number of (distinct) instances allowed. For Option-list Feature nodes: maximum allowed number of selected children. For Numeric Feature nodes: maximum value allowed. For References to Component models: maximum number of (distinct) instances allowed. For References to BOM models: maximum instances, effectively always 1.
MAXIMUM_SELECTED NUMBER (9)
Only used with regard to BOM nodes. For BOM Model or BOM Option-class nodes: maximum number of child nodes allowed to be selected. For Reference nodes pointing to BOM model: maximum count of the BOM Model node when it is selected. NOTE if the reference node exists in a Component model, this value is treated as -1, i.e. no maximum.
MINIMUM NUMBER

For BOM Models and BOM Option Classes: count of this node when it is selected. For Component nodes: minimum number of (distinct) instances required. For Option-list Feature nodes: minimum required number of selected children. For Numeric Feature nodes: minimum value allowed. For References to Component models: minimum number of (distinct) instances required. For References to BOM models: minimum instances, effectively always 1.
MINIMUM_SELECTED NUMBER (9)
Only used with regard to BOM nodes. For BOM Model or BOM Option-class nodes: minimum number of child nodes required to be selected. For Reference nodes pointing to BOM model: minimum count of the BOM Model node when it is selected. NOTE if the reference node exists in a Component model, this value is effectively always zero.
VIRTUAL_FLAG VARCHAR2 (1)
Flag indicating if node may have only one instance (virtual, '1') or different number of instances (non-virtual, '0'). Used for component nodes only.
UI_OMIT VARCHAR2 (1)
Flag indicating whether or not this node should appear as a selection in your Oracle SellingPoint application
UI_SECTION NUMBER (9)
UNUSED
COMPONENT_SEQUENCE_PATH VARCHAR2 (2000)
Path of component_sequence_ids applicable to psnodes imported from Oracle BOM
FROM_POPULATOR_ID NUMBER (9)
Identifier of the populator that created this psnode
PROPERTY_BACKPTR NUMBER (9)
Identifier of property if property was used to populate this node
ITEM_TYPE_BACKPTR NUMBER (9)
Item type identifier if item type was used to populate this node
INTL_TEXT_ID NUMBER (15)
ID of the node's description in CZ_LOCALIZED_TEXTS
ITEM_ID NUMBER (9)
Identifier of the item associated with this psnode
ORIG_SYS_REF VARCHAR2 (1200)
On imported nodes, identifies the record from which this psnode was imported
MULTI_CONFIG_FLAG VARCHAR2 (1)
UNUSED
ORDER_SEQ_FLAG VARCHAR2 (1)
UNUSED
SYSTEM_NODE_FLAG VARCHAR2 (1)
Reserved for system use
BOM_TREATMENT NUMBER (9)
Field indicating how imported node will be displayed: skip=1; Leaf=2;Flatten=3
COMPONENT_SEQUENCE_ID NUMBER (15)
Component unique identifier value imported with BOM records
BOM_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating if the node is optional or required in BOM _EXPLOSIONS table. Used for imported models only
SO_ITEM_TYPE_CODE VARCHAR2 (30)
Item type code used in Order Entry: Model, Class, Kit, Standard
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
DELETED_FLAG VARCHAR2 (1) Yes Indicates ('1'/'0') that this record has been deleted
EFF_FROM DATE

UNUSED
EFF_TO DATE

UNUSED
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
SECURITY_MASK VARCHAR2 (40)
UNUSED
EFF_MASK VARCHAR2 (40)
UNUSED
CHECKOUT_USER VARCHAR2 (100)
UNUSED
USER_NUM01 NUMBER (16)
User defined numeric field. Not currently used
USER_NUM02 NUMBER (16)
User defined numeric field. Not currently used
USER_NUM03 NUMBER (16)
User defined numeric field. Not currently used
USER_NUM04 NUMBER (16)
User defined numeric field. Not currently used
USER_STR01 VARCHAR2 (255)
User defined char field. Not currently used
USER_STR02 VARCHAR2 (255)
User defined char field. Not currently used
USER_STR03 VARCHAR2 (255)
User defined char field. Not currently used
USER_STR04 VARCHAR2 (255)
User defined char field. Not currently used
LAST_UPDATE_LOGIN NUMBER (15)
UNUSED
VIOLATION_TEXT_ID NUMBER (15)
Associates a CZ_LOCALIZED_TEXTS text with this node to serve as a violation message when, at runtime, an assertion contradicts a fundamental attribute of the psnode. (This text is not used when an explicit rule is violated; the rule bears its own text reference for that case.) Presently only Resources and Totals are involved since only they have intrinsic attributes that an assertion can violate.
EFFECTIVITY_SET_ID NUMBER (9)
Identifies the named effectivity set associated with this record
EFFECTIVE_FROM DATE

Date beginning on which this data is effective
EFFECTIVE_UNTIL DATE

Date at which this data is no longer effective. Note this is EXCLUSIVE.
EFFECTIVE_USAGE_MASK VARCHAR2 (16) Yes Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE
DECIMAL_QTY_FLAG VARCHAR2 (1) Yes '1' indicates the item described by this record is measured in fractional quantities; '0' indicates quantities must be whole/units
PERSISTENT_NODE_ID NUMBER (15) Yes Persistent ID (preserved in copies) of this product-structure node
QUOTEABLE_FLAG VARCHAR2 (1)
Indicates this item can be separately quoted.
PRIMARY_UOM_CODE VARCHAR2 (3)
Indicates the primary unit of measure for this item.
BOM_SORT_ORDER VARCHAR2 (4000)
Holds the 'sort order' value for nodes imported from Oracle Bills of Material (denormalization)
IB_TRACKABLE VARCHAR2 (1)
Flag indicating whether this item is trackable through Installed Base; imported from MTL_SYSTEM_ITEMS
ACCUMULATOR_FLAG VARCHAR2 (1)
1' - create a '_ACC' accumulator for this node;
NOTES_TEXT_ID NUMBER

FK to cz_notes_text_lines
DISPLAYNAME_CAPT_RULE_ID NUMBER

Reference a caption rule ID to be used in rendering the DISPLAYNAME for the node as an alternative to a general INTL_TEXT_ID. etc
SRC_APPLICATION_ID NUMBER

PK. Value for existing records will be 708 (CZ).
MAX_TEXT_LENGTH NUMBER

Will currently be used to store max length of text feature display box in UI
DISPLAYNAME_TEXT_ID NUMBER

New translateable field for “display name”
SUB_CONS_ID NUMBER (9)
UNUSED
MAX_LENGTH NUMBER

Maximum length restriction for a text feature.
DETAILED_TYPE_ID NUMBER

REGION_FLAG VARCHAR2 (4000)
PARENT_PERSISTENT_NODE_ID NUMBER

DISPLAY_IN_SUMMARY_FLAG VARCHAR2 (1)
TRANSIENT_FLAG VARCHAR2 (1)
IB_LINK_ITEM_FLAG VARCHAR2 (1)
SHIPPABLE_ITEM_FLAG VARCHAR2 (1)
INVENTORY_TRANSACTABLE_FLAG VARCHAR2 (1)
ASSEMBLE_TO_ORDER_FLAG VARCHAR2 (1)
SERIALIZABLE_ITEM_FLAG VARCHAR2 (1)
UI_TIMESTAMP_ADD DATE

UI_TIMESTAMP_REMOVE DATE

UI_TIMESTAMP_MOVE DATE

UI_TIMESTAMP_CHANGETYPE DATE

UI_TIMESTAMP_REORDER DATE

Query Text

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


SELECT PS_NODE_ID
,      DEVL_PROJECT_ID
,      NAME
,      PARENT_ID
,      PS_NODE_TYPE
,      FEATURE_TYPE
,      REFERENCE_ID
,      COUNTED_OPTIONS_FLAG
,      TREE_SEQ
,      PRODUCT_FLAG
,      RESOURCE_FLAG
,      COMPONENT_ID
,      INITIAL_NUM_VALUE
,      INITIAL_VALUE
,      INSTANTIABLE_FLAG
,      MAXIMUM
,      MAXIMUM_SELECTED
,      MINIMUM
,      MINIMUM_SELECTED
,      VIRTUAL_FLAG
,      UI_OMIT
,      UI_SECTION
,      COMPONENT_SEQUENCE_PATH
,      FROM_POPULATOR_ID
,      PROPERTY_BACKPTR
,      ITEM_TYPE_BACKPTR
,      INTL_TEXT_ID
,      ITEM_ID
,      ORIG_SYS_REF
,      MULTI_CONFIG_FLAG
,      ORDER_SEQ_FLAG
,      SYSTEM_NODE_FLAG
,      BOM_TREATMENT
,      COMPONENT_SEQUENCE_ID
,      BOM_REQUIRED_FLAG
,      SO_ITEM_TYPE_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      LAST_UPDATE_LOGIN
,      VIOLATION_TEXT_ID
,      EFFECTIVITY_SET_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      EFFECTIVE_USAGE_MASK
,      DECIMAL_QTY_FLAG
,      PERSISTENT_NODE_ID
,      QUOTEABLE_FLAG
,      PRIMARY_UOM_CODE
,      BOM_SORT_ORDER
,      IB_TRACKABLE
,      ACCUMULATOR_FLAG
,      NOTES_TEXT_ID
,      DISPLAYNAME_CAPT_RULE_ID
,      SRC_APPLICATION_ID
,      MAX_TEXT_LENGTH
,      DISPLAYNAME_TEXT_ID
,      SUB_CONS_ID
,      MAX_LENGTH
,      DETAILED_TYPE_ID
,      REGION_FLAG
,      PARENT_PERSISTENT_NODE_ID
,      DISPLAY_IN_SUMMARY_FLAG
,      TRANSIENT_FLAG
,      IB_LINK_ITEM_FLAG
,      SHIPPABLE_ITEM_FLAG
,      INVENTORY_TRANSACTABLE_FLAG
,      ASSEMBLE_TO_ORDER_FLAG
,      SERIALIZABLE_ITEM_FLAG
,      UI_TIMESTAMP_ADD
,      UI_TIMESTAMP_REMOVE
,      UI_TIMESTAMP_MOVE
,      UI_TIMESTAMP_CHANGETYPE
,      UI_TIMESTAMP_REORDER
FROM APPS.CZ_UI_TYPEDPSN_V;

Dependencies

[top of page]

APPS.CZ_UI_TYPEDPSN_V references the following:

SchemaAPPS
SynonymCZ_PS_NODES
PL/SQL PackageCZ_TYPES - show dependent code
APPS.CZ_UI_TYPEDPSN_V is referenced by following:

SchemaAPPS
Package BodyCZ_IMP_SINGLE - show dependent code
ViewCZ_UITEMPLS_FOR_PSNODES_V