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.
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.