Results for “ac_amount”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_DSNO_ALLOWANCE_CHARGES_V is a Shipping Execution (WSH) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name reflects its role within the Delivery Server Notification (DSNO) integration framework: it exposes order-level allowance and freight charge information associated with shippable delivery details so that outbound notification processes can report these charges per delivery line. The view answers the question of how much of a sales-order charge (such as freight or a surcharge) applies to a given delivery detail, and whether that charge is additive or a credit.

The view is read-only and derived entirely from pre-existing objects; it holds no data of its own and inherits the transactional state of the delivery and order charge lines at query time. Because it surfaces freight and allowance amounts alongside delivery identifiers, it is typically consumed by integration programs, concurrent notification processes, and reporting tools that must transmit financial charge data to external systems (for example, a Transportation Management or Warehouse Management integration endpoint).

Underlying Base Objects

The documented base objects referenced by this view are:

• OE_CHARGE_LINES_V (VIEW) — supplies the charge definition: charge name, amount, currency, conversion attributes, and descriptive flexfield context/attributes.
• WSH_DELIVERY_DETAILS (SYNONYM) — supplies the delivery detail, source header, source line, inventory item, container flag, and shipped quantity used to join and filter rows.
• WSH_FC_INTERFACE_PKG (PACKAGE) — furnishes the PRORATE_FREIGHT_CHARGE function, which proportionally allocates a freight charge to a specific delivery detail.
• ONT_CHARGE_UTIL (PACKAGE) — referenced by the charge-line view layer supporting the OE_CHARGE_LINES_V definition.

The view joins OE_CHARGE_LINES_V to WSH_DELIVERY_DETAILS on header and line identifiers, restricting results to source code 'OE', non-container delivery details (CONTAINER_FLAG = 'N'), and details with a non-zero shipped quantity.

Key Columns

• DELIVERY_DETAIL_ID — primary delivery-detail identifier; the proration key passed to the freight-charge function.
• ORDER_HEADER_ID / ORDER_LINE_ID — the originating sales-order header and line (mapped from SOURCE_HEADER_ID and SOURCE_LINE_ID).
• ITEM_ID — inventory item on the delivery detail.
• AC_INDICATOR — additive/credit flag derived from the charge amount sign: 'A' when the charge is negative, otherwise 'C'.
• AC_AMOUNT — absolute prorated charge amount returned by WSH_FC_INTERFACE_PKG.PRORATE_FREIGHT_CHARGE.
• AC_CHARGE_NAME — name of the order charge.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency and conversion metadata for the charge.
• FC_CONTEXT, FC_ATTRIBUTE1–FC_ATTRIBUTE15 — descriptive flexfield context and attribute values carried on the charge line.

Common Use Cases and Queries

Typical uses include extracting prorated freight and allowance amounts per delivery detail for notification payloads, reconciling order charges against delivery lines, and auditing flexfield attributions on freight charges. A representative query:

• Retrieve prorated freight for a specific delivery detail: SELECT ac_amount, ac_indicator, ac_charge_name, currency_code FROM wsh_dsno_allowance_charges_v WHERE delivery_detail_id = :p_detail_id;
• List all charges for an order: SELECT order_line_id, delivery_detail_id, ac_charge_name, ac_amount FROM wsh_dsno_allowance_charges_v WHERE order_header_id = :p_header_id ORDER BY order_line_id;
• Sum freight by currency for a set of shipment lines before passing totals to an external carrier interface.

Because AC_AMOUNT is computed via a packaged function at runtime, queries returning large row sets may incur additional processing cost; predicates on delivery detail or order identifiers are advisable.