Search Results total_recurring_charges

Overview

XNC_ORDER_SUMMARY_V is a reporting view within the XNC product family — Sales for Communications, a module that Oracle designates as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view is documented as returning Order Header Details, presenting a consolidated, denormalized projection of order-level attributes alongside billing and shipping address information, contact names, payment attributes, and rolled-up charge totals. Its purpose is to supply downstream reporting and integration routines with a single-result-set representation of an order without requiring the consumer to join Order Management header tables, quote references, address tables, and charge aggregations manually.

Because the XNC module is flagged obsolete, the view carries no supported implementation footprint in current environments. The metadata records an implementation status of "Not implemented in this database," meaning the view is not deployed as a database object in the installation from which the documentation was generated. It therefore retains documentary value rather than operational value: it illustrates the schema design of the legacy Sales for Communications data model and remains relevant where historical or archived environments must be interrogated. Reporting use should be treated as read-only and confined to legacy instances.

Underlying Base Objects

The documented metadata lists no referenced base objects, and the dictionary-level "Referenced base objects" field is empty. However, the published view text reveals the sources against which the SELECT is defined. These are Oracle Order Management and Receivables-style tables, aliased in the view definition:

• AIOH — the order header source, supplying HEADER_ID, ORDER_NUMBER, FLOW_STATUS_CODE, ORDERED_DATE, ORDER_TYPE, currency, request date, tax exemption attributes, payment type, credit card approval code, credit card number, and expiration date.
• AQH — the quote header source, supplying QUOTE_NUMBER.
• RAS — the salesperson source, supplying NAME as SALESPERSON.
• RATR — the payment terms source, supplying NAME as PAYMENT_TERM.
• XITC — a charge aggregation source supplying recurring and one-time totals (RECURRING, ONE_TIME).
• BILLCONT / SHIPCONT — contact sources supplying first name, title, and last name for bill-to and ship-to contacts.
• INVADDR / SHIPADDR — address sources supplying address lines, city, county, province, state, postal code, and country.
• AIC — a credit card source supplying the CREDIT_CARD value.

Because no foreign key relationships are documented, the join predicates are not exposed in the metadata excerpt; analysts should derive them from the full view text in the target environment.

Key Columns

The view exposes order identity and lifecycle columns (HEADER_ID, ORDER_NUMBER, ORDER_STATUS from FLOW_STATUS_CODE, ORDERED_DATE, ORDER_TYPE_NAME, REQUEST_DATE). Commercial columns include SALESPERSON, SALES_CHANNEL (explicitly returned as NULL), TOTAL_RECURRING_CHARGES, TOTAL_ONE_TIME_CHARGES, and the currency columns CURR_RECURRING and CURR_ONETIME, both mapped to TRANSACTIONAL_CURR_CODE. Payment-related columns include PAYMENT_TYPE, PAYMENT_TERM, AUTHORIZATION_CODE, CREDIT_CARD, CARD_NUMBER, and — directly relevant to the search term — CARD_EXPIRATION_DATE, sourced from AIOH.CREDIT_CARD_EXPIRATION_DATE. Tax columns include TAX_EXEMPT_NUMBER and TAX_EXEMPT_REASON_CODE.

The address projection is notable for a documented defect: SHIP_TO_POSTAL_INFO is constructed using INVADDR.POSTAL_CODE rather than SHIPADDR.POSTAL_CODE, so ship-to postal output reflects the bill-to address. Consumers relying on ship-to postal accuracy must account for this.

Common Use Cases and Queries

Typical usage centres on order-level reporting and payment-instrument review, particularly for locating orders by card expiration. A representative query is:

• SELECT order_number, order_status, ordered_date, card_number, card_expiration_date FROM xnc_order_summary_v WHERE card_expiration_date < SYSDATE;
• SELECT order_number, bill_to_contact_name, bill_to_postal_info, ship_to_contact_name FROM xnc_order_summary_v WHERE order_status = 'BOOKED';
• SELECT order_number, total_recurring_charges, total_one_time_charges, curr_recurring FROM xnc_order_summary_v ORDER BY ordered_date DESC;

Given the obsolete status and the un-implemented flag, these queries apply only to legacy environments where the object was instantiated. Card-related columns, including card number and expiration date, are sensitive and should be masked or excluded in any extract intended for distribution.