oracle EBS order management OM Tables

oe_order_headers_alloe_order_lines_all Pricing tablesqp_list_headersqp_list_linesqp_pricing_attributes Adjustments detailsOE_PRICE_ADJUSTMENTSOE_ORDER_HOLDS_ALLOE_ORDER_CREDIT_CHECK_RULES Delivery Details tablewsh_delivery_detailswsh_delivery_assignmentsWSH_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_numberfrom 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 oohaWHERE qlh.list_HEADER_ID=qll.list_HEADER_IDand qpa.LIST_LINE_ID=qll.LIST_LINE_IDand qpa.list_HEADER_ID=qlh.list_HEADER_IDand to_char(oola.INVENTORY_ITEM_ID) =QPA.PRODUCT_ATTR_VALUEand oola.header_id=ooha.header_idand ooha.order_number=P_ORDER_NUMBER

Continue Readingoracle EBS order management OM Tables