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

Object Details

Object Name:	QP_DEBUG_REQ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QP_DEBUG_REQ_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Internal row identifier.
REQUEST_ID	NUMBER		Yes	Request Id is the sequence number to uniquely identify the Debug Requests.
REQUEST_NAME	VARCHAR2	(240)	Yes	Name of the Pricing Request. Value of the Profile Option: QP_SET_REQUEST_NAME is appended with Header Id and stored in this field.
CREATED_BY	NUMBER		Yes	Name of the user who created this request.
CREATION_DATE	DATE		Yes	Standard WHO Column. Contains the Date+ Time Stamp at which the record was created.
PRICING_EVENT	VARCHAR2	(30)		A point in the transaction life cycle of your transaction at which you wish to price it. The pricing event determines which phases the search engine processes according to the mapping in QP_EVENT_PHASES.
CALCULATE_FLAG	VARCHAR2	(30)	Yes	This refers to the Calculation_Flag in control record, which is passed to the Pricing Engine. From all the requesting systems the value for this flag is always passed as 'Y'. Allowable values are:* N: Search engine - If you do not want the engine to calculate the selling price.* C: Calculate engine - If you are passing the adjustment records to the engine and you want the engine to recalculate the selling price, without retrieving new adjustments.* Y: Both calculate and search engine - Regular engine call. Retrieves new adjustments and calculates the selling price.
SIMULATION_FLAG	VARCHAR2	(1)		When set to 'Y' it indicates that the call to Pricing Engine is a pricing simulation and that the pricing engine should not make permanent record changes and neither issue or redeem coupons.
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies the transaction system making the pricing request.
VIEW_CODE	VARCHAR2	(50)		This field is used for AG Performance. It indicates database view id, which the source system uses to access the calling application's data.
ROUNDING_FLAG	VARCHAR2	(1)		Indicates whether the calculation engine should round the list price and selling price based on the price list rounding factor or the pricing request line record rounding factor. When rounding, the calculation engine rounds all intermediate subtotals for each pricing group sequence.* If set to Y , engine should apply the rounding factor defined in the price list. * If set to N , unrounded figures would be returned.
GSA_CHECK_FLAG	VARCHAR2	(1)		Indicates whether the pricing calculation engine should test for GSA violations. The evaluation is performed if a request is for a non-GSA customer, and GSA rules are violated if the selling price of an item is calculated to be less than the price of the item on any GSA price list. Allowable values are:* Yes: Price Calculation engine tests for GSA violations, any violating request lines are returned to the calling application with a status of GSA violation.* No: Do not test for GSA violations.The value of this field is controlled by profile in the requesting systems.
GSA_DUP_CHECK_FLAG	VARCHAR2	(1)		Indicates that the engine should perform GSA duplicate check. The calling application will set this flag to 'Y' if it wants the Pricing Engine to test for GSA violations, set this flag to 'N' if it doesn't want Pricing Engine to test for GSA violations.
TEMP_TABLE_INSERT_FLAG	VARCHAR2	(1)		This flag is set to Y, if the calling application directly inserts data into the pricing temporary tables, set to 'N' if Pricing Engine inserts into Temporary tables.
MANUAL_DISCOUNT_FLAG	VARCHAR2	(1)		This value is set by the calling application and the value is based on the profile QP: Return Manual Discounts. Indicates how pricing engine should perform incompatibility processing for manual discounts. The possible values for this profile are:* Yes: All the manual discounts will be returned. All the automatic discounts that get deleted as part of incompatibility processing will be returned as manual discounts.* No: All automatic and manual discounts will go through incompatibility processing and one of them in each incompatibility group will be returned. In this process an automatic discount might get deleted and a manual discount might get selected.
DEBUG_FLAG	VARCHAR2	(1)		This contains the value of the profile: QP_DEBUG.
SOURCE_ORDER_AMOUNT_FLAG	VARCHAR2	(1)		If set to Y, Indicates to the pricing engine to source the order amount. It means the calling application will provide the order amount. If set to 'N', The Pricing engine should calculate the order amount.
PUBLIC_API_CALL_FLAG	VARCHAR2	(1)		This indicates whether public API is being used to call the Pricing Engine. If set to 'Y', the public api 'QP_PREQ_PUB' is used to call the pricing engine. If set to 'N', The group api 'QP_PREQ_GRP' is used to call the pricing engine.
MANUAL_ADJUSTMENTS_CALL_FLAG	VARCHAR2	(1)		This value is set by the calling application. Indicates whether pricing engine should consider manual discounts. The allowable values are:* Yes: Apply the manual discounts. Means unit price is not calculated by pricing engine.* No: Do not apply the manual discounts. Means new unit price is calculated by pricing engine.
CHECK_CUST_VIEW_FLAG	VARCHAR2	(1)		If set to 'Y', it indicates that to access the calling applications data, the source system uses the view provided by calling application. If set to 'N', it indicates that the calling application directly provides the data to the source system.
CURRENCY_CODE	VARCHAR2	(30)		Currency in which the pricing engine priced. The value for this field should be same across all lines.
ORDER_NUMBER	VARCHAR2	(50)

Query Text

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


SELECT ROW_ID
,      REQUEST_ID
,      REQUEST_NAME
,      CREATED_BY
,      CREATION_DATE
,      PRICING_EVENT
,      CALCULATE_FLAG
,      SIMULATION_FLAG
,      REQUEST_TYPE_CODE
,      VIEW_CODE
,      ROUNDING_FLAG
,      GSA_CHECK_FLAG
,      GSA_DUP_CHECK_FLAG
,      TEMP_TABLE_INSERT_FLAG
,      MANUAL_DISCOUNT_FLAG
,      DEBUG_FLAG
,      SOURCE_ORDER_AMOUNT_FLAG
,      PUBLIC_API_CALL_FLAG
,      MANUAL_ADJUSTMENTS_CALL_FLAG
,      CHECK_CUST_VIEW_FLAG
,      CURRENCY_CODE
,      ORDER_NUMBER
FROM APPS.QP_DEBUG_REQ_V;

Dependencies

[top of page]

APPS.QP_DEBUG_REQ_V references the following:

APPS: QP_DEBUG_REQ

APPS.QP_DEBUG_REQ_V is not referenced by any database object