Sunday, 22 June 2014

How to find freight charges on order lines in Order Management

SELECT   header_id, line_id, charge_id, charge_name, charge_amount,
         currency_code, invoiced_flag, interco_invoiced_flag, org_id,
         source_system_code, estimated_flag, invoiced_amount
    FROM oe_charge_lines_v
   WHERE header_id = (SELECT header_id
                        FROM oe_order_headers_all
                       WHERE order_number = 151266)
ORDER BY line_id

/

Note: The OE_CHARGE_LINES_V view is based on
OE_PRICE_ADJUSTMENTS,  OE_ORDER_HEADERS_ALL  AND OE_ORDER_LINES_ALL for FREIGHT CHARGES.

No comments:

Post a Comment