[Home] [Help] [Dependency Information]
Object Name: | CZ_UITEMPLS_FOR_PSNODES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_UITEMPLS_FOR_PSNODES_V |
Subobject Name: | |
Status: | VALID |
CZ_UITEMPLS_FOR_PSNODES_V lists each Model Node along with the UI Content Template to be used in rendering that node in every applicable user interface. It is used in UI Generation and Refresh and hence is usable for predicting or verifying the way in which a UI will treat a particular node.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PS_NODE_ID | NUMBER | (15) | 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) | 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) | 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 | 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 | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
DELETED_FLAG | VARCHAR2 | (1) | Indicates ('1'/'0') that this record has been deleted | |
EFF_FROM | DATE | UNUSED | ||
EFF_TO | DATE | UNUSED | ||
CREATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | 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) | Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE | |
DECIMAL_QTY_FLAG | VARCHAR2 | (1) | '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) | 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. | ||
UI_TIMESTAMP_ADD | DATE | |||
UI_TIMESTAMP_REMOVE | DATE | |||
UI_TIMESTAMP_MOVE | DATE | |||
UI_TIMESTAMP_CHANGETYPE | DATE | |||
UI_TIMESTAMP_REORDER | DATE | |||
DETAILED_TYPE_ID | NUMBER | |||
REGION_FLAG | VARCHAR2 | (4000) | ||
PARENT_PERSISTENT_NODE_ID | NUMBER | |||
UI_DEF_ID | NUMBER | |||
UIDEF_MODEL_ID | NUMBER | |||
UIDEF_NAME | VARCHAR2 | (255) | ||
TEMPLATE_ID | NUMBER | |||
TEMPLATE_UI_DEF_ID | NUMBER | |||
TEMPLATE_NAME | VARCHAR2 | (255) | ||
JRAD_DOC | VARCHAR2 | (255) | ||
TEMPLATE_DESC | VARCHAR2 | (2000) | ||
TEMPLATE_TYPE | NUMBER | |||
ROOT_ELEMENT_SIGNATURE_ID | NUMBER | |||
ROOT_REGION_TYPE | VARCHAR2 | (255) | ||
LAYOUT_UI_STYLE | VARCHAR2 | (1) | ||
PARENT_CONTAINER_TYPE | NUMBER |
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
, UI_TIMESTAMP_ADD
, UI_TIMESTAMP_REMOVE
, UI_TIMESTAMP_MOVE
, UI_TIMESTAMP_CHANGETYPE
, UI_TIMESTAMP_REORDER
, DETAILED_TYPE_ID
, REGION_FLAG
, PARENT_PERSISTENT_NODE_ID
, UI_DEF_ID
, UIDEF_MODEL_ID
, UIDEF_NAME
, TEMPLATE_ID
, TEMPLATE_UI_DEF_ID
, TEMPLATE_NAME
, JRAD_DOC
, TEMPLATE_DESC
, TEMPLATE_TYPE
, ROOT_ELEMENT_SIGNATURE_ID
, ROOT_REGION_TYPE
, LAYOUT_UI_STYLE
, PARENT_CONTAINER_TYPE
FROM APPS.CZ_UITEMPLS_FOR_PSNODES_V;
|
|
|