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_NPREQ_LINES_TMP

Object Details

Object Name:	QP_NPREQ_LINES_TMP
Object Type:	VIEW
Owner:	APPS
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
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies the transaction system making the pricing request.
LINE_ID	NUMBER			Unique identifier of the request line in the calling application.
LINE_INDEX	NUMBER		Yes	Unique identifier for request line internal to pricing engine.
LINE_TYPE_CODE	VARCHAR2	(30)	Yes	Type of line within the request. Allowable values are:1. ORDER2. LINE
PRICING_EFFECTIVE_DATE	DATE			Date for which the pricing engine calculates the prices.
LINE_QUANTITY	NUMBER			Pricing request line quantity.
LINE_UOM_CODE	VARCHAR2	(30)		Pricing request line unit of measure.
PRICED_QUANTITY	NUMBER			Quantity of pricing request line that pricing engine has priced.
PRICED_UOM_CODE	VARCHAR2	(30)		Unit of measure in which the pricing engine priced.
UOM_QUANTITY	NUMBER			Unit of measure quantity, for example, in service pricing, LINE_UOM_CODE is Months and UOM_QUANTITY is 2.This field is used for service item pricing.
CURRENCY_CODE	VARCHAR2	(30)		Currency in which the pricing engine priced.
UNIT_PRICE	NUMBER			Base price of the item.
PERCENT_PRICE	NUMBER			Indicates the percentage that should be used when calculating the price of the service item based on the parent line's price. Used for service item pricing.
ADJUSTED_UNIT_PRICE	NUMBER			Price per unit after the pricing engine applies discounts and surcharges, selling price.
PARENT_PRICE	NUMBER			When the pricing engine determines the price of an item from the price of another item, the price of the related item. Used for Service Item Pricing.
PARENT_QUANTITY	NUMBER			When the pricing engine determines the price of an item from the price of another item, the quantity of the related item. Used for Service Item Pricing.
PARENT_UOM_CODE	VARCHAR2	(30)		Used for Service Item Pricing.
PROCESSING_ORDER	NUMBER			Internal Purposes.
PROCESSED_FLAG	VARCHAR2	(1)		Internal Purposes.
PROCESSED_CODE	VARCHAR2	(240)		Internal Purposes.
PRICE_FLAG	VARCHAR2	(1)	Yes	Indicates the degree to which the price is frozen. Allowable values, based on lookup type CALCULATE_PRICE_FLAG are:1. Y (Calculate Price): Apply all prices and modifiers to the request line.2. N (Freeze Price): Do not apply any prices or modifiers to the request line. This line is considered for volume calculations when determining GROUP_QUANTITY or GROUP_AMOUNT in case of LINEGROUP modifiers for other lines.3. P (Partial Price). Apply prices and modifiers in phases whose freeze override flag is Y.
PRICING_STATUS_CODE	VARCHAR2	(30)	Yes	Returned status. Allowable values are:1. N: New record created (All 'N' records are returned back from the pricing engine. These are success records)2. X: Unchanged (Default status when the line is passed to the pricing engine for processing)3. U: Updated4. IPL: Invalid price list (When passed in price list is not found, then an error is given)5. GSA: GSA violation6. FER: Error processing formula7. OER: Other error8. CALC: Error in calculation engine9. UOM: Failed to price using unit of measure10. INVALID_UOM: Invalid unit of measure11. DUPLICATE_PRICE_LIST: Duplicate price list12. INVALID_UOM_CONV: Unit of measure conversion not found13. INVALID_INCOMP: Could not resolve incompatibility14. INVALID_BEST_PRICE: Could not resolve best price
PRICING_STATUS_TEXT	VARCHAR2	(2000)		Returned message
START_DATE_ACTIVE_FIRST	DATE			In addition to the pricing effective date, you can specify two additional dates for the pricing engine to use to qualify pricing entities. The pricing engine compares this date against the first date range on the modifier list - QP_LIST_LINES.START_DATE_ACTIVE_FIRST and QP_LIST_LINES.END_DATE_ACTIVE_FIRST.
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)		The date type of ACTIVE_DATE_FIRST based on lookup type EFFECTIVE_DATE_TYPES.
START_DATE_ACTIVE_SECOND	DATE			In addition to the pricing effective date, you can specify two additional dates for the pricing engine to use to qualify pricing entities. The pricing engine compares this date against the first date range on the modifier list - QP_LIST_LINES.START_DATE_ACTIVE_SECOND and QP_LIST_LINES.END_DATE_ACTIVE_SECOND.
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)		The date type of ACTIVE_DATE_SECOND based on lookup type EFFECTIVE_DATE_TYPES.
GROUP_QUANTITY	NUMBER			Internal Purposes.
GROUP_AMOUNT	NUMBER			Internal Purposes.
LINE_AMOUNT	NUMBER			Internal Purposes.
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 rounding factor on the pricing request line. When rounding, the calculation engine rounds all intermediate subtotals for each pricing group sequence.
ROUNDING_FACTOR	NUMBER			Used for rounding.
UPDATED_ADJUSTED_UNIT_PRICE	NUMBER			Internal Purposes.
PRICE_REQUEST_CODE	VARCHAR2	(240)		Used for limits processing.
HOLD_CODE	VARCHAR2	(240)		Limits Hold Code
HOLD_TEXT	VARCHAR2	(2000)		Limits Hold Text
PRICE_LIST_HEADER_ID	NUMBER			Identifier of the price list header used in the pricing line.
VALIDATED_FLAG	VARCHAR2	(1)		Indicates that a price list or modifier list(asked for promotion) is valid for the pricing request. Applicable to price list and modifier list qualifiers; the pricing engine assumes that other qualifiers are valid.
QUALIFIERS_EXIST_FLAG	VARCHAR2	(1)		Indicates whether there is any associated qualifier for the price list specified in PRICE_LIST_HEADER_ID.
PRICING_ATTRS_EXIST_FLAG	VARCHAR2	(1)		Indicates whether there are any pricing attributes for the price list specified in PRICE_LIST_HEADER_ID.
PRIMARY_QUALIFIERS_MATCH_FLAG	VARCHAR2	(1)		Used in Secondary Price List Search
USAGE_PRICING_TYPE	VARCHAR2	(30)		Indicates the type of pricing. REGULAR or USAGE
LINE_CATEGORY	VARCHAR2	(30)		Used in Limits processing.
CONTRACT_START_DATE	DATE			Used for Oracle Contracts specific pricing
CONTRACT_END_DATE	DATE			Used for Oracle Contracts specific pricing
LINE_UNIT_PRICE	NUMBER			Base price of the item.
REQUEST_ID	NUMBER			Request line identifier distinguishes between any two pricing engine calls.
PROCESS_STATUS	VARCHAR2	(2000)		This column will show the status for the free-good line. This column will have the values 'N', 'UPDATED', 'X', 'D' to indicate to the calling application that they need to insert, update or delete the free-good line.
EXTENDED_PRICE	NUMBER			This column hold the extended price for a price break line and is only applicable for the list lines with application method of BLOCK PRICE
ORDER_UOM_SELLING_PRICE	NUMBER			This column is used for storing the unit selling price in ordered quantity as calculated by the pricing engine.
CATCHWEIGHT_QTY	NUMBER			This is the actual quantity shipped for catchweight pricing to be passed by the calling application.
ACTUAL_ORDER_QUANTITY	NUMBER			Ordered quantity when catch weight pricing is enabled
HEADER_ID	NUMBER			For recognizing header boundaries in HVOP
PRICING_EVENT	VARCHAR2	(30)
CALCULATE_FLAG	VARCHAR2	(30)
SIMULATION_FLAG	VARCHAR2	(1)
GSA_CHECK_FLAG	VARCHAR2	(1)
GSA_DUP_CHECK_FLAG	VARCHAR2	(1)
MANUAL_DISCOUNT_FLAG	VARCHAR2	(1)
SOURCE_ORDER_AMOUNT_FLAG	VARCHAR2	(1)
MANUAL_ADJUSTMENTS_CALL_FLAG	VARCHAR2	(1)
GET_FREIGHT_FLAG	VARCHAR2	(1)
VIEW_CODE	VARCHAR2	(50)
CHECK_CUST_VIEW_FLAG	VARCHAR2	(1)
FULL_PRICING_CALL	VARCHAR2	(1)
USE_MULTI_CURRENCY	VARCHAR2	(1)
USER_CONVERSION_RATE	NUMBER
USER_CONVERSION_TYPE	VARCHAR2	(30)
FUNCTION_CURRENCY	VARCHAR2	(30)
LIST_PRICE_OVERRIDE_FLAG	VARCHAR2	(1)		When this flag has value 'Y', no price list search is done and the passed value on unit_price is retained, when 'O,' the passed unit_price is taken as default if search fails to find a suitable price list, when 'N,' current functionality is retained
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)
SERVICE_DURATION	NUMBER
SERVICE_PERIOD	VARCHAR2	(3)

Query Text

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


SELECT REQUEST_TYPE_CODE
,      LINE_ID
,      LINE_INDEX
,      LINE_TYPE_CODE
,      PRICING_EFFECTIVE_DATE
,      LINE_QUANTITY
,      LINE_UOM_CODE
,      PRICED_QUANTITY
,      PRICED_UOM_CODE
,      UOM_QUANTITY
,      CURRENCY_CODE
,      UNIT_PRICE
,      PERCENT_PRICE
,      ADJUSTED_UNIT_PRICE
,      PARENT_PRICE
,      PARENT_QUANTITY
,      PARENT_UOM_CODE
,      PROCESSING_ORDER
,      PROCESSED_FLAG
,      PROCESSED_CODE
,      PRICE_FLAG
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      START_DATE_ACTIVE_FIRST
,      ACTIVE_DATE_FIRST_TYPE
,      START_DATE_ACTIVE_SECOND
,      ACTIVE_DATE_SECOND_TYPE
,      GROUP_QUANTITY
,      GROUP_AMOUNT
,      LINE_AMOUNT
,      ROUNDING_FLAG
,      ROUNDING_FACTOR
,      UPDATED_ADJUSTED_UNIT_PRICE
,      PRICE_REQUEST_CODE
,      HOLD_CODE
,      HOLD_TEXT
,      PRICE_LIST_HEADER_ID
,      VALIDATED_FLAG
,      QUALIFIERS_EXIST_FLAG
,      PRICING_ATTRS_EXIST_FLAG
,      PRIMARY_QUALIFIERS_MATCH_FLAG
,      USAGE_PRICING_TYPE
,      LINE_CATEGORY
,      CONTRACT_START_DATE
,      CONTRACT_END_DATE
,      LINE_UNIT_PRICE
,      REQUEST_ID
,      PROCESS_STATUS
,      EXTENDED_PRICE
,      ORDER_UOM_SELLING_PRICE
,      CATCHWEIGHT_QTY
,      ACTUAL_ORDER_QUANTITY
,      HEADER_ID
,      PRICING_EVENT
,      CALCULATE_FLAG
,      SIMULATION_FLAG
,      GSA_CHECK_FLAG
,      GSA_DUP_CHECK_FLAG
,      MANUAL_DISCOUNT_FLAG
,      SOURCE_ORDER_AMOUNT_FLAG
,      MANUAL_ADJUSTMENTS_CALL_FLAG
,      GET_FREIGHT_FLAG
,      VIEW_CODE
,      CHECK_CUST_VIEW_FLAG
,      FULL_PRICING_CALL
,      USE_MULTI_CURRENCY
,      USER_CONVERSION_RATE
,      USER_CONVERSION_TYPE
,      FUNCTION_CURRENCY
,      LIST_PRICE_OVERRIDE_FLAG
,      CHARGE_PERIODICITY_CODE
,      SERVICE_DURATION
,      SERVICE_PERIOD
FROM APPS.QP_NPREQ_LINES_TMP;

Dependencies

[top of page]

APPS.QP_NPREQ_LINES_TMP references the following:

APPS: QP_PREQ_LINES_TMP_T

APPS.QP_NPREQ_LINES_TMP is referenced by following:

APPS: QP_ATTR_MAPPING_PUB - show dependent code; QP_CALCULATE_PRICE_PUB - show dependent code; QP_CLEANUP_ADJUSTMENTS_PVT - show dependent code; QP_COPY_DEBUG_PVT - show dependent code; QP_COPY_DEBUG_PVT - show dependent code; QP_COUPON_PVT - show dependent code; QP_LIMIT_BALANCE_CHECK_PVT - show dependent code; QP_LIMIT_TRANSACTIONS_PVT - show dependent code; QP_MULTI_CURRENCY_PVT - show dependent code; QP_PREQ_GRP - show dependent code; QP_PREQ_PUB - show dependent code; QP_PROCESS_OTHER_BENEFITS_PVT - show dependent code; QP_RESOLVE_INCOMPATABILITY_PVT - show dependent code; QP_UTIL_PUB - show dependent code; QP_UTIL_PUB - show dependent code