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_CONFIG_USAGES

Object Details

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

The CZ_CONFIG_USAGES table is used to allow the recording of client-application-specific data associated with each item in a configuration

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_CONFIG_USAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CALLING_APPLICATION_ID CALLING_APPLICATION_REF_KEY CONFIG_HDR_ID CONFIG_REV_NBR CONFIG_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CALLING_APPLICATION_ID	NUMBER		Yes	Client-specific ID for the application invoking the configurator
CALLING_APPLICATION_REF_KEY	VARCHAR2	(255)	Yes	Client-specific ID for the configurator session
CONFIG_HDR_ID	NUMBER		Yes	Identifies the configuration associated with this record
CONFIG_REV_NBR	NUMBER		Yes	Identifies the configuration revision associated with this record
CONFIG_ITEM_ID	NUMBER	(15)	Yes	Identifies the configuration item to which this record refers
LIST_PRICE	NUMBER			Identifies the list price applicable to this configured item
AUTO_DISCOUNT_ID	NUMBER			Associates this configuration item/usage with an automatic discount
AUTO_DISCOUNT_LINE_ID	NUMBER			Specifies an automatic discount line ID for this configuration item/usage
AUTO_DISCOUNT_PCT	NUMBER			Specifies an automatic discount as a percentage
MANUAL_DISCOUNT_ID	NUMBER			Records the identity of the manual discount applicable for this configured item
MANUAL_DISCOUNT_LINE_ID	NUMBER			Records a discount line applicable for this configured item
MANUAL_DISCOUNT_PCT	NUMBER			Records the percentage of manual discount applicable for this configured item
DISCOUNTED_PRICE	NUMBER			Applies a discounted price to this item in the configuration
ATP_DATE	DATE			Indicates available-to-promise data for this item in the configuration/usage
UOM_CODE	VARCHAR2	(3)		Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'.
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
CREATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that created this record
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that last updated this record
SECURITY_MASK	VARCHAR2	(40)		UNUSED
EFF_MASK	VARCHAR2	(40)		UNUSED
CHECKOUT_USER	VARCHAR2	(40)		UNUSED
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_FROM	DATE			UNUSED
EFF_TO	DATE			UNUSED

Query Text

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


SELECT CALLING_APPLICATION_ID
,      CALLING_APPLICATION_REF_KEY
,      CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONFIG_ITEM_ID
,      LIST_PRICE
,      AUTO_DISCOUNT_ID
,      AUTO_DISCOUNT_LINE_ID
,      AUTO_DISCOUNT_PCT
,      MANUAL_DISCOUNT_ID
,      MANUAL_DISCOUNT_LINE_ID
,      MANUAL_DISCOUNT_PCT
,      DISCOUNTED_PRICE
,      ATP_DATE
,      UOM_CODE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
FROM CZ.CZ_CONFIG_USAGES;

Dependencies

[top of page]

CZ.CZ_CONFIG_USAGES does not reference any database object

CZ.CZ_CONFIG_USAGES is referenced by following:

APPS: CZ_CONFIG_USAGES; CZ_CONFIG_USAGES_T1