Search Results location_context

Overview

RA_TAX_EXEMPTIONS_STRC_V is an Oracle E-Business Suite Receivables (AR) view owned by the APPS schema. It is documented in ETRM as a Release 115 (11i) construct, and its metadata remains catalogued in later releases including 12.1.1 and 12.2.2 for backward compatibility. The view presents tax exemption records maintained in Receivables in a reporting-friendly format, denormalizing the coded values held on the base tax exemption entity into their human-readable meanings.

The suffix "STRC" reflects a "structure" or presentation view, indicating that it is intended primarily for inquiry, reporting, and integration rather than for transactional processing. The view exposes the full tax exemption structure, including organization context, customer and site references, exemption type, applicable tax code, effective date ranges, exemption percentages, and the ten-segment location identifier. It also decodes the exemption status and reason code through lookups, which is the principal value it adds over the underlying table.

Because the object is documented as Release 115 only, it should be treated as a legacy reporting artifact in 12.1.1 and 12.2.2 environments. It remains valid where present, but new development should confirm the view's existence and definition in the target instance before relying upon it.

Underlying Base Objects

The ETRM metadata for 12.2.2 documents two referenced base objects: the AR_LOOKUPS view and the RA_TAX_EXEMPTIONS synonym. The view definition confirms these dependencies. RA_TAX_EXEMPTIONS supplies every fact column, while AR_LOOKUPS is joined twice to resolve decoded display values.

• RA_TAX_EXEMPTIONS — the primary source of tax exemption rows. The view selects directly from this object using the alias EX, including ROWID as ROW_ID.
• AR_LOOKUPS (LK1) — joined on LOOKUP_TYPE = 'TAX_EXEMPT_STATUS' and LOOKUP_CODE = STATUS, producing the STATUS_DISP column. This is an inner join.
• AR_LOOKUPS (LK2) — outer-joined on LOOKUP_TYPE(+) = 'TAX_REASON' and LOOKUP_CODE(+) = REASON_CODE, producing REASON_CODE_DISP. The outer join allows exemptions with no reason code to remain visible.

The relationship is therefore one exemption row to one status lookup row and zero-or-one reason lookup row. No filtering predicates beyond the lookup joins are present, so the view returns all rows of RA_TAX_EXEMPTIONS that satisfy the mandatory status lookup.

Key Columns

• ROW_ID — the ROWID of the underlying exemption row, useful for identifying the physical row.
• ORG_ID — the operating unit that owns the exemption, essential for multi-org reporting.
• TAX_EXEMPTION_ID — primary key of the exemption.
• STATUS / STATUS_DISP — the stored status code and its decoded meaning from TAX_EXEMPT_STATUS lookups.
• CUSTOMER_ID / SITE_USE_ID — the customer and, where applicable, the specific site use to which the exemption applies.
• INVENTORY_ITEM_ID / TAX_CODE — optional item and tax code scope for the exemption.
• EXEMPTION_TYPE / PERCENT_EXEMPT / CUSTOMER_EXEMPTION_NUMBER — classification, percentage of tax exempted, and the customer's own certificate reference.
• START_DATE / END_DATE — the effective window of the exemption.
• LOCATION_CONTEXT and LOCATION_ID_SEGMENT_1..10 — together these describe the geographic or location applicability of the exemption. LOCATION_CONTEXT identifies the context or structure against which the location identifier is interpreted, while the ten segments hold the flexfield values themselves. This is the column most directly relevant to the "location_context" search term.
• IN_USE_FLAG, REASON_CODE / REASON_CODE_DISP, EXEMPT_CONTEXT, EXEMPT_PERCENT1..10 — usage indicator, decoded reason, exemption context, and the multi-tier percentage columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1..15 — the standard descriptive flexfield columns.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, PROGRAM_ID, REQUEST_ID, PROGRAM_APPLICATION_ID and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include auditing active customer tax exemptions, reconciling exemption certificates against tax calculation results, and feeding external tax engines that require decoded status and location context.

List active exemptions with their decoded status and location context:

• SELECT tax_exemption_id, customer_id, site_use_id, status_disp, exemption_type, tax_code, percent_exempt, start_date, end_date, location_context FROM ra_tax_exemptions_strc_v WHERE org_id = :p_org AND status_disp = 'Active' AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE + 1);

Retrieve location flexfield segments for a specific exemption:

• SELECT tax_exemption_id, location_context, location_id_segment_1, location_id_segment_2, location_id_segment_3 FROM ra_tax_exemptions_strc_v WHERE tax_exemption_id = :p_id;

Report exemptions by reason code:

• SELECT reason_code, reason_code_disp, COUNT(*) FROM ra_tax_exemptions_strc_v GROUP BY reason_code, reason_code_disp ORDER BY 3 DESC;

Because the object is a simple select view over the base table and lookups, it is not updatable through the view for the lookup-derived columns and should be used for read-only access. In 12.1.1 and 12.2.2, verify the view's presence before use, as its documentation is scoped to Release 115.