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.QPR_SR_OM_QUOTE_COST_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Order management deal source view - Cost date

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTE_HEADER_ID	NUMBER		Yes	Source header id
QUOTE_LINE_ID	NUMBER		Yes	Source line id
SOURCE_ID	NUMBER			Source id
EROSION_TYPE	CHAR	(4)		Erosion type
COST_ID	CHAR	(4)		Cost Id
COST_DESC	VARCHAR2	(80)		Cost description
UNIT_COST	NUMBER			Cost per unit
TOTAL_COST	NUMBER			Total cost

Query Text

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


SELECT QUOTE_HEADER_ID
,      QUOTE_LINE_ID
,      SOURCE_ID
,      EROSION_TYPE
,      COST_ID
,      COST_DESC
,      UNIT_COST
,      TOTAL_COST
FROM APPS.QPR_SR_OM_QUOTE_COST_V;

Dependencies

[top of page]

APPS.QPR_SR_OM_QUOTE_COST_V references the following:

APPS: CST_COST_API - show dependent code; FND_APPLICATION_VL; FND_PROFILE - show dependent code; GL_SETS_OF_BOOKS; HR_ORGANIZATION_INFORMATION; HZ_CUST_ACCOUNTS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; QPR_LOOKUPS; QPR_SR_UTIL - show dependent code

APPS.QPR_SR_OM_QUOTE_COST_V is not referenced by any database object