oracle EBS order management OM Tables

This post contains affiliate links. Read the full disclosure here.

oe_order_headers_all
oe_order_lines_all

Pricing tables
qp_list_headers
qp_list_lines
qp_pricing_attributes

Adjustments details
OE_PRICE_ADJUSTMENTS
OE_ORDER_HOLDS_ALL
OE_ORDER_CREDIT_CHECK_RULES

Delivery Details table
wsh_delivery_details
wsh_delivery_assignments
WSH_NEW_DELIVERIES

OM table Joins

select qlh.NAME,QLH.DESCRIPTION,qlh.START_DATE_ACTIVE,qll.OPERAND,qll.ARITHMETIC_OPERATOR,
oola.ordered_quantity,oola.order_quantity_uom,oola.ordered_item,ooha.order_number
from apps.qp_list_headers qlh ,
apps.qp_list_lines qll,
apps.qp_pricing_attributes qpa,
apps.oe_order_lines_all oola,
apps.oe_order_headers_all ooha
WHERE qlh.list_HEADER_ID=qll.list_HEADER_ID
and qpa.LIST_LINE_ID=qll.LIST_LINE_ID
and qpa.list_HEADER_ID=qlh.list_HEADER_ID
and to_char(oola.INVENTORY_ITEM_ID) =QPA.PRODUCT_ATTR_VALUE
and oola.header_id=ooha.header_id
and ooha.order_number=P_ORDER_NUMBER

Shadab

Hi, I am passionate about technology be it hardware or software. I like to write blogs and help people.

Leave a Reply