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_QUOTE_ADJS_V

Object Details

Object Name:	QPR_SR_QUOTE_ADJS_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.

Oracle quoting deal source view - Adjustments

[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
EROSION_TYPE	CHAR	(9)		Erosion type
ADJUSTMENT_ID	NUMBER			Adjustment key
ADJUSTMENT_DESC	VARCHAR2	(271)		Adjustment description
ADJ_AMT	NUMBER			Adjustment amount per unit
ADJ_REVENUE	NUMBER			Adjustment revenue
ADJ_PERCENT	NUMBER			Adjustment percentage

Query Text

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


SELECT QUOTE_HEADER_ID
,      QUOTE_LINE_ID
,      SOURCE_ID
,      EROSION_TYPE
,      ADJUSTMENT_ID
,      ADJUSTMENT_DESC
,      ADJ_AMT
,      ADJ_REVENUE
,      ADJ_PERCENT
FROM APPS.QPR_SR_QUOTE_ADJS_V;

Dependencies

[top of page]

APPS.QPR_SR_QUOTE_ADJS_V references the following:

APPS: ASO_PRICE_ADJUSTMENTS; ASO_QUOTE_HEADERS_ALL; ASO_QUOTE_LINES_ALL; FND_APPLICATION_VL; FND_PROFILE - show dependent code; HZ_CUST_ACCOUNTS; QPR_SR_UTIL - show dependent code; QP_LIST_HEADERS_VL; QP_LIST_LINES; QP_RLTD_MODIFIERS

APPS.QPR_SR_QUOTE_ADJS_V is not referenced by any database object