Order management Tables

select * from oe_order_headers_all

select * from oe_order_lines_all

select * from oe_order_sources

select * from oe_price_adjustments

select * from oe_order_price_attribs

select * from oe_order_holds_all

select * from wsh_new_deliveries

select * from wsh_delivery_details

select * from wsh_delivery_assignments

select * from wsh_trip_stops

select * from qp_list_headers

select * from qp_list_lines

 select * from oe_hold_definitions

select * from oe_hold_authorizations

select * from oe_hold_sources_all

select * from oe_order_holds_all

select * from oe_hold_releases_all

Links:


 SOLD_FROM_ORG_ID  =   (ORG_ID)
SOLD_TO_ORG_ID    =   (CUST_ACCOUNT_ID)
SHIP_FROM_ORG_ID  =   (ORGANIZATION_ID)
SHIP_TO_ORG_ID    =   (SHIP to SITE_USE_ID)
INVOICE_TO_ORG_ID =   (BILL to SITE_USE_ID)