[Home] [Help] [Dependency Information]
Object Name: | QP_DEBUG_REQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QP_DEBUG_REQ_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
APPS.QP_DEBUG_REQ_V is not referenced by any database object
|
|
|