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_PRICING_STRUCTURES

Object Details

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

This table is used to communicate configuration information to the Pricing module, and to return priced item information back for display by the Configurator UI.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: CZ_PRICING_STRUCTURES_PK

CONFIGURATOR_SESSION_KEY
SEQ_NBR

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_PRICING_STRUCTURES_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CONFIGURATOR_SESSION_KEY SEQ_NBR
CZ_PRICING_STRUCTURES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CONFIGURATOR_SESSION_KEY CONFIG_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIGURATOR_SESSION_KEY	VARCHAR2	(50)	Yes	Configurator Session Key is used to group all of the pricing request records associated with a single session in the Configurator.
PS_NODE_ID	NUMBER	(15)		Associates this record with a Model structure node ('psnode')
ITEM_KEY	VARCHAR2	(2000)	Yes	String carrying an identifier for an item for which pricing is to be determined.
ITEM_KEY_TYPE	NUMBER	(9)	Yes	Code indicating the format for the ITEM_KEY field.1 - 'orig_sys_ref' format CC:EX:ORG:ITEM, CC is component code, EX is explosion type, ORG is organization ID, ITEM is inventory item ID; 2 - ps_node_id
QUANTITY	NUMBER			Quantity of this item for which pricing is requested
UOM_CODE	VARCHAR2	(3)		Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'.
LIST_PRICE	NUMBER			Contains the list price applicable to the item in this record
SELLING_PRICE	NUMBER			Reports the calculated selling price for the requested item and quantity
MSG_DATA	VARCHAR2	(2000)		Information returned from the pricing engine to the Configurator. GENERALLY UNUSED.
SEQ_NBR	NUMBER		Yes	Provide ordering capability for pricing records; PRIMARY KEY FIELD
CONFIG_ITEM_ID	NUMBER		Yes	Associates this pricing record with a Configuration Item
PARENT_CONFIG_ITEM_ID	NUMBER	(15)		Specifies the parent configuration item for this Item. (Denormalization).

Query Text

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


SELECT CONFIGURATOR_SESSION_KEY
,      PS_NODE_ID
,      ITEM_KEY
,      ITEM_KEY_TYPE
,      QUANTITY
,      UOM_CODE
,      LIST_PRICE
,      SELLING_PRICE
,      MSG_DATA
,      SEQ_NBR
,      CONFIG_ITEM_ID
,      PARENT_CONFIG_ITEM_ID
FROM CZ.CZ_PRICING_STRUCTURES;

Dependencies

[top of page]

CZ.CZ_PRICING_STRUCTURES does not reference any database object

CZ.CZ_PRICING_STRUCTURES is referenced by following:

APPS: CZ_PRICING_STRUCTURES