Thursday, October 7, 2010

Sales Order Details

select ooh.created_by,
ooh.order_number,
qlh.NAME ,
qlh.CURRENCY_CODE,
msi.segment1 item_no,
msi.description item_desc,
qll.operand,
ool.unit_selling_price,
ool.attribute1 ,
acv.customer_name
from qp_list_headers qlh,
qp_list_lines_v qll,
oe_order_headers_all ooh,
oe_order_lines_all ool,
mtl_system_items_b msi,
ar_customers_v acv
where qlh.LIST_HEADER_ID = qll.list_header_id
and qlh.ORIG_ORG_ID = ooh.org_id
and qlh.LIST_HEADER_ID = ooh.price_list_id
and ooh.header_id = ool.header_id
and ooh.org_id = ool.org_id
and ool.inventory_item_id = qll.product_id
and ool.ship_from_org_id = msi.organization_id
and ool.inventory_item_id = msi.inventory_item_id
and acv.customer_id = ooh.sold_to_org_id
/

No comments:

Post a Comment