eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CZ.CZ_PS_NODES

Object Details

Object Name:	CZ_PS_NODES
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_PS_NODES
Subobject Name:
Status:	VALID

The CZ_PS_NODES table contains the entire structure of a product model. Data can be imported from Oracle Bill of Materials. Each project has a root (product) node. When the project structure is imported, project structure nodes mirror the imported BOM structure. Nodes of type REFERENCE are used to include a separate project ("model") into another psnode project tree.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_PS_NODES_PK

PS_NODE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_PS_NODES_PK	NORMAL	UNIQUE	APPS_TS_SEED	PS_NODE_ID
CZ_PS_NODES_U2	NORMAL	UNIQUE	APPS_TS_SEED	DELETED_FLAG PS_NODE_ID PARENT_ID COMPONENT_ID
CZ_PS_NODES_U3	NORMAL	UNIQUE	APPS_TS_SEED	DELETED_FLAG COMPONENT_ID PERSISTENT_NODE_ID PARENT_ID PS_NODE_ID
CZ_PS_NODES_U4	NORMAL	UNIQUE	APPS_TS_SEED	DELETED_FLAG PARENT_ID PS_NODE_ID TREE_SEQ
CZ_PS_NODES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ITEM_TYPE_BACKPTR
CZ_PS_NODES_N10	NORMAL	NONUNIQUE	APPS_TS_SEED	COMPONENT_SEQUENCE_ID DEVL_PROJECT_ID
CZ_PS_NODES_N11	NORMAL	NONUNIQUE	APPS_TS_SEED	DEVL_PROJECT_ID PS_NODE_ID PARENT_ID NAME ITEM_ID DELETED_FLAG
CZ_PS_NODES_N12	NORMAL	NONUNIQUE	APPS_TS_SEED	PERSISTENT_NODE_ID DEVL_PROJECT_ID DELETED_FLAG
CZ_PS_NODES_N13	NORMAL	NONUNIQUE	APPS_TS_SEED	ORIG_SYS_REF DEVL_PROJECT_ID DELETED_FLAG
CZ_PS_NODES_N14	NORMAL	NONUNIQUE	APPS_TS_SEED	EFFECTIVITY_SET_ID DELETED_FLAG
CZ_PS_NODES_N15	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG ITEM_ID PS_NODE_ID
CZ_PS_NODES_N16	NORMAL	NONUNIQUE	APPS_TS_SEED	DEVL_PROJECT_ID PS_NODE_ID PS_NODE_TYPE PERSISTENT_NODE_ID PARENT_ID UI_OMIT DELETED_FLAG
CZ_PS_NODES_N17	NORMAL	NONUNIQUE	APPS_TS_SEED	VIOLATION_TEXT_ID DELETED_FLAG
CZ_PS_NODES_N18	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG COMPONENT_ID PARENT_ID TREE_SEQ PS_NODE_TYPE REFERENCE_ID DEVL_PROJECT_ID
CZ_PS_NODES_N19	NORMAL	NONUNIQUE	APPS_TS_SEED	NAME COMPONENT_ID DELETED_FLAG
CZ_PS_NODES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	PROPERTY_BACKPTR ITEM_TYPE_BACKPTR ITEM_ID PS_NODE_TYPE
CZ_PS_NODES_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	INTL_TEXT_ID DELETED_FLAG
CZ_PS_NODES_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	COMPONENT_ID REFERENCE_ID PS_NODE_TYPE DELETED_FLAG DEVL_PROJECT_ID
CZ_PS_NODES_N5	NORMAL	NONUNIQUE	APPS_TS_SEED	REFERENCE_ID
CZ_PS_NODES_N6	NORMAL	NONUNIQUE	APPS_TS_SEED	ITEM_ID DELETED_FLAG
CZ_PS_NODES_N7	NORMAL	NONUNIQUE	APPS_TS_SEED	PARENT_ID PS_NODE_ID
CZ_PS_NODES_N8	NORMAL	NONUNIQUE	APPS_TS_SEED	DEVL_PROJECT_ID DELETED_FLAG UI_OMIT PS_NODE_ID PARENT_ID PS_NODE_TYPE
CZ_PS_NODES_N9	NORMAL	NONUNIQUE	APPS_TS_SEED	FROM_POPULATOR_ID
CZ_PS_NODES_U1	NORMAL	NONUNIQUE	APPS_TS_SEED	PARENT_ID NAME

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)
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
SUB_CONS_ID	NUMBER	(9)		UNUSED
ITEM_ID	NUMBER	(9)		Identifier of the item associated with this psnode
NAME	VARCHAR2	(1000)		Name for this product-structure node. Can be used for UI gen, otherwise used only in modelling.
ORIG_SYS_REF	VARCHAR2	(1200)		On imported nodes, identifies the record from which this psnode was imported
RESOURCE_FLAG	VARCHAR2	(1)		Flag indicating if node is a resource node type
INITIAL_VALUE	VARCHAR2	(4000)		Node initial value
PARENT_ID	NUMBER	(15)		Node identifier of the parent node
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.
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.
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
PRODUCT_FLAG	VARCHAR2	(1)		Flag indicating if node is a product type node
REFERENCE_ID	NUMBER	(15)		For reference-type nodes, identifies the model/root node to which this reference points
MULTI_CONFIG_FLAG	VARCHAR2	(1)		UNUSED
ORDER_SEQ_FLAG	VARCHAR2	(1)		UNUSED
SYSTEM_NODE_FLAG	VARCHAR2	(1)		Reserved for system use
TREE_SEQ	NUMBER	(9)	Yes	Provides an ordering of this node among other nodes with the same PARENT_ID
COUNTED_OPTIONS_FLAG	VARCHAR2	(1)		Flag indicating if option can be counted vs. selected
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
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
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.
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.
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
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.
LAST_UPDATE_LOGIN	NUMBER	(15)		UNUSED
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)	Yes	Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE
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.
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
COMPONENT_SEQUENCE_PATH	VARCHAR2	(2000)		Path of component_sequence_ids applicable to psnodes imported from Oracle BOM
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
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
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
INSTANTIABLE_FLAG	VARCHAR2	(1)		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.
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”
MAX_LENGTH	NUMBER			Maximum length restriction for a text feature.
DISPLAY_IN_SUMMARY_FLAG	VARCHAR2	(1)
TRANSIENT_FLAG	VARCHAR2	(1)		A flag indicating whether the specified node is transient.
IB_LINK_ITEM_FLAG	VARCHAR2	(1)		A flag indicating whether the specified node is a link item. Corresponds to IB_ITEM_INSTANCE_CLASS field in MTL_SYSTEM_ITEMS.
LAST_STRUCT_UPDATE	DATE			For use in a future UI refresh change. This field is the node-level version of cz_devl_projects.last_struct_update. It will be updated when a node changes in a way that requires its associated UI elements to be refreshed.
SHIPPABLE_ITEM_FLAG	VARCHAR2	(1)		Populated for BOM nodes from BOM_EXPLOSIONS.shippable_item_flag
INVENTORY_TRANSACTABLE_FLAG	VARCHAR2	(1)		Populated for BOM nodes from MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag
ASSEMBLE_TO_ORDER_FLAG	VARCHAR2	(1)		Populated for BOM nodes from BOM_EXPLOSIONS.replenish_to_order_flag
SERIALIZABLE_ITEM_FLAG	VARCHAR2	(1)		Populated for BOM nodes based on MTL_SYSTEM_ITEMS.serial_number_control_code'1' if serial_number_control_code <> 1, '0' otherwise
UI_TIMESTAMP_ADD	DATE			Timestamp of any operation that would cause node to be added to a UI. This includes creation via Create, Copy (node-level), Import, or Import Refresh, or 'Display in UI' changing from false to true. (Not affected by Model-level copy, migration, etc.) Not set if node's 'Display in UI' is False on creation
UI_TIMESTAMP_REMOVE	DATE			Timestamp of any operation that would cause node to be removed from a UI. This includes node deletion via Delete or Import Refresh, or 'Display in UI' changing from true to false.
UI_TIMESTAMP_MOVE	DATE			Timestamp of node reparenting via Move or Import Refresh
UI_TIMESTAMP_CHANGETYPE	DATE			Timestamp for significant change of detailed nodetype via edit or Import Refresh (see below for description of the significant changes)
UI_TIMESTAMP_REORDER	DATE
MAX_QTY_PER_OPTION	NUMBER
DOMAIN_ORDER	NUMBER
USER_INPUT_REQUIRED_FLAG	VARCHAR2	(1)
REVERSE_CONNECTOR_ID	NUMBER	(10)

Query Text

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


SELECT PS_NODE_ID
,      DEVL_PROJECT_ID
,      FROM_POPULATOR_ID
,      PROPERTY_BACKPTR
,      ITEM_TYPE_BACKPTR
,      INTL_TEXT_ID
,      SUB_CONS_ID
,      ITEM_ID
,      NAME
,      ORIG_SYS_REF
,      RESOURCE_FLAG
,      INITIAL_VALUE
,      PARENT_ID
,      MINIMUM
,      MAXIMUM
,      PS_NODE_TYPE
,      FEATURE_TYPE
,      PRODUCT_FLAG
,      REFERENCE_ID
,      MULTI_CONFIG_FLAG
,      ORDER_SEQ_FLAG
,      SYSTEM_NODE_FLAG
,      TREE_SEQ
,      COUNTED_OPTIONS_FLAG
,      UI_OMIT
,      UI_SECTION
,      BOM_TREATMENT
,      COMPONENT_SEQUENCE_ID
,      BOM_REQUIRED_FLAG
,      SO_ITEM_TYPE_CODE
,      MINIMUM_SELECTED
,      MAXIMUM_SELECTED
,      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
,      VIRTUAL_FLAG
,      LAST_UPDATE_LOGIN
,      EFFECTIVE_USAGE_MASK
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      DECIMAL_QTY_FLAG
,      PERSISTENT_NODE_ID
,      COMPONENT_SEQUENCE_PATH
,      VIOLATION_TEXT_ID
,      EFFECTIVITY_SET_ID
,      QUOTEABLE_FLAG
,      PRIMARY_UOM_CODE
,      BOM_SORT_ORDER
,      IB_TRACKABLE
,      COMPONENT_ID
,      INITIAL_NUM_VALUE
,      INSTANTIABLE_FLAG
,      ACCUMULATOR_FLAG
,      NOTES_TEXT_ID
,      DISPLAYNAME_CAPT_RULE_ID
,      SRC_APPLICATION_ID
,      MAX_TEXT_LENGTH
,      DISPLAYNAME_TEXT_ID
,      MAX_LENGTH
,      DISPLAY_IN_SUMMARY_FLAG
,      TRANSIENT_FLAG
,      IB_LINK_ITEM_FLAG
,      LAST_STRUCT_UPDATE
,      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
,      MAX_QTY_PER_OPTION
,      DOMAIN_ORDER
,      USER_INPUT_REQUIRED_FLAG
,      REVERSE_CONNECTOR_ID
FROM CZ.CZ_PS_NODES;

Dependencies

[top of page]

CZ.CZ_PS_NODES does not reference any database object

CZ.CZ_PS_NODES is referenced by following:

APPS: CZ_PS_NODES; CZ_PS_NODES_T1; CZ_PS_NODES_T2; CZ_PS_NODES_T3; CZ_PS_NODES_T4; CZ_PS_NODES_T5; CZ_PS_NODES_T6; CZ_PS_NODES_TP1