[Home] [Help] [Dependency Information]
Object Name: | QPR_INT_DEAL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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'. |
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;
APPS.QPR_INT_DEAL_V is not referenced by any database object
|
|
|