PACKAGE: APPS.OE_CNCL_VALIDATE | Oracle EBS ETRM Search

This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f

APPS.QPFV_MODIFIER_LINES·↳ MTL_UNITS_OF_MEASURE·↳ QP_LIST_LINES·↳ QP_QP_FORM_PRICING_ATTR·Explore QP module →

View: QP_PREQ_LDETS_TMP 12.2.2

QP - Advanced Pricing·76 columns

Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.

APPS.QP_PREQ_LDETS_TMP·↳ QP_PREQ_LDETS_TMP_T·Explore QP module →

View: QP_DEBUG_REQ_LDETS_V 12.1.1

QP - Advanced Pricing·55 columns

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

APPS.QP_DEBUG_REQ_LDETS_V·↳ QP_DEBUG_REQ_LDETS·↳ QP_DEBUG_REQ_RLTD_LINES·Explore QP module →

Table: QP_PREQ_LDETS_TMP_T1 12.2.2 standalone

owner QP·QP - Advanced Pricing·76 columns

QP.QP_PREQ_LDETS_TMP_T1·Explore QP module →

Table: QP_INT_LDETS_T 12.1.1 standalone

owner QP·QP - Advanced Pricing·79 columns

Permanent table for holding the details of the derivation of the base and adjusted prices.

QP.QP_INT_LDETS_T·Explore QP module →

View: OE_AK_HEADER_PRCADJS_V 12.2.2

ONT - Order Management·103 columns

APPS.OE_AK_HEADER_PRCADJS_V·↳ OE_PRICE_ADJUSTMENTS_V·Explore ONT module →

View: OKX_ORD_PRC_ADJMNTS_V 12.1.1

OKX - Contracts Integration·69 columns

APPS.OKX_ORD_PRC_ADJMNTS_V·↳ OE_PRICE_ADJUSTMENTS·Explore OKX module →

View: QPBV_MODIFIER_LINES 12.2.2

QP - Advanced Pricing·40 columns

This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f

APPS.QPBV_MODIFIER_LINES·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →

View: QPBV_MODIFIER_LINES 12.1.1

QP - Advanced Pricing·40 columns

This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f

APPS.QPBV_MODIFIER_LINES·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·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 →

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: OKC_PRICE_ADJUSTMENTS_V 12.2.2

OKC - Contracts Core·68 columns

View for table OKC_PRICE_ADJUSTMENTS

APPS.OKC_PRICE_ADJUSTMENTS_V·↳ OKC_PRICE_ADJUSTMENTS·Explore OKC module →

PACKAGE BODY: APPS.OE_CNCL_VALIDATE 12.2.2

used by 6

PACKAGE BODY: APPS.OE_CNCL_VALIDATE 12.1.1

used by 6

PACKAGE: APPS.OE_CNCL_VALIDATE 12.1.1

used by 6

PACKAGE BODY: APPS.OE_VALIDATE 12.2.2

used by 22

PACKAGE: APPS.OE_VALIDATE 12.2.2

used by 22

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 →

PACKAGE BODY: APPS.OE_VALIDATE 12.1.1

used by 21

Table: QP_INT_LDETS_T 12.2.2 standalone

owner QP·QP - Advanced Pricing·81 columns

Permanent table for holding the details of the derivation of the base and adjusted prices.

QP.QP_INT_LDETS_T·Explore QP module →

Table: OE_PRICE_ADJS_IFACE_ALL 12.1.1 link

owner ONT·ONT - Order Management·93 columns

This is a multi-org open interface table for sales order/line price adjustments.

ONT.OE_PRICE_ADJS_IFACE_ALL·Explore ONT module →

Table: PO_PRICE_ADJUSTMENTS_DRAFT 12.2.2 standalone

owner PO·PO - Purchasing·106 columns

Draft table for the Price Adjustments.

PO.PO_PRICE_ADJUSTMENTS_DRAFT·Explore PO module →

Table: QP_LIST_LINES 12.1.1 hub

owner QP·QP - Advanced Pricing·104 columns

QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.

QP.QP_LIST_LINES·Explore QP module →

Table: QP_INTERFACE_LIST_LINES 12.2.2 standalone

owner QP·QP - Advanced Pricing·105 columns

QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.

QP.QP_INTERFACE_LIST_LINES·Explore QP module →

Table: OE_PRICE_ADJUSTMENTS 12.2.2 satellite-leaning

owner ONT·ONT - Order Management·106 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: 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_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: OE_AK_LINE_PRCADJS_V 12.1.1

ONT - Order Management·104 columns

APPS.OE_AK_LINE_PRCADJS_V·↳ OE_PRICE_ADJUSTMENTS_V·Explore ONT 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: QPFV_MODIFIER_LINES 12.1.1

QP - Advanced Pricing·50 columns

This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f

APPS.QPFV_MODIFIER_LINES·↳ MTL_UNITS_OF_MEASURE·↳ QP_LIST_LINES·↳ QP_QP_FORM_PRICING_ATTR·Explore QP 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: QP_DEBUG_REQ_LDETS 12.1.1 link

owner QP·QP - Advanced Pricing·53 columns

This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates.

QP.QP_DEBUG_REQ_LDETS·Explore QP module →

Table: QP_DEBUG_REQ_LDETS 12.2.2 link

owner QP·QP - Advanced Pricing·53 columns

This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates.

QP.QP_DEBUG_REQ_LDETS·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_DEBUG_REQ_LDETS_V 12.2.2

QP - Advanced Pricing·55 columns

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

APPS.QP_DEBUG_REQ_LDETS_V·↳ QP_DEBUG_REQ_LDETS·↳ QP_DEBUG_REQ_RLTD_LINES·Explore QP module →

View: QP_PREQ_LDETS_TMP 12.1.1

QP - Advanced Pricing·74 columns

Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.

APPS.QP_PREQ_LDETS_TMP·↳ QP_PREQ_LDETS_TMP_T·Explore QP 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 →

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.