Join between qp_list_lines and oe_order_lines_all

Join between qp_list_lines and oe_order_lines_all

In this post , we will be discuss about the Joins between qp_list_lines and oe_order_lines_all. qp_list_lines tables belongs to Price list tables and  oe_order_lines_all tables belongs to Sales order tables in oracle apps. If we want to join between sales order price list tables and sales order tables in oracle apps. In qp_list_lines tables , we do store the selling price for sales items and then attach this price list table with sales order in oracle apps. Here below, Please find below the Detail join link and the sql query using Join between qp_list_lines and oe_order_lines_all.

 

 

Important Tables for Joining between qp_list_lines and oe_order_lines_all

1.qp_list_headers

2.qp_list_lines

3.qp_pricing_attributes

4.oe_order_lines_all

5.oe_order_headers_all

 

Detail SQL using the Join between qp_list_lines and oe_order_lines_all

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

Join between qp_list_lines and oe_order_lines_all