Results for “content_owner_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ZX_EXEMPTIONS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the FND – Application Object Library product group. It is part of the E-Business Tax (ZX) module infrastructure and exposes exemption certificate data in a denormalized form suitable for inquiry, reporting, and integration consumption. The view consolidates rows from the base transaction table ZX_EXEMPTIONS and joins them to lookup, party tax profile, and operating unit entities to present human-readable exemption information.
The view is defined over the synonyms and views ZX_EXEMPTIONS, ZX_PARTY_TAX_PROFILE, HZ_PARTY_SITES, FND_LOOKUP_VALUES, HR_OPERATING_UNITS, GL_LEDGER_LE_V, and XLE_ENTITY_PROFILES. It is a UNION ALL construct: the first branch resolves third-party exemption certificates registered against a party tax profile, while the second branch resolves certificates tied to a specific party site. Both branches normalize the exemption data into a common column list.
Underlying Base Objects
The primary driver is ZX_EXEMPTIONS, which stores exemption certificate records including certificate number, reason code, status, rate modifier, tax regime, effective dates, customer account, site use, and the content owner (the operating unit or legal entity that owns the record). FND_LOOKUP_VALUES supplies the translated meaning for the EXEMPT_REASON_CODE lookup type 'ZX_EXEMPTION_REASON_CODE', filtered by security group 0 and the session language. ZX_PARTY_TAX_PROFILE is joined twice in the first branch — once as PTP_PARTY for the third-party tax profile and once as OU for the content owner profile. HZ_PARTY_SITES and ZX_PARTY_TAX_PROFILE are used in the second branch to resolve the party site. HR_OPERATING_UNITS, GL_LEDGER_LE_V, and XLE_ENTITY_PROFILES support the operating unit and legal entity context that the products layer relies on when filtering by legal entity.
Key Columns
- EXEMPT_CERTIFICATE_NUMBER — the certificate identifier; rows with NULL are excluded by the view definition.
- EXEMPT_REASON_CODE / MEANING — the coded reason and its translated display meaning.
- EXEMPTION_STATUS_CODE — restricted to PRIMARY, MANUAL, or UNAPPROVED; UNAPPROVED and MANUAL certificates are surfaced alongside fully approved ones.
- RATE_MODIFIER, TAX_REGIME_CODE — the tax treatment applied when the exemption is honored.
- CUST_ACCOUNT_ID, SITE_USE_ID — the customer and site use the certificate applies to.
- PARTY_ID, PARTY_SITE_ID — the resolved party in the first branch; the second branch supplies the site-level party in PARTY_SITE_ID.
- CONTENT_OWNER_ID, ORG_ID — the owning profile and the operating unit party identifier.
- LE_ID — explicitly selected as NULL in both branches. The view text contains a comment noting that products should join using NVL(ZX_EXEMPTIONS_V.LE_ID, :LE_ID) = :LE_ID, with :LE_ID supplied by the calling product. This is the column relevant to the search term "le_id": it is intentionally NULL at the view level and is populated by the consuming query, allowing legal-entity-scoped filtering without hard-coding the entity in the view.
- EFFECTIVE_FROM / EFFECTIVE_TO — the validity window of the certificate.
Common Use Cases and Queries
The view supports exemption certificate reporting, tax determination debugging, and integration extracts where exemption data must be presented with descriptive reasons and owner context. A typical query joining for a legal entity is:
SELECT exempt_certificate_number,
exempt_reason_code,
meaning,
exemption_status_code,
party_id,
org_id,
effective_from,
effective_to
FROM zx_exemptions_v
WHERE NVL(le_id, :le_id) = :le_id
AND TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_to, TRUNC(SYSDATE));
The NVL pattern is significant: because LE_ID is returned as NULL, the predicate resolves to :le_id = :le_id when the view row is not entity-specific, and filters correctly when the products layer supplies an entity-specific value. Analysts querying the view directly should therefore pass a bind variable rather than filtering on LE_ID alone, since a literal comparison against NULL would return no rows. Additional common filters include CUST_ACCOUNT_ID for customer-level analysis, ORG_ID for operating unit reporting, and EXEMPTION_STATUS_CODE to isolate unapproved or manual certificates requiring review.
-
View: ZX_EXEMPTIONS_V 12.1.1
APPS.ZX_EXEMPTIONS_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTY_SITES·↳ ZX_EXEMPTIONS·Explore FND module →
-
This table is for future use.
-
This table is for future use.
-
View: ZX_SIM_RULES_V 12.1.1
APPS.ZX_SIM_RULES_V·↳ FND_APPLICATION_VL·↳ HR_OPERATING_UNITS·↳ ZX_SIM_RULES_VL·Explore FND module →
-
Table: ZX_SIM_RULES_B 12.2.2
This table is for future use.
-
View: ZX_SIM_RULES_VL 12.2.2
APPS.ZX_SIM_RULES_VL·↳ ZX_REGIMES_VL·↳ ZX_SIM_RULES_B·↳ ZX_SIM_RULES_TL·Explore FND module →
-
View: ZX_SIM_RULES_V 12.2.2
APPS.ZX_SIM_RULES_V·↳ FND_APPLICATION_VL·↳ HR_OPERATING_UNITS·↳ ZX_SIM_RULES_VL·Explore FND module →
-
Table: ZX_SIM_RULES_B 12.1.1
This table is for future use.
-
View: ARFV_AR_TAX_CODES 12.1.1
- Retrofitted
APPS.ARFV_AR_TAX_CODES·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ ZX_ACCOUNTS·Explore AR module →
-
View: ARBV_AR_TAX_CODES 12.2.2
- Retrofitted
APPS.ARBV_AR_TAX_CODES·↳ ZX_ACCOUNTS·↳ ZX_PARTY_TAX_PROFILE·↳ ZX_RATES_B·Explore AR module →
-
View: ARBV_AR_TAX_CODES 12.1.1
- Retrofitted
APPS.ARBV_AR_TAX_CODES·↳ ZX_ACCOUNTS·↳ ZX_PARTY_TAX_PROFILE·↳ ZX_RATES_B·Explore AR module →
-
This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process.
-
APPS.ZX_TAX_CONDITION_ACTIONS_V·↳ AR_TAX_CONDITION_ACTIONS_ALL·↳ ZX_CEC_LOOKUPS·Explore FND module →
-
View: ZX_MCO_LV_RULES_V 12.2.2
APPS.ZX_MCO_LV_RULES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
View: ZX_MCO_LV_RULES_V 12.1.1
APPS.ZX_MCO_LV_RULES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
This table contains tax options for a ledger or an account segment value. Each record represents input or output tax options defined by a configuration owner for a ledger or for a specific account segment value within that ledger.
-
View: ZX_EXEMPTIONS_V 12.2.2
APPS.ZX_EXEMPTIONS_V·↳ FND_LOOKUP_VALUES·↳ GL_LEDGER_LE_V·↳ HR_OPERATING_UNITS·Explore FND module →
-
View: ZX_MCO_EO_RULES_V 12.2.2
APPS.ZX_MCO_EO_RULES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
APPS.ZX_REC_NREC_DIST_QUOTE_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_REC_NREC_DIST·↳ ZX_REC_NREC_DIST_GT·Explore FND module →
-
Table: ZX_TAX_RELATIONS_T 12.2.2
This table stores parent child relationships of tax codes within tax groups. This table is used for tax groups migration from prior releases.
-
This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner.
-
View: ZX_ACCOUNT_RATES_MIG_V 12.2.2
APPS.ZX_ACCOUNT_RATES_MIG_V·↳ ZX_ACCOUNT_RATES·Explore FND module →
-
This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process.
-
This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction.
-
View: ZX_SIM_RULES_VL 12.1.1
APPS.ZX_SIM_RULES_VL·↳ ZX_REGIMES_VL·↳ ZX_SIM_RULES_B·↳ ZX_SIM_RULES_TL·Explore FND module →
-
APPS.ZX_TAX_CONDITION_LINES_V·↳ AR_TAX_CONDITION_LINES_ALL·↳ ZX_CEC_LOOKUPS·Explore FND module →
-
View: ARFV_AR_TAX_CODES 12.2.2
- Retrofitted
APPS.ARFV_AR_TAX_CODES·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ ZX_ACCOUNTS·Explore AR module →
-
Table: ZX_TAX_RELATIONS_T 12.1.1
This table stores parent child relationships of tax codes within tax groups. This table is used for tax groups migration from prior releases.
-
View: ZX_SCO_STATUS_V 12.2.2
APPS.ZX_SCO_STATUS_V·↳ ZX_STATUS_B·↳ ZX_STATUS_TL·↳ ZX_SUBSCRIPTION_DETAILS·Explore FND module →
-
View: ZX_MCO_LV_RATES_V 12.2.2
APPS.ZX_MCO_LV_RATES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule.
-
This table contains tax options for a ledger or an account segment value. Each record represents input or output tax options defined by a configuration owner for a ledger or for a specific account segment value within that ledger.
-
View: ZX_LINES_SUMMARY_V 12.2.2
APPS.ZX_LINES_SUMMARY_V·↳ ZX_LINES_SUMMARY·↳ ZX_RATES_TL·↳ ZX_TAXES_B·Explore FND module →
-
View: ZX_MCO_LV_TAXES_V 12.2.2
APPS.ZX_MCO_LV_TAXES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
This table stores tax exemptions for parties, party sites and items. Each record contains an exemption percentage of a specific tax rate for a party, party site or an item.
-
View: ZX_RULES_VL 12.1.1
APPS.ZX_RULES_VL·↳ ZX_RULES_B·↳ ZX_RULES_TL·Explore FND module →
-
View: ZX_ACCOUNT_RATES_NEW_V 12.1.1
APPS.ZX_ACCOUNT_RATES_NEW_V·↳ FND_GLOBAL·↳ GL_LEDGERS·↳ ZX_ACCOUNT_RATES·Explore ZX module →
-
APPS.ZX_TAX_CONDITION_ACTIONS_V·↳ AR_TAX_CONDITION_ACTIONS_ALL·↳ ZX_CEC_LOOKUPS·Explore FND module →
-
APPS.ZX_TAX_CONDITION_LINES_V·↳ AR_TAX_CONDITION_LINES_ALL·↳ ZX_CEC_LOOKUPS·Explore FND module →
-
This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction.
-
View: ZX_SCO_RULES_B_V 12.2.2
-
View: ZX_SCO_RULES_B_V 12.1.1
-
View: ZX_MCO_LV_RATES_V 12.1.1
APPS.ZX_MCO_LV_RATES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
View: ZX_RATES_VL 12.2.2
APPS.ZX_RATES_VL·↳ ZX_RATES_B·↳ ZX_RATES_TL·Explore FND module →
-
View: ZX_MCO_LV_TAXES_V 12.1.1
APPS.ZX_MCO_LV_TAXES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner.
-
View: ZX_SCO_RATES_B_V 12.2.2
APPS.ZX_SCO_RATES_B_V·↳ ZX_RATES_B·↳ ZX_SUBSCRIPTION_DETAILS·Explore FND module →
-
View: ZX_RULES_VL 12.2.2
APPS.ZX_RULES_VL·↳ ZX_RULES_B·↳ ZX_RULES_TL·Explore FND module →
-
View: ZX_MCO_LV_STATUS_V 12.1.1
APPS.ZX_MCO_LV_STATUS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
View: ZX_MCO_LV_STATUS_V 12.2.2
APPS.ZX_MCO_LV_STATUS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →