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]

VIEW: APPS.OKI_CPRICE_DTL_V

Object Details

Object Name:	OKI_CPRICE_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This view contains pricing attributes for the covered lines

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_ID	NUMBER		Yes	Instance ID, pulled from Install Base
PRICING_CONTEXT	VARCHAR2	(30)		Pricing Attribute Flexfield column
CONTEXT	VARCHAR2	(30)		Standard DFF Column , Pulled from Install Base
PRICING_ATTRIBUTE1	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE2	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE3	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE4	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE5	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE6	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE7	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE8	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE9	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE10	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE11	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE12	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE13	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE14	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE15	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE16	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE17	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE18	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE19	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base
PRICING_ATTRIBUTE20	VARCHAR2	(150)		Pricing Attribute Flexfield Column , pulled from Install Base

Query Text

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


SELECT INSTANCE_ID
,      PRICING_CONTEXT
,      CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      PRICING_ATTRIBUTE16
,      PRICING_ATTRIBUTE17
,      PRICING_ATTRIBUTE18
,      PRICING_ATTRIBUTE19
,      PRICING_ATTRIBUTE20
FROM APPS.OKI_CPRICE_DTL_V;

Dependencies

[top of page]

APPS.OKI_CPRICE_DTL_V references the following:

APPS: CSI_I_PRICING_ATTRIBS

APPS.OKI_CPRICE_DTL_V is not referenced by any database object