Results for “tax_regime_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ZX_MCO_CHECK_ACCESS_V is an Oracle E-Business Suite view owned by the APPS schema, classified under the FND — Application Object Library product family, and documented as VALID in ETRM 12.2.2 (compatible with 12.1.1). The view belongs to the Oracle E-Business Tax (ZX) regime and supports Multi-Country Operations (MCO) functionality by determining whether the currently logged-in operating unit holds access rights to specific tax regime and first-party organization combinations stored in subscription details. Rather than exposing raw subscription rows, the view computes two derived boolean-style flags — UPDATE_ACCESS and DUPLICATE_ACCESS — and reduces multiple subscription rows to a single authoritative row per regime/first-party pairing. This makes it a decision-support object consumed by ETRM configuration, tax regime setup, and multi-country subscription maintenance screens rather than a standalone reporting table. Because it references FND_PROFILE.VALUE, its output is session-dependent: results differ based on the ZX_GCO_WRITE_ACCESS profile option value for the current responsibility and user.
Underlying Base Objects
The view is defined over two documented base objects:
- ZX_SUBSCRIPTION_DETAILS (SYNONYM): the primary source of subscription data, supplying
PARENT_FIRST_PTY_ORG_ID,TAX_REGIME_CODE,VIEW_OPTIONS_CODE, andFIRST_PTY_ORG_ID. A synonym resolves this to the underlying ZX subscription detail entity. - FND_PROFILE (PACKAGE): invoked as
FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS')to determine whether the current session carries global write access for tax configuration.
The view's logic is layered. An inner query filters ZX_SUBSCRIPTION_DETAILS using a WHERE clause that admits all rows where FIRST_PTY_ORG_ID <> -99, plus rows where FIRST_PTY_ORG_ID = -99 only when the write-access profile is 'Y'. It then derives UPDATE_ACCESS and DUPLICATE_ACCESS via DECODE expressions, and assigns PFPO_NUM using ROW_NUMBER() OVER (PARTITION BY TAX_REGIME_CODE, PARENT_FIRST_PTY_ORG_ID ORDER BY VIEW_OPTIONS_CODE DESC). The outer query retains only rows where PFPO_NUM = 1, guaranteeing one result row per regime/parent first-party organization key.
Key Columns
- PARENT_FIRST_PTY_ORG_ID: the parent first-party organization identifier (legally the operating unit or legal entity); value
-99denotes the global/shared regime context reserved for users with write access. - TAX_REGIME_CODE: the tax regime code (e.g., the country-specific regime) — the primary functional key users search on.
- VIEW_OPTIONS_CODE: the subscription option driving access semantics; documented literals include
VFC(view full configuration),VFD(view full data), andVFR(view full reference). - UPDATE_ACCESS: 'Y' when
-99global context coincides with theZX_GCO_WRITE_ACCESSprofile of 'Y', otherwise 'Y' only whenVIEW_OPTIONS_CODE = 'VFC'; 'N' otherwise. Indicates the session may modify regime subscription data. - DUPLICATE_ACCESS: 'Y' only for the global
-99context whenVIEW_OPTIONS_CODEisVFDorVFR; 'N' otherwise. Signals authority to copy/duplicate regime setup. - PFPO_NUM: the analytic row number used internally to collapse duplicates; always
1in returned rows.
Common Use Cases and Queries
The view is typically joined to regime and first-party organization lookups to render access-controlled setup lists and to gate write operations in MCO maintenance forms. A representative query filtering by the searched token follows:
SELECT tax_regime_code,
parent_first_pty_org_id,
view_options_code,
update_access,
duplicate_access
FROM apps.zx_mco_check_access_v
WHERE tax_regime_code = :p_regime_code
AND update_access = 'Y';
To enumerate regimes a session can duplicate:
SELECT tax_regime_code FROM apps.zx_mco_check_access_v WHERE duplicate_access = 'Y' ORDER BY tax_regime_code;
Because results depend on FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS'), queries must be executed within an initialized EBS session (same responsibility and user) for meaningful output; direct SQL*Plus access without profile context yields only the -99-excluded rows. The view is read-only by design and should not be updated directly.
-
View: ZX_MCO_CHECK_ACCESS_V 12.2.2
APPS.ZX_MCO_CHECK_ACCESS_V·↳ FND_PROFILE·↳ ZX_SUBSCRIPTION_DETAILS·Explore FND module →
-
View: ZX_USER_PROC_INPUT_V 12.1.1
APPS.ZX_USER_PROC_INPUT_V·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
View: ZX_SCO_INPUT_RATES_V 12.1.1
APPS.ZX_SCO_INPUT_RATES_V·↳ ZX_INPUT_CLASSIFICATIONS_V·↳ ZX_JURISDICTIONS_B·↳ ZX_JURISDICTIONS_TL·Explore FND module →
-
APPS.ZX_USER_PROC_HDR_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
APPS.ZX_USER_PROC_HDR_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
View: ZX_MCO_CHECK_ACCESS_V 12.1.1
APPS.ZX_MCO_CHECK_ACCESS_V·↳ FND_PROFILE·↳ ZX_SUBSCRIPTION_DETAILS·Explore FND module →
-
View: ZX_USER_PROC_INPUT_V 12.2.2
APPS.ZX_USER_PROC_INPUT_V·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
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 →
-
View: ZX_EXEMPTIONS_V 12.1.1
APPS.ZX_EXEMPTIONS_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTY_SITES·↳ ZX_EXEMPTIONS·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 →
-
View: ZX_SCO_INPUT_RATES_V 12.2.2
APPS.ZX_SCO_INPUT_RATES_V·↳ ZX_INPUT_CLASSIFICATIONS_V·↳ ZX_JURISDICTIONS_B·↳ ZX_JURISDICTIONS_TL·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 →
-
View: ZX_DET_FACTOR_TEMPL_VL 12.1.1
APPS.ZX_DET_FACTOR_TEMPL_VL·↳ ZX_DET_FACTOR_TEMPL_B·↳ ZX_DET_FACTOR_TEMPL_TL·Explore FND module →
-
View: ZX_DET_FACTOR_TEMPL_VL 12.2.2
APPS.ZX_DET_FACTOR_TEMPL_VL·↳ ZX_DET_FACTOR_TEMPL_B·↳ ZX_DET_FACTOR_TEMPL_TL·Explore FND module →
-
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_ACCOUNT_RATES_MIG_V 12.2.2
APPS.ZX_ACCOUNT_RATES_MIG_V·↳ ZX_ACCOUNT_RATES·Explore FND module →
-
View: ZX_REPORTING_TYPES_VL 12.1.1
APPS.ZX_REPORTING_TYPES_VL·↳ ZX_REPORTING_TYPES_B·↳ ZX_REPORTING_TYPES_TL·Explore FND module →
-
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_RULES_VL 12.1.1
APPS.ZX_RULES_VL·↳ ZX_RULES_B·↳ ZX_RULES_TL·Explore FND module →
-
View: ZX_SIM_RULE_RESULTS_V 12.2.2
APPS.ZX_SIM_RULE_RESULTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ ZX_CONDITION_GROUPS_VL·Explore FND module →
-
View: ZX_SIM_RULE_RESULTS_V 12.1.1
APPS.ZX_SIM_RULE_RESULTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ ZX_CONDITION_GROUPS_VL·Explore FND module →
-
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 →
-
View: ZX_REPORTING_TYPES_VL 12.2.2
APPS.ZX_REPORTING_TYPES_VL·↳ ZX_REPORTING_TYPES_B·↳ ZX_REPORTING_TYPES_TL·Explore FND module →
-
APPS.ZX_USER_PROC_LINE_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·Explore FND module →
-
View: ZX_SCO_RULES_B_V 12.2.2
-
View: ZX_SCO_RULES_B_V 12.1.1
-
APPS.ZX_USER_PROC_LINE_INPUT_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·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 →
-
View: ZX_MCO_EO_FORMULA_V 12.2.2
APPS.ZX_MCO_EO_FORMULA_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·Explore FND module →
-
View: ZX_ACCOUNT_RATES_MIG_V 12.1.1
APPS.ZX_ACCOUNT_RATES_MIG_V·↳ ZX_ACCOUNT_RATES·Explore FND module →
-
View: ZX_RATES_VL 12.1.1
APPS.ZX_RATES_VL·↳ ZX_RATES_B·↳ ZX_RATES_TL·Explore FND module →
-
View: ZX_RECOVERY_TYPES_VL 12.1.1
APPS.ZX_RECOVERY_TYPES_VL·↳ ZX_RECOVERY_TYPES_B·↳ ZX_RECOVERY_TYPES_TL·Explore FND module →
-
View: ZX_STATUS_VL 12.1.1
APPS.ZX_STATUS_VL·↳ ZX_STATUS_B·↳ ZX_STATUS_TL·Explore FND module →
-
View: ZX_STATUS_VL 12.2.2
APPS.ZX_STATUS_VL·↳ ZX_STATUS_B·↳ ZX_STATUS_TL·Explore FND module →
-
APPS.ZX_DETAIL_TAX_LINES_QUOTE_V·↳ ZX_DETAIL_TAX_LINES_GT·↳ ZX_LINES·↳ ZX_LINES_DET_FACTORS·Explore FND module →
-
APPS.ZX_DETAIL_TAX_LINES_QUOTE_V·↳ ZX_DETAIL_TAX_LINES_GT·↳ ZX_LINES·↳ ZX_LINES_DET_FACTORS·Explore FND module →
-
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 →
-
APPS.ZX_REC_NREC_DIST_QUOTE_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_REC_NREC_DIST·↳ ZX_REC_NREC_DIST_GT·Explore FND module →
-
View: ZX_SCO_STATUS_B_V 12.1.1
APPS.ZX_SCO_STATUS_B_V·↳ ZX_STATUS_B·↳ ZX_SUBSCRIPTION_DETAILS·Explore FND module →
-
View: ZX_SCO_STATUS_V 12.1.1
APPS.ZX_SCO_STATUS_V·↳ ZX_STATUS_B·↳ ZX_STATUS_TL·↳ ZX_SUBSCRIPTION_DETAILS·Explore FND module →
-
View: ZX_USR_PROC_NEG_LINE_V 12.1.1
APPS.ZX_USR_PROC_NEG_LINE_V·↳ ZX_PTNR_NEG_LINE_GT·↳ ZX_TRX_PRE_PROC_OPTIONS_GT·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_RECOVERY_TYPES_VL 12.2.2
APPS.ZX_RECOVERY_TYPES_VL·↳ ZX_RECOVERY_TYPES_B·↳ ZX_RECOVERY_TYPES_TL·Explore FND module →
-
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_JURISDICTIONS_VL 12.1.1
APPS.ZX_JURISDICTIONS_VL·↳ ZX_JURISDICTIONS_B·↳ ZX_JURISDICTIONS_TL·Explore FND module →
-
View: ZX_MCO_EO_RULES_V 12.1.1
APPS.ZX_MCO_EO_RULES_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ ZX_FIRST_PARTY_ORGS_MOAC_V·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 →
-
View: ZX_REGIMES_VL 12.2.2
APPS.ZX_REGIMES_VL·↳ ZX_REGIMES_B·↳ ZX_REGIMES_TL·Explore FND module →