Search Results tax_quantity

Overview

The view SO_TAX_LINES_CREDIT_CHECK_V is an Order Entry (OE) database object within Oracle E-Business Suite that consolidates tax-relevant order line data for credit checking and tax calculation purposes. It presents a unified projection of shipping, billing, header, line, and currency attributes associated with sales order tax lines, allowing downstream Oracle modules — principally Credit Management, Receivables, and the E-Business Tax engine — to evaluate tax liability and exposure on uninvoiced order lines without directly joining the underlying transactional tables.

Within the ETRM documentation set for 12.1.1 and 12.2.2, this view is catalogued under product code OE (Order Entry). The metadata explicitly states "Not implemented in this database," indicating that the view is supplied as part of the shipped Oracle EBS schema but is not materialized or instantiated within the documented reference environment. Its role is best understood as a query interface: it normalizes disparate attributes across order headers and lines into a structure resembling an AR tax line, so that the tax and credit-checking processes can consume order data through a consistent column contract.

Underlying Base Objects

The documented ETRM metadata lists no referenced base objects, and the view definition itself is presented only as raw view text. Based on the exposed column aliases — A_SHIP, A_BILL, H, L, C, V, S_SHIP, S_BILL, and INV_TYPE — the view derives from standard Order Entry and Receivables objects. These aliases correspond to standard EBS tables including OE_ORDER_HEADERS_ALL (H), OE_ORDER_LINES_ALL (L), HZ_CUST_ACCOUNTS and HZ_CUST_ACCT_SITES_ALL (A_SHIP, A_BILL), HZ_CUST_SITE_USES_ALL (S_SHIP, S_BILL), FND_CURRENCIES (C), and a tax code source (V) drawing from the tax determination layer. Because base objects are not documented in ETRM, the join structure should be validated against the live schema before any production dependency is established.

Key Columns

• TRX_HEADER_ID / TRX_LINE_ID — Order header and line identifiers, enabling correlation back to the sales order.
• SHIP_TO_CUSTOMER_ID, BILL_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID — Party and site identifiers central to tax jurisdiction and credit determination.
• SHIP_TO_LOCATION_CCID, BILL_TO_LOCATION_CCID, SHIP_TO_POSTAL_CODE, BILL_TO_POSTAL_CODE — Address details used by the tax engine to resolve jurisdiction.
• TAX_CODE, TAX_RATE, TAX_QUANTITY, EXTENDED_AMOUNT — Tax configuration and the computed taxable basis (ordered less cancelled less invoiced quantity, multiplied by selling price).
• TAXABLE_FLAG — Derived from INV_TYPE.TAX_CALCULATION_FLAG and the header TAX_EXEMPT_FLAG, indicating whether the line is subject to tax.
• TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE — Exemption attributes carried from the order header.
• TRX_CURRENCY_CODE, EXCHANGE_RATE, PRECISION, MINIMUM_ACCOUNTABLE_UNIT — Currency context for monetary evaluation.
• TRX_DATE — Resolved from schedule date, requested date, or promise date, with a SYSDATE fallback.

Common Use Cases and Queries

The view is typically queried by credit-checking and tax reporting routines needing order-level tax exposure by customer, site, and item. A representative query aggregates taxable exposure per customer:

• SELECT ship_to_customer_id, bill_to_customer_id, SUM(extended_amount) taxable_basis FROM so_tax_lines_credit_check_v WHERE taxable_flag = 'Y' GROUP BY ship_to_customer_id, bill_to_customer_id;
• SELECT trx_header_id, trx_line_id, tax_code, tax_rate, tax_quantity, extended_amount FROM so_tax_lines_credit_check_v WHERE ship_to_postal_code = :postal_code;

The LOCATION_QUALIFIER column is fixed to 'ALL', and numerous columns (TAX_AMOUNT, GL_DATE, SET_OF_BOOKS_ID, address code columns) are returned as NULL placeholders, indicating the view exposes a partial AR-style tax line contract intended for down-stream augmentation rather than direct posting.