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_INT_DEAL_V

Object Details

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

This view fetches the requests that are closed i.e. requests that was submitted, reviewed, approved and accepted by the requestor. It exposes the values that are changed during deal what-if, so that the source application can pull the data.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_ID	NUMBER		Yes	Unique Identifier of the deal response
DEAL_LINE_ID	NUMBER		Yes	Unique Identifier of the deal line
STATUS	VARCHAR2	(30)	Yes	Response status
SOURCE	NUMBER			Identifier of the deal line source.
SOURCE_REF_HEADER_ID	NUMBER		Yes	Identifier of header to which the deal line belongs in the source instance.
SOURCE_REF_LINE_ID	NUMBER			Identifier of the deal line as in the source instance from which it is sourced.
UOM_CODE	VARCHAR2	(240)		Unit of measure for the line quantity
CURRENCY_CODE	VARCHAR2	(240)		Currency code for line prices
ORDERED_QTY	NUMBER			Deal line Quantity
PRICE	NUMBER			Deal Line Invoice price
PAYMENT_TERM_ID	NUMBER			Deal line payment term identifier
SHIP_METHOD_CODE	VARCHAR2	(240)		Deal line ship method code
CHANGED	CHAR	(1)		Indicates if the values originally sourced have been modified during deal what-if.Takes values 'Y'/'N'.

Query Text

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


SELECT DEAL_ID
,      DEAL_LINE_ID
,      STATUS
,      SOURCE
,      SOURCE_REF_HEADER_ID
,      SOURCE_REF_LINE_ID
,      UOM_CODE
,      CURRENCY_CODE
,      ORDERED_QTY
,      PRICE
,      PAYMENT_TERM_ID
,      SHIP_METHOD_CODE
,      CHANGED
FROM APPS.QPR_INT_DEAL_V;

Dependencies

[top of page]

APPS.QPR_INT_DEAL_V references the following:

APPS: QPR_PN_LINES; QPR_PN_PRICES; QPR_PN_PR_TYPES; QPR_PN_REQUEST_HDRS_B; QPR_PN_RESPONSE_HDRS

APPS.QPR_INT_DEAL_V is not referenced by any database object