Search Results rounding_factor

Overview

OE_PRICE_LISTS_ACTIVE_V is a backward-compatibility view owned by the APPS schema in Oracle E-Business Suite, residing in the QP (Advanced Pricing) product family. As documented in ETRM 12.2.2, the view presents all price lists that are active as of the current system date (SYSDATE). Its purpose is explicitly stated as providing backward compatibility for other applications—legacy Oracle Order Management and related modules that historically expected a view exposing only currently valid price lists without requiring callers to apply date-range predicates themselves.

In both 12.1.1 and 12.2.2, the view is registered with status VALID and carries a narrow column footprint. Because the filtering logic is embedded directly in the view definition, consumers receive an implicitly date-scoped result set. This makes the object suited to reporting and lightweight integration rather than to transactional pricing logic, which is handled inside the pricing engine proper.

Underlying Base Objects

The documented referenced base objects are OE_PRICE_LISTS_V (VIEW) and QP_PRICE_LIST_PVT (PACKAGE). The primary dependency is OE_PRICE_LISTS_V, another APPS-owned compatibility view, which the subject view queries directly. QP_PRICE_LIST_PVT is the Advanced Pricing package that underpins price list definition and validation logic; it is referenced in the dependency chain but is not invoked by the view's SELECT statement itself.

The view text is a straightforward projection with a filter predicate:

SELECT NAME PRICE_LIST, DESCRIPTION, PRICE_LIST_ID, ROUNDING_FACTOR, CURRENCY_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE FROM OE_PRICE_LISTS_V WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE)

The NVL constructs treat a NULL start date as open-ended into the past and a NULL end date as open-ended into the future, so a price list with both dates null is always returned. Consequently the view behaves as a synonym-like wrapper: same columns as OE_PRICE_LISTS_V, restricted to rows whose active window contains SYSDATE.

Key Columns

PRICE_LIST — The price list name, sourced from the NAME column of OE_PRICE_LISTS_V and aliased for legacy consumers.
DESCRIPTION — Free-form description text for the price list.
PRICE_LIST_ID — Primary identifier of the price list, used to join to QP_PRICING_ATTRIBUTES, QP_LIST_HEADERS_B/TL, and related pricing entities.
ROUNDING_FACTOR — Rounding factor applied to computed prices within the price list.
CURRENCY_CODE — Functional currency in which the price list is denominated.
START_DATE_ACTIVE and END_DATE_ACTIVE — The effective date boundaries of the price list; both are nullable, and NULL values are interpreted as unbounded.

Common Use Cases and Queries

Typical uses include validation of order-entry pricing, LOV-style lookups in custom concurrent programs, and reconciliation reports that must show only currently effective price lists. Because the dates are already constrained, callers should not add their own date predicates unless they require a different as-of date.

List all active price lists:

SELECT price_list, description, currency_code, start_date_active, end_date_active FROM apps.oe_price_lists_active_v ORDER BY price_list;

Find an active price list by name, then join to the list header for further attributes:

SELECT v.price_list, v.price_list_id, h.list_type_code FROM apps.oe_price_lists_active_v v, apps.qp_list_headers_b h WHERE v.price_list_id = h.list_header_id AND v.price_list = :name;

Identify active price lists in a specific currency:

SELECT price_list, price_list_id, rounding_factor FROM apps.oe_price_lists_active_v WHERE currency_code = 'USD';

Because the view filters on SYSDATE, results differ between 12.1.1 and 12.2.2 only insofar as the underlying OE_PRICE_LISTS_V and pricing data differ. The object remains a read-only compatibility surface and should not be used for insert, update, or delete operations.

View: OE_PRICE_LISTS_ACTIVE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_ACTIVE_V, object_name:OE_PRICE_LISTS_ACTIVE_V, status:VALID, product: QP - Advanced Pricing , description: Shows all the price lists that are active as of today (sysdate). Provided for backward compatibility for other applications. , implementation_dba_data: APPS.OE_PRICE_LISTS_ACTIVE_V ,
View: OE_PRICE_LISTS_ACTIVE_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_ACTIVE_V, object_name:OE_PRICE_LISTS_ACTIVE_V, status:VALID, product: QP - Advanced Pricing , description: Shows all the price lists that are active as of today (sysdate). Provided for backward compatibility for other applications. , implementation_dba_data: APPS.OE_PRICE_LISTS_ACTIVE_V ,
View: QP_PRICE_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICE_LISTS_V, object_name:QP_PRICE_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: Price List information. Provided for backward compatibility for other applications. , implementation_dba_data: APPS.QP_PRICE_LISTS_V ,
View: OE_PRICE_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_V, object_name:OE_PRICE_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: Price List information. Provided for backward compatibility for other applications. , implementation_dba_data: APPS.OE_PRICE_LISTS_V ,
View: OE_PRICE_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_V, object_name:OE_PRICE_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: Price List information. Provided for backward compatibility for other applications. , implementation_dba_data: APPS.OE_PRICE_LISTS_V ,
View: QP_PRICE_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICE_LISTS_V, object_name:QP_PRICE_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: Price List information. Provided for backward compatibility for other applications. , implementation_dba_data: APPS.QP_PRICE_LISTS_V ,
View: OE_PRICE_LISTS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_VL, object_name:OE_PRICE_LISTS_VL, status:VALID, product: QP - Advanced Pricing , description: Price List information. Displays the translated columns on List Headers in the local language. Provided for backward compatibility for other applications. , implementation_dba_data: APPS.OE_PRICE_LISTS_VL ,
View: OE_PRICE_LISTS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_VL, object_name:OE_PRICE_LISTS_VL, status:VALID, product: QP - Advanced Pricing , description: Price List information. Displays the translated columns on List Headers in the local language. Provided for backward compatibility for other applications. , implementation_dba_data: APPS.OE_PRICE_LISTS_VL ,
View: QPBV_PRICE_LISTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRICE_LISTS, object_name:QPBV_PRICE_LISTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Standard and Agreement Price list headers. , implementation_dba_data: APPS.QPBV_PRICE_LISTS ,
View: QPBV_PRICE_LISTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRICE_LISTS, object_name:QPBV_PRICE_LISTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Standard and Agreement Price list headers. , implementation_dba_data: APPS.QPBV_PRICE_LISTS ,
View: QPFV_PRICE_LISTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRICE_LISTS, object_name:QPFV_PRICE_LISTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Standard and Agreement Price list headers. , implementation_dba_data: APPS.QPFV_PRICE_LISTS ,
View: QPFV_PRICE_LISTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRICE_LISTS, object_name:QPFV_PRICE_LISTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Standard and Agreement Price list headers. , implementation_dba_data: APPS.QPFV_PRICE_LISTS ,
View: OE_PRICE_LISTS_115_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_115_VL, object_name:OE_PRICE_LISTS_115_VL, status:VALID, product: QP - Advanced Pricing , description: Price List information. Provided for backward compatibility for other applications and upgrade. , implementation_dba_data: APPS.OE_PRICE_LISTS_115_VL ,
View: OE_PRICE_LISTS_115_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICE_LISTS_115_VL, object_name:OE_PRICE_LISTS_115_VL, status:VALID, product: QP - Advanced Pricing , description: Price List information. Provided for backward compatibility for other applications and upgrade. , implementation_dba_data: APPS.OE_PRICE_LISTS_115_VL ,
View: QP_DEBUG_REQ_LINES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LINES_V, object_name:QP_DEBUG_REQ_LINES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced. , implementation_dba_data: APPS.QP_DEBUG_REQ_LINES_V ,
View: QP_DEBUG_REQ_LINES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LINES_V, object_name:QP_DEBUG_REQ_LINES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced. , implementation_dba_data: APPS.QP_DEBUG_REQ_LINES_V ,
View: QP_LIST_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_HEADERS_V, object_name:QP_LIST_HEADERS_V, status:VALID, product: QP - Advanced Pricing , description: This view gives details of all standard price lists setup in pricing. , implementation_dba_data: APPS.QP_LIST_HEADERS_V ,
View: QP_PREQ_LINES_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LINES_TMP, object_name:QP_PREQ_LINES_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LINES_TMP ,
View: QP_PREQ_LINES_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LINES_TMP, object_name:QP_PREQ_LINES_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LINES_TMP ,
View: QP_DEBUG_REQ_LDETS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QP_LIST_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_HEADERS_V, object_name:QP_LIST_HEADERS_V, status:VALID, product: QP - Advanced Pricing , description: This view gives details of all standard price lists setup in pricing. , implementation_dba_data: APPS.QP_LIST_HEADERS_V ,
View: QP_LIST_SUMMARY_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_SUMMARY_VL, object_name:QP_LIST_SUMMARY_VL, status:VALID, product: QP - Advanced Pricing , description: This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer. , implementation_dba_data: APPS.QP_LIST_SUMMARY_VL ,
View: QP_SECONDARY_PRICE_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V, object_name:QP_SECONDARY_PRICE_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. , implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V ,
View: QP_LIST_SUMMARY_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_SUMMARY_VL, object_name:QP_LIST_SUMMARY_VL, status:VALID, product: QP - Advanced Pricing , description: This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer. , implementation_dba_data: APPS.QP_LIST_SUMMARY_VL ,
View: QP_DEBUG_REQ_LDETS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QP_PREQ_LDETS_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LDETS_TMP, object_name:QP_PREQ_LDETS_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LDETS_TMP ,
View: QP_LIST_HEADERS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_HEADERS_VL, object_name:QP_LIST_HEADERS_VL, status:VALID, product: QP - Advanced Pricing , description: View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language. , implementation_dba_data: APPS.QP_LIST_HEADERS_VL ,
View: QP_LIST_HEADERS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_HEADERS_VL, object_name:QP_LIST_HEADERS_VL, status:VALID, product: QP - Advanced Pricing , description: View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language. , implementation_dba_data: APPS.QP_LIST_HEADERS_VL ,
View: QP_SECONDARY_PRICE_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V, object_name:QP_SECONDARY_PRICE_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. , implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V ,
View: QP_PREQ_LDETS_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LDETS_TMP, object_name:QP_PREQ_LDETS_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LDETS_TMP ,
View: QP_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LISTS_V, object_name:QP_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl , implementation_dba_data: APPS.QP_LISTS_V ,
View: QP_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LISTS_V, object_name:QP_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl , implementation_dba_data: APPS.QP_LISTS_V ,
View: QP_LIST_ATTRIBUTES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_ATTRIBUTES_V, object_name:QP_LIST_ATTRIBUTES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns , implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V ,
View: QP_HDR_LVL_QUAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_HDR_LVL_QUAL_V, object_name:QP_HDR_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual , implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V ,
View: OE_PRICING_CONTRACTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICING_CONTRACTS_V, object_name:OE_PRICING_CONTRACTS_V, status:VALID, product: QP - Advanced Pricing , description: Obsolete , implementation_dba_data: APPS.OE_PRICING_CONTRACTS_V ,
View: QP_HDR_LVL_QUAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_HDR_LVL_QUAL_V, object_name:QP_HDR_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual , implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V ,
View: QP_LINE_LVL_QUAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINE_LVL_QUAL_V, object_name:QP_LINE_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual , implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,
View: QP_LINE_LVL_QUAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINE_LVL_QUAL_V, object_name:QP_LINE_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual , implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,
View: OE_PRICING_CONTRACTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.OE_PRICING_CONTRACTS_V, object_name:OE_PRICING_CONTRACTS_V, status:VALID, product: QP - Advanced Pricing , description: Obsolete , implementation_dba_data: APPS.OE_PRICING_CONTRACTS_V ,
View: QP_LIST_ATTRIBUTES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_ATTRIBUTES_V, object_name:QP_LIST_ATTRIBUTES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns , implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V ,