Results for “orig_tax_code”

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

Overview

ASO_TAX_DETAILS is a transactional table in the ASO (Order Capture) product of Oracle E-Business Suite, holding tax calculation details associated with quoted configurations, quote lines, and quote shipments. It is the persistence layer for tax lines generated on a quote so that tax can be retained, re-displayed, and carried forward when a quote is converted to an order. The table exists in both 12.1.1 and 12.2.2 and is documented as VALID under the ASO schema, with 46 columns and a documented unique index ASO_TAX_DETAILS_U1 on TAX_DETAIL_ID.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object heuristically as a link: it records an association between a quote header, a quote line, and a quote shipment, with the tax measures (rate, amount, exemption attributes) carried as dependent attributes. A Data Vault design would typically model these relationships as a link table plus a satellite holding the tax descriptors and audit columns.

Key Information Stored

Each row anchors on the scalar primary key TAX_DETAIL_ID, which is enforced both by ASO_TAX_DETAILS_PK and by the unique index ASO_TAX_DETAILS_U1. The remaining business context columns identify the owning quote entities and the calculated tax values:

• QUOTE_HEADER_ID – foreign key to ASO_QUOTE_HEADERS_ALL; the quote that owns the tax detail.
• QUOTE_LINE_ID – foreign key to ASO_QUOTE_LINES_ALL; the line-level tax reference.
• QUOTE_SHIPMENT_ID – foreign key to ASO_SHIPMENTS; the shipment context for the tax line.
• TAX_CODE and ORIG_TAX_CODE – the applied tax code and its originating code prior to any override.
• TAX_RATE and TAX_RATE_ID – the rate value and the reference to the rate definition used.
• TAX_AMOUNT – the calculated tax value for the associated quote entity.
• TAX_DATE – the effective date of the tax determination.
• TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE – exemption handling captured at quote time.
• TAX_INCLUSIVE_FLAG – indicates whether the tax is inclusive of the quoted price.
• SECURITY_GROUP_ID – foreign key to FND_SECURITY_GROUPS, enforcing multi-org style data segregation.
• OBJECT_VERSION_NUMBER – optimistic locking column used by the ASO business logic.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – concurrent program audit trace.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the standard WHO audit block.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1…ATTRIBUTE20 – the DFF flexfield segment set used for extensibility.

Common Use Cases and Queries

Typical usage is reporting and reconciliation of tax charged against quotes, and supporting conversion of quotes into orders where tax must be reproduced. A representative join retrieves all tax lines for a quote header:

• SELECT t.tax_detail_id, t.quote_line_id, t.tax_code, t.tax_rate, t.tax_amount, t.tax_exempt_flag FROM aso.aso_tax_details t WHERE t.quote_header_id = :p_quote_header_id ORDER BY t.quote_line_id;
• SELECT t.tax_detail_id, l.line_number, s.shipment_number, t.tax_amount FROM aso.aso_tax_details t JOIN aso.aso_quote_lines_all l ON l.quote_line_id = t.quote_line_id JOIN aso.aso_shipments s ON s.shipment_id = t.quote_shipment_id WHERE t.security_group_id = :p_sec_group;
• SELECT tax_code, SUM(tax_amount) tax_total FROM aso.aso_tax_details GROUP BY tax_code;

Exemption audits query TAX_EXEMPT_FLAG with TAX_EXEMPT_NUMBER and TAX_EXEMPT_REASON_CODE. Control checks compare ORIG_TAX_CODE against TAX_CODE to detect manual overrides. Because tax details are keyed on quote entities, the table is usually accessed through the quote header or line, not queried standalone.

Related Objects

• ASO_QUOTE_HEADERS_ALL – joined on QUOTE_HEADER_ID; the parent quote header.
• ASO_QUOTE_LINES_ALL – joined on QUOTE_LINE_ID; supplies line-level context.
• ASO_SHIPMENTS – joined on QUOTE_SHIPMENT_ID; identifies shipment-level tax.
• FND_SECURITY_GROUPS – joined on SECURITY_GROUP_ID; controls visibility.
• ASO_TAX_DETAILS_PK / ASO_TAX_DETAILS_U1 – primary key constraint and unique index on TAX_DETAIL_ID.
• ASO Quote / Order Capture APIs – public ASO quote manipulation APIs and quote conversion logic write and read tax detail rows during pricing and order import.