Search Results list_price_uom_code




Overview
Explore in AI Chat

Overview

QP_LISTS_V is an Advanced Pricing (QP) view owned by the APPS schema. It joins QP_LIST_HEADERS_VL, the Multi-Lingual Support (MLS) view over the list header base tables, with QP_LIST_LINES, thereby presenting pricing list headers together with their assigned list lines in a single denormalized result set. The view is used to retrieve all list types maintained in Advanced Pricing — price lists, discount lists, surcharge lists, promotion lists, and related modifier lists — along with the lines each contains. Because Advanced Pricing stores list definitions in a header/line model, QP_LISTS_V gives report developers and integration developers a convenient, pre-joined source that avoids reconstructing the header-to-line relationship manually. The view exposes the columns of both underlying objects, including the header attributes carried by the MLS view and the pricing, modifier, accrual, and UOM attributes of each list line.

Underlying Base Objects

The documented referenced objects for QP_LISTS_V are:

  • QP_LIST_HEADERS_VL (VIEW) — the MLS view over the QP list header base tables. It supplies the header-level attributes such as ROW_ID, LIST_HEADER_ID, LIST_TYPE_CODE, NAME, DESCRIPTION, CURRENCY_CODE, dates, and flags.
  • QP_LIST_LINES (SYNONYM) — the list line object that stores individual price list lines, discount lines, and modifier lines, keyed by LIST_LINE_ID and linked to the header through LIST_HEADER_ID.

The view text selects from QP_LIST_HEADERS_VL (aliased QPH) and QP_LIST_LINES (aliased QPL), joining on the shared LIST_HEADER_ID. To disambiguate identically named date columns, the view aliases the header date columns as QPH_START_DATE_ACTIVE and QPH_END_DATE_ACTIVE, and the line date columns as QPL_START_DATE_ACTIVE and QPL_END_DATE_ACTIVE. This aliasing is important for consumers who must distinguish header-level effective dates from line-level effective dates.

Key Columns

Header-level columns include LIST_HEADER_ID, ROW_ID, LIST_TYPE_CODE (for example, Price List, Discount, or Surcharge), NAME, DESCRIPTION, CURRENCY_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE, ACTIVE_FLAG, VERSION_NO, PRORATE_FLAG, GSA_INDICATOR, SOURCE_SYSTEM_CODE, and PARENT_LIST_HEADER_ID. Line-level columns include LIST_LINE_ID, LIST_LINE_TYPE_CODE, LIST_LINE_NO, INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION, LIST_PRICE, PERCENT_PRICE, PRICE_BY_FORMULA_ID, PRICE_BREAK_TYPE_CODE, APPLICATION_METHOD (implied via the modifier columns), MODIFIER_LEVEL_CODE, PRIMARY_UOM_FLAG, and the accrual columns BASE_QTY, BASE_UOM_CODE, ACCRUAL_QTY, ACCRUAL_UOM_CODE, and ESTIM_ACCRUAL_RATE. The searched term list_price_uom_code is exposed as LIST_PRICE_UOM_CODE on the line, identifying the unit of measure in which LIST_PRICE is expressed for that line. This column is central when converting or comparing prices across items maintained in different primary or secondary UOMs.

Common Use Cases and Queries

Typical uses include validating price list and modifier line setups, extracting price list content for downstream pricing engines or interfaces, reconciling UOM assignments on pricing lines, and reporting discount or accrual lines by list.

A representative query returning list lines and their pricing UOM:

  • SELECT qph.list_header_id, qph.name, qph.list_type_code, qph.currency_code, qpl.list_line_id, qpl.inventory_item_id, qpl.list_price, qpl.list_price_uom_code, qpl.primary_uom_flag FROM qp_lists_v qph WHERE qph.list_type_code = 'PRL' AND qph.active_flag = 'Y';
  • Filter on list_price_uom_code to isolate lines whose pricing UOM differs from the item primary UOM, useful during UOM integrity checks.
  • Join INVENTORY_ITEM_ID to MTL_SYSTEM_ITEMS_B or use ORGANIZATION_ID to scope lines to a specific operating unit or inventory organization.

Because the view reads through QP_LIST_HEADERS_VL, translated NAME and DESCRIPTION values are returned according to the session language, making the view suitable for both transactional lookups and multi-language reporting in EBS 12.1.1 and 12.2.2.

  • 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_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_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_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: 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_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_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: 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 , 

  • View: QP_LIST_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_LINES_V,  object_name:QP_LIST_LINES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Price List Lines information - used for List Lines block in Price Lists form. ,  implementation_dba_data: APPS.QP_LIST_LINES_V , 

  • View: QP_LIST_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_LINES_V,  object_name:QP_LIST_LINES_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Price List Lines information - used for List Lines block in Price Lists form. ,  implementation_dba_data: APPS.QP_LIST_LINES_V , 

  • View: QP_MODIFIER_SUMMARY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_MODIFIER_SUMMARY_V,  object_name:QP_MODIFIER_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block). ,  implementation_dba_data: APPS.QP_MODIFIER_SUMMARY_V , 

  • View: QP_MODIFIER_SUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_MODIFIER_SUMMARY_V,  object_name:QP_MODIFIER_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block). ,  implementation_dba_data: APPS.QP_MODIFIER_SUMMARY_V ,