PACKAGE BODY: APPS.OE_VALIDATE_ADJ | Oracle EBS ETRM Search

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: 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 →

PACKAGE: APPS.OE_VALIDATE_ADJ 12.1.1

used by 6

PACKAGE BODY: APPS.OE_CNCL_VALIDATE_ADJ 12.1.1

used by 2

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: 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: 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 →

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 →

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: 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 →

PACKAGE: APPS.OE_CNCL_VALIDATE 12.2.2

used by 6

PACKAGE BODY: APPS.OE_VALIDATE_ADJ 12.1.1

used by 6

PACKAGE: APPS.OE_CNCL_VALIDATE_ADJ 12.1.1

used by 2

PACKAGE: APPS.OE_CNCL_VALIDATE_ADJ 12.2.2

used by 2

View: OE_PRICE_ADJS_HISTORY_V 12.1.1

ONT - Order Management·110 columns

This view is used to retrieve Price Adjustments history. This is used by the history form.

APPS.OE_PRICE_ADJS_HISTORY_V·↳ OE_PRICE_ADJS_HISTORY·↳ QP_LIST_HEADERS_TL·Explore ONT module →

View: OE_PRICE_ADJS_HISTORY_V 12.2.2

ONT - Order Management·110 columns

This view is used to retrieve Price Adjustments history. This is used by the history form.

APPS.OE_PRICE_ADJS_HISTORY_V·↳ OE_PRICE_ADJS_HISTORY·↳ QP_LIST_HEADERS_TL·Explore ONT 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 →

Table: ASO_PRICE_ADJUSTMENTS 12.2.2 satellite-leaning

owner ASO·ASO - Order Capture·94 columns

Table to Store the Price Adjustments

ASO.ASO_PRICE_ADJUSTMENTS·Explore ASO module →

Table: OE_PRICE_ADJS_IFACE_ALL 12.2.2 link

owner ONT·ONT - Order Management·94 columns

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

ONT.OE_PRICE_ADJS_IFACE_ALL·Explore ONT 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.