PACKAGE: APPS.QP_VALIDATE | Oracle EBS ETRM Search

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

APPS.QP_LINE_LVL_QUAL_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_QUALIFIERS·Explore QP module →

View: QP_LINE_LVL_QUAL_V 12.2.2

QP - Advanced Pricing·88 columns

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

APPS.QP_LINE_LVL_QUAL_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_QUALIFIERS·Explore QP module →

View: OE_PRICE_ADJUSTMENTS_V 12.2.2

ONT - Order Management·109 columns

This is a view on table OE_PRICE_ADJUSTMENTS.

APPS.OE_PRICE_ADJUSTMENTS_V·↳ OE_PRICE_ADJUSTMENTS·↳ QP_LIST_HEADERS_TL·Explore ONT module →

View: OKC_PRICE_ADJUSTMENTS_HV 12.1.1

OKC - Contracts Core·69 columns

APPS.OKC_PRICE_ADJUSTMENTS_HV·↳ OKC_PRICE_ADJUSTMENTS_H·Explore OKC module →

Table: OKC_PRICE_ADJUSTMENTS 12.2.2 hub-leaning

owner OKC·OKC - Contracts Core·68 columns

Record of actual adjustments made to price based on price attribute values.

OKC.OKC_PRICE_ADJUSTMENTS·Explore OKC module →

View: ASO_PRICE_ADJUSTMENTS_V 12.2.2

ASO - Order Capture·87 columns

view based on aso_price_adjustments

APPS.ASO_PRICE_ADJUSTMENTS_V·↳ ASO_PRICE_ADJUSTMENTS·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore ASO module →

View: OKX_QTE_PRC_ADJMNTS_V 12.2.2

OKX - Contracts Integration·86 columns

APPS.OKX_QTE_PRC_ADJMNTS_V·↳ ASO_PRICE_ADJUSTMENTS·Explore OKX module →

Table: QP_ARCH_LIST_LINES 12.2.2 standalone

owner QP·QP - Advanced Pricing·103 columns

QP.QP_ARCH_LIST_LINES·Explore QP module →

Table: PO_PRICE_ADJUSTMENTS_ARCHIVE 12.2.2 standalone

owner PO·PO - Purchasing·103 columns

Stores history regarding the Price Adjustments

PO.PO_PRICE_ADJUSTMENTS_ARCHIVE·Explore PO module →

View: QP_LIST_LINES_V 12.1.1

QP - Advanced Pricing·116 columns

Price List Lines information - used for List Lines block in Price Lists form.

APPS.QP_LIST_LINES_V·↳ QP_LIST_LINES·↳ QP_PRICE_LIST_LINE_UTIL·↳ QP_PRICING_ATTRIBUTES·Explore QP module →

View: OKX_ORD_PRC_ADJMNTS_V 12.2.2

OKX - Contracts Integration·69 columns

APPS.OKX_ORD_PRC_ADJMNTS_V·↳ OE_PRICE_ADJUSTMENTS·Explore OKX module →

View: OKX_QTE_PRC_ADJMNTS_V 12.1.1

OKX - Contracts Integration·86 columns

APPS.OKX_QTE_PRC_ADJMNTS_V·↳ ASO_PRICE_ADJUSTMENTS·Explore OKX module →

View: QP_MODIFIER_SUMMARY_V 12.2.2

QP - Advanced Pricing·151 columns

Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block).

APPS.QP_MODIFIER_SUMMARY_V·↳ QP_LIST_LINES·↳ QP_PRICE_LIST_LINE_UTIL·↳ QP_PRICING_ATTRIBUTES·Explore QP module →

Table: OE_PRICE_ADJUSTMENTS 12.1.1 satellite-leaning

owner ONT·ONT - Order Management·105 columns

This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the

ONT.OE_PRICE_ADJUSTMENTS·Explore ONT module →

View: QP_LDETS_V 12.2.2

QP - Advanced Pricing·64 columns

This view is for OM to get the post-pricing adjustment/modifier details.

APPS.QP_LDETS_V·↳ QP_LIST_LINES·↳ QP_PREQ_LDETS_TMP_T·Explore QP module →

Table: OKC_PRICE_ADJUSTMENTS_H 12.1.1 satellite-leaning

owner OKC·OKC - Contracts Core·69 columns

Record of actual adjustments made to price based on price attribute values.

OKC.OKC_PRICE_ADJUSTMENTS_H·Explore OKC module →

View: OE_ORD_PRC_ADJ_HIST_V 12.2.2

ONT - Order Management·93 columns

APPS.OE_ORD_PRC_ADJ_HIST_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_PRICE_ADJS_HISTORY·Explore ONT module →

Table: OKC_PRICE_ADJUSTMENTS 12.1.1 hub-leaning

owner OKC·OKC - Contracts Core·68 columns

Record of actual adjustments made to price based on price attribute values.

OKC.OKC_PRICE_ADJUSTMENTS·Explore OKC module →

View: QP_LIST_ATTRIBUTES_V 12.2.2

QP - Advanced Pricing·87 columns

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

APPS.QP_LIST_ATTRIBUTES_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·Explore QP module →

View: OE_LINE_PRC_ADJ_HIST_V 12.2.2

ONT - Order Management·93 columns

APPS.OE_LINE_PRC_ADJ_HIST_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·↳ OE_PRICE_ADJS_HISTORY·Explore ONT module →

Table: OKC_PRICE_ADJUSTMENTS_H 12.2.2 satellite-leaning

owner OKC·OKC - Contracts Core·69 columns

This is a mirror image of base table OKC_PRICE_ADJUSTMENTS, please refer to the base table for detailed column level information.

OKC.OKC_PRICE_ADJUSTMENTS_H·Explore OKC module →

View: QP_LISTS_V 12.2.2

QP - Advanced Pricing·74 columns

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

APPS.QP_LISTS_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·Explore QP module →

View: QP_LISTS_V 12.1.1

QP - Advanced Pricing·74 columns

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

APPS.QP_LISTS_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·Explore QP module →

View: QP_LINES_SUMMARY_V 12.1.1

QP - Advanced Pricing·84 columns

This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer.

APPS.QP_LINES_SUMMARY_V·↳ FND_USER_AP_PKG·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →

View: QP_LINES_SUMMARY_V 12.2.2

QP - Advanced Pricing·84 columns

This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer.

APPS.QP_LINES_SUMMARY_V·↳ FND_USER_AP_PKG·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →

View: QP_LDETS_V 12.1.1

QP - Advanced Pricing·64 columns

This view is for OM to get the post-pricing adjustment/modifier details.