13 May 2009

Sales Orders: How to find total cost of Sales Order

Using following function to find the cost of a Sales ORDER.

select
TO_CHAR(oe_oe_totals_summary.prt_order_total (header_id),
fnd_currency.safe_get_format_mask (transactional_curr_code, 30)
) order_total
from OE_ORDER_HEADERS_ALL

No comments: