Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ZX Tables and Views

TABLE - ZX.ZX_ACCOUNTS
TABLE - ZX.ZX_ACCOUNT_RATES
TABLE - ZX.ZX_ACCT_TX_CLS_DEFS_ALL
TABLE - ZX.ZX_API_CODE_COMBINATIONS
TABLE - ZX.ZX_API_OWNER_STATUSES
TABLE - ZX.ZX_API_REGISTRATIONS
TABLE - ZX.ZX_COMPOUND_ERRORS
TABLE - ZX.ZX_COMPOUND_ERRORS_T
TABLE - ZX.ZX_CONDITIONS
TABLE - ZX.ZX_CONDITION_GROUPS_B
TABLE - ZX.ZX_CONDITION_GROUPS_TL
TABLE - ZX.ZX_CONTENT_CHOICES_TMP
TABLE - ZX.ZX_CONTENT_SOURCES
TABLE - ZX.ZX_DATA_UPLOAD_INTERFACE
TABLE - ZX.ZX_DETAIL_TAX_LINES_GT
TABLE - ZX.ZX_DETERMINING_FACTORS_B
TABLE - ZX.ZX_DET_FACTORS_TL
TABLE - ZX.ZX_DET_FACTOR_TEMPL_B
TABLE - ZX.ZX_DET_FACTOR_TEMPL_DTL
TABLE - ZX.ZX_DET_FACTOR_TEMPL_TL
TABLE - ZX.ZX_ERRORS_GT
TABLE - ZX.ZX_EVENT_CLASSES_B
TABLE - ZX.ZX_EVENT_CLASSES_TL
TABLE - ZX.ZX_EVENT_CLASS_PARAMS
TABLE - ZX.ZX_EVNT_CLS_MAPPINGS
TABLE - ZX.ZX_EVNT_CLS_OPTIONS
TABLE - ZX.ZX_EVNT_CLS_TYPS
TABLE - ZX.ZX_EVNT_TYP_MAPPINGS
TABLE - ZX.ZX_EXCEPTIONS
TABLE - ZX.ZX_EXEMPTIONS
TABLE - ZX.ZX_FC_CODES_B
TABLE - ZX.ZX_FC_CODES_CATEG_ASSOC
TABLE - ZX.ZX_FC_CODES_DENORM_B
TABLE - ZX.ZX_FC_CODES_TL
TABLE - ZX.ZX_FC_COUNTRY_DEFAULTS
TABLE - ZX.ZX_FC_TYPES_B
TABLE - ZX.ZX_FC_TYPES_REG_ASSOC
TABLE - ZX.ZX_FC_TYPES_TL
TABLE - ZX.ZX_FORMULA_B
TABLE - ZX.ZX_FORMULA_DETAILS
TABLE - ZX.ZX_FORMULA_TL
TABLE - ZX.ZX_ID_TCC_MAPPING_ALL
TABLE - ZX.ZX_IMPORT_TAX_LINES_GT
TABLE - ZX.ZX_ITM_DISTRIBUTIONS_GT
TABLE - ZX.ZX_JURISDICTIONS_B
TABLE - ZX.ZX_JURISDICTIONS_GT
TABLE - ZX.ZX_JURISDICTIONS_TL
TABLE - ZX.ZX_LINES
TABLE - ZX.ZX_LINES_DET_FACTORS
TABLE - ZX.ZX_LINES_SUMMARY
TABLE - ZX.ZX_PARAMETERS_B
TABLE - ZX.ZX_PARAMETERS_TL
TABLE - ZX.ZX_PARAM_DETAILS
TABLE - ZX.ZX_PARTY_TAX_PROFILE
TABLE - ZX.ZX_PARTY_TYPES
TABLE - ZX.ZX_PO_REC_DIST
TABLE - ZX.ZX_PROCESS_RESULTS
TABLE - ZX.ZX_PRODUCT_OPTIONS_ALL
TABLE - ZX.ZX_PRVDR_HDR_EXTNS_GT
TABLE - ZX.ZX_PRVDR_LINE_EXTNS_GT
TABLE - ZX.ZX_PTNR_LOCATION_INFO_GT
TABLE - ZX.ZX_PTNR_NEG_LINE_GT
TABLE - ZX.ZX_PTNR_NEG_TAX_LINE_GT
TABLE - ZX.ZX_PURGE_TRANSACTIONS_GT
TABLE - ZX.ZX_RATES_B
TABLE - ZX.ZX_RATES_TL
TABLE - ZX.ZX_RECOVERY_TYPES_B
TABLE - ZX.ZX_RECOVERY_TYPES_TL
TABLE - ZX.ZX_REC_NREC_DIST
TABLE - ZX.ZX_REC_NREC_DIST_GT
TABLE - ZX.ZX_REGIMES_B
TABLE - ZX.ZX_REGIMES_TL
TABLE - ZX.ZX_REGIMES_USAGES
TABLE - ZX.ZX_REGIME_RELATIONS
TABLE - ZX.ZX_REGISTRATIONS
TABLE - ZX.ZX_REPORTING_CODES_B
TABLE - ZX.ZX_REPORTING_CODES_TL
TABLE - ZX.ZX_REPORTING_TYPES_B
TABLE - ZX.ZX_REPORTING_TYPES_TL
TABLE - ZX.ZX_REPORT_CODES_ASSOC
TABLE - ZX.ZX_REPORT_TYPES_USAGES
TABLE - ZX.ZX_REP_ACTG_EXT_T
TABLE - ZX.ZX_REP_CONTEXT_T
TABLE - ZX.ZX_REP_MATRIX_EXT_T
TABLE - ZX.ZX_REP_TRX_DETAIL_T
TABLE - ZX.ZX_REP_TRX_JX_EXT_T
TABLE - ZX.ZX_REVERSE_DIST_GT
TABLE - ZX.ZX_REVERSE_TRX_LINES_GT
TABLE - ZX.ZX_RULES_B
TABLE - ZX.ZX_RULES_TL
TABLE - ZX.ZX_SERVICE_TYPES
TABLE - ZX.ZX_SIM_CONDITIONS
TABLE - ZX.ZX_SIM_PROCESS_RESULTS
TABLE - ZX.ZX_SIM_PURGE
TABLE - ZX.ZX_SIM_RULES_B
TABLE - ZX.ZX_SIM_RULES_TL
TABLE - ZX.ZX_SIM_RULE_CONDITIONS
TABLE - ZX.ZX_SIM_TRX_DISTS
TABLE - ZX.ZX_SRVC_SBSCRPTN_EXCLS
TABLE - ZX.ZX_SRVC_SUBSCRIPTIONS
TABLE - ZX.ZX_SRVC_TYP_PARAMS
TABLE - ZX.ZX_STATUS_B
TABLE - ZX.ZX_STATUS_TL
TABLE - ZX.ZX_SUBSCRIPTION_DETAILS
TABLE - ZX.ZX_SUBSCRIPTION_OPTIONS
TABLE - ZX.ZX_TAXES_B
TABLE - ZX.ZX_TAXES_TL
TABLE - ZX.ZX_TAX_PRIORITIES_T
TABLE - ZX.ZX_TAX_RELATIONS_T
TABLE - ZX.ZX_TRANSACTION
TABLE - ZX.ZX_TRANSACTION_LINES
TABLE - ZX.ZX_TRANSACTION_LINES_GT
TABLE - ZX.ZX_TRX_HEADERS_GT
TABLE - ZX.ZX_TRX_LINE_APP_REGIMES
TABLE - ZX.ZX_TRX_PRE_PROC_OPTIONS_GT
TABLE - ZX.ZX_TRX_TAX_LINK_GT
TABLE - ZX.ZX_UPDATE_CRITERIA_RESULTS
TABLE - ZX.ZX_VALIDATION_ERRORS_GT
VIEW - APPS.ZX_ACCOUNT_RATES_NEW_V
VIEW - APPS.ZX_P2P_CALC_TXN_INPUT_V

Table: ZX_ACCOUNTS

Description: This table contains default tax accounts for jurisdictions and rates. Each record represents default tax accounts defined by the internal organization for a jurisdiction or a rate.
Primary Key: ZX_ACCOUNTS_PK
  1. TAX_ACCOUNT_ENTITY_CODE
  2. TAX_ACCOUNT_ENTITY_ID
  3. LEDGER_ID
  4. INTERNAL_ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_ACCOUNTS.EDISC_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.UNEDISC_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.FINCHRG_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.ADJ_NON_REC_TAX_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.EDISC_NON_REC_TAX_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.UNEDISC_NON_REC_TAX_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.FINCHRG_NON_REC_TAX_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.FINCHRG_NON_REC_TAX_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.LEDGER_ID %
ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
ZX_ACCOUNTS.TAX_ACCOUNT_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.INTERIM_TAX_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.NON_REC_ACCOUNT_CCID GL_CODE_COMBINATIONS
ZX_ACCOUNTS.ADJ_CCID GL_CODE_COMBINATIONS

[top of page]

ZX.ZX_ACCOUNTS does not reference any database object

ZX.ZX_ACCOUNTS is referenced by following:

APPS
SYNONYM - ZX_ACCOUNTS

[top of page]

Table: ZX_ACCOUNT_RATES

Description: 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.
Primary Key: ZX_ACCOUNT_RATES_PK
  1. LEDGER_ID
  2. CONTENT_OWNER_ID
  3. ACCOUNT_SEGMENT_VALUE
  4. TAX_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_ACCOUNT_RATES.LEDGER_ID %
ZX_ACCOUNT_RATES.TAX_CURRENCY_CODE FND_CURRENCIES

[top of page]

ZX.ZX_ACCOUNT_RATES does not reference any database object

ZX.ZX_ACCOUNT_RATES is referenced by following:

APPS
SYNONYM - ZX_ACCOUNT_RATES
SYNONYM - ZX_ACCOUNT_RATES_TMP
SYNONYM - ZX_MCO_ACCOUNT_RATES
SYNONYM - ZX_SCO_ACCOUNT_RATES

[top of page]

Table: ZX_ACCT_TX_CLS_DEFS_ALL

Description: This table contains tax classification code defaults for account segment values. Each record represents a default tax classification code defined by the internal organization for an account segment value.
Primary Key: ZX_ACCT_TX_CLS_DEFS_ALL_PK
  1. LEDGER_ID
  2. ORG_ID
  3. ACCOUNT_SEGMENT_VALUE
  4. TAX_CLASS
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_ACCT_TX_CLS_DEFS_ALL.LEDGER_ID %
ZX_ACCT_TX_CLS_DEFS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

ZX.ZX_ACCT_TX_CLS_DEFS_ALL does not reference any database object

ZX.ZX_ACCT_TX_CLS_DEFS_ALL is referenced by following:

APPS
SYNONYM - ZX_ACCT_TX_CLS_DEFS
SYNONYM - ZX_ACCT_TX_CLS_DEFS_ALL

[top of page]

Table: ZX_API_CODE_COMBINATIONS

Description: This table stores valid context combinations for each Context Key Flexfiled structure, using which third party or custom APIs can be registered in Oracle E-Business Tax.
Primary Key: ZX_API_CODE_COMBINATIONS_PK
  1. CODE_COMBINATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_API_REGISTRATIONS.CONTEXT_CCID ZX_API_CODE_COMBINATIONS

[top of page]

ZX.ZX_API_CODE_COMBINATIONS does not reference any database object

ZX.ZX_API_CODE_COMBINATIONS is referenced by following:

APPS
SYNONYM - ZX_API_CODE_COMBINATIONS

[top of page]

Table: ZX_API_OWNER_STATUSES

Description: This table stores the status of APIs registration for an API owner. Each record represents the status of APIs registration of a API owner for a service category.
Primary Key: ZX_API_OWNER_STATUSES_PK
  1. API_OWNER_ID
  2. SERVICE_CATEGORY_CODE

[top of page]

ZX.ZX_API_OWNER_STATUSES does not reference any database object

ZX.ZX_API_OWNER_STATUSES is referenced by following:

APPS
SYNONYM - ZX_API_OWNER_STATUSES

[top of page]

Table: ZX_API_REGISTRATIONS

Description: This table stores the registration of a set of APIs required to support third party tax service providers. Each record represents registration of one API for a third party service provider or a first party organization.
Primary Key: ZX_API_REGISTRATIONS_PK
  1. API_REGISTRATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_API_REGISTRATIONS.API_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_API_REGISTRATIONS.SERVICE_TYPE_ID ZX_SERVICE_TYPES
ZX_API_REGISTRATIONS.CONTEXT_CCID ZX_API_CODE_COMBINATIONS

[top of page]

ZX.ZX_API_REGISTRATIONS does not reference any database object

ZX.ZX_API_REGISTRATIONS is referenced by following:

APPS
SYNONYM - ZX_API_REGISTRATIONS

[top of page]

Table: ZX_COMPOUND_ERRORS

Description: This table stores errors found during tax groups migration from ZX_TAX_PRIORITIES_T.

[top of page]

ZX.ZX_COMPOUND_ERRORS does not reference any database object

ZX.ZX_COMPOUND_ERRORS is referenced by following:

APPS
SYNONYM - ZX_COMPOUND_ERRORS

[top of page]

Table: ZX_COMPOUND_ERRORS_T

Description:

[top of page]

ZX.ZX_COMPOUND_ERRORS_T does not reference any database object

ZX.ZX_COMPOUND_ERRORS_T is referenced by following:

APPS
SYNONYM - ZX_COMPOUND_ERRORS_T

[top of page]

Table: ZX_CONDITIONS

Description: This table stores a set of conditions for each condition group defined in ZX_CONDITION_GROUPS_B. Each record represents one condition in the condition group.
Primary Key: ZX_CONDITIONS_PK
  1. CONDITION_GROUP_CODE
  2. DETERMINING_FACTOR_CODE
  3. DETERMINING_FACTOR_CLASS_CODE
  4. DETERMINING_FACTOR_CQ_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_CONDITIONS.CONDITION_GROUP_CODE ZX_CONDITION_GROUPS_B

[top of page]

ZX.ZX_CONDITIONS does not reference any database object

ZX.ZX_CONDITIONS is referenced by following:

APPS
SYNONYM - ZX_CONDITIONS

[top of page]

Table: ZX_CONDITION_GROUPS_B

Description: This table associates the multiple conditions defined in Conditions to a Result.
Primary Key: ZX_CONDITION_GROUPS_B_PK
  1. CONDITION_GROUP_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_CONDITION_GROUPS_B.COUNTRY_CODE FND_TERRITORIES
ZX_CONDITION_GROUPS_B.LEDGER_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_CONDITIONS.CONDITION_GROUP_CODE ZX_CONDITION_GROUPS_B
ZX_PROCESS_RESULTS.CONDITION_GROUP_CODE ZX_CONDITION_GROUPS_B

[top of page]

ZX.ZX_CONDITION_GROUPS_B does not reference any database object

ZX.ZX_CONDITION_GROUPS_B is referenced by following:

APPS
SYNONYM - ZX_CONDITION_GROUPS_B

[top of page]

Table: ZX_CONDITION_GROUPS_TL

Description: This table provides multilingual support (MLS) for each tax condition group. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_CONDITION_GROUPS_TL_PK
  1. CONDITION_GROUP_ID
  2. LANGUAGE

[top of page]

ZX.ZX_CONDITION_GROUPS_TL does not reference any database object

ZX.ZX_CONDITION_GROUPS_TL is referenced by following:

APPS
SYNONYM - ZX_CONDITION_GROUPS_TL

[top of page]

Table: ZX_CONTENT_CHOICES_TMP

Description: This table is for future use.

[top of page]

ZX.ZX_CONTENT_CHOICES_TMP does not reference any database object

ZX.ZX_CONTENT_CHOICES_TMP is referenced by following:

APPS
SYNONYM - ZX_CONTENT_CHOICES_TMP

[top of page]

Table: ZX_CONTENT_SOURCES

Description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime.
Primary Key: ZX_CONTENT_SOURCES_PK
  1. PROVIDER_ID
  2. STANDARD_REGIME_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_CONTENT_SOURCES.PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_CONTENT_SOURCES.PROVIDER_REGIME_CODE ZX_REGIMES_B
ZX_CONTENT_SOURCES.STANDARD_REGIME_CODE ZX_REGIMES_B

[top of page]

ZX.ZX_CONTENT_SOURCES does not reference any database object

ZX.ZX_CONTENT_SOURCES is referenced by following:

APPS
SYNONYM - ZX_CONTENT_SOURCES

[top of page]

Table: ZX_DATA_UPLOAD_INTERFACE

Description: This is an intermediate table used by data upload program to hold the content from third party content provider temporarily.

[top of page]

ZX.ZX_DATA_UPLOAD_INTERFACE does not reference any database object

ZX.ZX_DATA_UPLOAD_INTERFACE is referenced by following:

APPS
SYNONYM - ZX_DATA_UPLOAD_INTERFACE

[top of page]

Table: ZX_DETAIL_TAX_LINES_GT

Description: This global temporary table is used to cache tax lines during tax processing for transactions.

[top of page]

ZX.ZX_DETAIL_TAX_LINES_GT does not reference any database object

ZX.ZX_DETAIL_TAX_LINES_GT is referenced by following:

APPS
SYNONYM - ZX_DETAIL_TAX_LINES_GT

[top of page]

Table: ZX_DETERMINING_FACTORS_B

Description: This table stores the determining factors used to define conditions for tax rules. Each record represents one determining factor.
Primary Key: ZX_DETERMINING_FACTORS_PK
  1. DETERMINING_FACTOR_CLASS_CODE
  2. DETERMINING_FACTOR_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_DETERMINING_FACTORS_B.VALUE_SET FND_FLEX_VALUE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_DET_FACTOR_TEMPL_DTL.DETERMINING_FACTOR_CLASS_CODE
ZX_DET_FACTOR_TEMPL_DTL.DETERMINING_FACTOR_CODE 		ZX_DETERMINING_FACTORS_B

[top of page]

ZX.ZX_DETERMINING_FACTORS_B does not reference any database object

ZX.ZX_DETERMINING_FACTORS_B is referenced by following:

APPS
SYNONYM - ZX_DETERMINING_FACTORS_B

[top of page]

Table: ZX_DET_FACTORS_TL

Description: This table provides multilingual support (MLS) for each determining factor. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_DET_FACTORS_TL_PK
  1. DETERMINING_FACTOR_ID
  2. LANGUAGE

[top of page]

ZX.ZX_DET_FACTORS_TL does not reference any database object

ZX.ZX_DET_FACTORS_TL is referenced by following:

APPS
SYNONYM - ZX_DET_FACTORS_TL

[top of page]

Table: ZX_DET_FACTOR_TEMPL_B

Description: This table stores templates for usage of determining factors. Each record represents one determining factor template.
Primary Key: ZX_DET_FACTOR_TEMPL_B_PK
  1. DET_FACTOR_TEMPL_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_DET_FACTOR_TEMPL_B.LEDGER_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_EVNT_CLS_MAPPINGS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_EVNT_CLS_OPTIONS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_EXCEPTIONS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_EXEMPTIONS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_REGIMES_B.THRSHLD_CHK_TMPLT_CODE ZX_DET_FACTOR_TEMPL_B
ZX_RULES_B.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_TAXES_B.THRSHLD_CHK_TMPLT_CODE ZX_DET_FACTOR_TEMPL_B

[top of page]

ZX.ZX_DET_FACTOR_TEMPL_B does not reference any database object

ZX.ZX_DET_FACTOR_TEMPL_B is referenced by following:

APPS
SYNONYM - ZX_DET_FACTOR_TEMPL_B

[top of page]

Table: ZX_DET_FACTOR_TEMPL_DTL

Description: This table stores a set of determining factors for each determining factor template defined in ZX_DET_FACTOR_TEMPL_B. Each record represents one determining factor in the determining factor template.
Primary Key: ZX_DET_FACTOR_TEMPL_DTL_PK
  1. DET_FACTOR_TEMPL_ID
  2. DETERMINING_FACTOR_CLASS_CODE
  3. DETERMINING_FACTOR_CQ_CODE
  4. DETERMINING_FACTOR_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_DET_FACTOR_TEMPL_DTL.DETERMINING_FACTOR_CLASS_CODE
ZX_DET_FACTOR_TEMPL_DTL.DETERMINING_FACTOR_CODE 		ZX_DETERMINING_FACTORS_B

[top of page]

ZX.ZX_DET_FACTOR_TEMPL_DTL does not reference any database object

ZX.ZX_DET_FACTOR_TEMPL_DTL is referenced by following:

APPS
SYNONYM - ZX_DET_FACTOR_TEMPL_DTL

[top of page]

Table: ZX_DET_FACTOR_TEMPL_TL

Description: This table provides multilingual support (MLS) for each determining factor template. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_DET_FACTOR_TEMPL_TL_PK
  1. DET_FACTOR_TEMPL_ID
  2. LANGUAGE

[top of page]

ZX.ZX_DET_FACTOR_TEMPL_TL does not reference any database object

ZX.ZX_DET_FACTOR_TEMPL_TL is referenced by following:

APPS
SYNONYM - ZX_DET_FACTOR_TEMPL_TL

[top of page]

Table: ZX_ERRORS_GT

Description: This global temporary table is used to return errors encountered during tax processing for transactions.

[top of page]

ZX.ZX_ERRORS_GT does not reference any database object

ZX.ZX_ERRORS_GT is referenced by following:

APPS
SYNONYM - ZX_ERRORS_GT

[top of page]

Table: ZX_EVENT_CLASSES_B

Description: This table stores tax event classes. This table contains seeded data only.
Primary Key: ZX_EVENT_CLASSES_B_PK
  1. TAX_EVENT_CLASS_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_EVENT_CLASSES_TL.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_EVNT_CLS_MAPPINGS.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_EVNT_CLS_MAPPINGS.INTRCMP_TX_EVNT_CLS_CODE ZX_EVENT_CLASSES_B
ZX_EVNT_CLS_TYPS.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_LINES_DET_FACTORS.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_LINES.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_REC_NREC_DIST.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_RULES_B.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B

[top of page]

ZX.ZX_EVENT_CLASSES_B does not reference any database object

ZX.ZX_EVENT_CLASSES_B is referenced by following:

APPS
SYNONYM - ZX_EVENT_CLASSES_B

[top of page]

Table: ZX_EVENT_CLASSES_TL

Description: This table provides multilingual support (MLS) for each tax event class. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_EVENT_CLASSES_TL_PK
  1. TAX_EVENT_CLASS_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EVENT_CLASSES_TL.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B

[top of page]

ZX.ZX_EVENT_CLASSES_TL does not reference any database object

ZX.ZX_EVENT_CLASSES_TL is referenced by following:

APPS
SYNONYM - ZX_EVENT_CLASSES_TL

[top of page]

Table: ZX_EVENT_CLASS_PARAMS

Description: This table stores the list of parameters not passed by applications, which is used to skip conditions during rules processing. Each row denotes a tax parameter not passed for an application event class. This table contains seed data only.
Primary Key: ZX_EVENT_CLASS_PARAMS_PK
  1. EVENT_CLASS_MAPPING_ID
  2. TAX_PARAMETER_CODE

[top of page]

ZX.ZX_EVENT_CLASS_PARAMS does not reference any database object

ZX.ZX_EVENT_CLASS_PARAMS is referenced by following:

APPS
SYNONYM - ZX_EVENT_CLASS_PARAMS

[top of page]

Table: ZX_EVNT_CLS_MAPPINGS

Description: ZX_EVNT_CLS_MAPPINGS stores mappings of tax event classes to event classes of Oracle Applications.
Primary Key: ZX_EVNT_CLS_MAPPINGS_PK
  1. EVENT_CLASS_MAPPING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EVNT_CLS_MAPPINGS.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_EVNT_CLS_MAPPINGS.INTRCMP_TX_EVNT_CLS_CODE ZX_EVENT_CLASSES_B
ZX_EVNT_CLS_MAPPINGS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_EVNT_CLS_MAPPINGS.REFERENCE_APPLICATION_ID FND_APPLICATION
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_EVNT_TYP_MAPPINGS.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS
ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS
ZX_PRODUCT_OPTIONS_ALL.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS
ZX_RULES_B.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS

[top of page]

ZX.ZX_EVNT_CLS_MAPPINGS does not reference any database object

ZX.ZX_EVNT_CLS_MAPPINGS is referenced by following:

APPS
SYNONYM - ZX_EVNT_CLS_MAPPINGS

[top of page]

Table: ZX_EVNT_CLS_OPTIONS

Description: This table stores tax options for application event classes. Each row contains tax options defined by a first party organization for an application event class.
Primary Key: ZX_EVNT_CLS_OPTIONS_PK
  1. APPLICATION_ID
  2. ENTITY_CODE
  3. EVENT_CLASS_CODE
  4. FIRST_PTY_ORG_ID
  5. EFFECTIVE_FROM
  6. ENABLED_FLAG
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EVNT_CLS_OPTIONS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B

[top of page]

ZX.ZX_EVNT_CLS_OPTIONS does not reference any database object

ZX.ZX_EVNT_CLS_OPTIONS is referenced by following:

APPS
SYNONYM - ZX_EVNT_CLS_OPTIONS

[top of page]

Table: ZX_EVNT_CLS_TYPS

Description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only.
Primary Key: ZX_EVNT_CLS_TYPS_PK
  1. TAX_EVENT_CLASS_CODE
  2. TAX_EVENT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EVNT_CLS_TYPS.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_EVNT_TYP_MAPPINGS.TAX_EVENT_CLASS_CODE
ZX_EVNT_TYP_MAPPINGS.TAX_EVENT_TYPE_CODE 		ZX_EVNT_CLS_TYPS
ZX_LINES_DET_FACTORS.TAX_EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS.TAX_EVENT_TYPE_CODE 		ZX_EVNT_CLS_TYPS
ZX_LINES.TAX_EVENT_CLASS_CODE
ZX_LINES.TAX_EVENT_TYPE_CODE 		ZX_EVNT_CLS_TYPS

[top of page]

ZX.ZX_EVNT_CLS_TYPS does not reference any database object

ZX.ZX_EVNT_CLS_TYPS is referenced by following:

APPS
SYNONYM - ZX_EVNT_CLS_TYPS

[top of page]

Table: ZX_EVNT_TYP_MAPPINGS

Description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only.
Primary Key: ZX_EVNT_TYP_MAPPINGS_PK
  1. APPLICATION_ID
  2. ENTITY_CODE
  3. EVENT_CLASS_CODE
  4. EVENT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EVNT_TYP_MAPPINGS.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS
ZX_EVNT_TYP_MAPPINGS.TAX_EVENT_CLASS_CODE
ZX_EVNT_TYP_MAPPINGS.TAX_EVENT_TYPE_CODE 		ZX_EVNT_CLS_TYPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES_DET_FACTORS.APPLICATION_ID
ZX_LINES_DET_FACTORS.ENTITY_CODE
ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS.EVENT_TYPE_CODE 		ZX_EVNT_TYP_MAPPINGS
ZX_LINES.APPLICATION_ID
ZX_LINES.ENTITY_CODE
ZX_LINES.EVENT_CLASS_CODE
ZX_LINES.EVENT_TYPE_CODE 		ZX_EVNT_TYP_MAPPINGS
ZX_REC_NREC_DIST.APPLICATION_ID ZX_EVNT_TYP_MAPPINGS

[top of page]

ZX.ZX_EVNT_TYP_MAPPINGS does not reference any database object

ZX.ZX_EVNT_TYP_MAPPINGS is referenced by following:

APPS
SYNONYM - ZX_EVNT_TYP_MAPPINGS

[top of page]

Table: ZX_EXCEPTIONS

Description: This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to be treated as an exception for an item or a product fiscal classification during tax calculation.
Primary Key: ZX_EXCEPTIONS_PK
  1. TAX_EXCEPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EXCEPTIONS.PRODUCT_ID MTL_SYSTEM_ITEMS_B
ZX_EXCEPTIONS.INVENTORY_ORG_ID HR_ALL_ORGANIZATION_UNITS
ZX_EXCEPTIONS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_EXCEPTION_ID ZX_EXCEPTIONS
ZX_LINES_SUMMARY.TAX_EXCEPTION_ID ZX_EXCEPTIONS

[top of page]

ZX.ZX_EXCEPTIONS does not reference any database object

ZX.ZX_EXCEPTIONS is referenced by following:

APPS
SYNONYM - ZX_EXCEPTIONS
SYNONYM - ZX_EXCEPTIONS_TMP
SYNONYM - ZX_MCO_EXCEPTIONS
SYNONYM - ZX_SCO_EXCEPTIONS

[top of page]

Table: ZX_EXEMPTIONS

Description: 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.
Primary Key: ZX_EXEMPTIONS_PK
  1. TAX_EXEMPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_EXEMPTIONS.PRODUCT_ID MTL_SYSTEM_ITEMS_B
ZX_EXEMPTIONS.INVENTORY_ORG_ID HR_ALL_ORGANIZATION_UNITS
ZX_EXEMPTIONS.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_EXEMPTION_ID ZX_EXEMPTIONS
ZX_LINES_SUMMARY.TAX_EXEMPTION_ID ZX_EXEMPTIONS

[top of page]

ZX.ZX_EXEMPTIONS does not reference any database object

ZX.ZX_EXEMPTIONS is referenced by following:

APPS
SYNONYM - ZX_EXEMPTIONS
SYNONYM - ZX_EXEMPTIONS_TMP
SYNONYM - ZX_MCO_EXEMPTIONS
SYNONYM - ZX_SCO_EXEMPTIONS

[top of page]

Table: ZX_FC_CODES_B

Description: This table stores fiscal classification code hierarchies for types of Document Sub Type, Intended Use, User Defined Fiscal Classification, Product Category, Transaction Business Category and Transaction Fiscal Classification categories.
Primary Key: ZX_FC_CODES_B_PK
  1. CLASSIFICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FC_CODES_B.PARENT_CLASSIFICATION_ID ZX_FC_CODES_B
ZX_FC_CODES_B.COUNTRY_CODE FND_TERRITORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_FC_CODES_B.PARENT_CLASSIFICATION_ID ZX_FC_CODES_B
ZX_FC_CODES_DENORM_B.CLASSIFICATION_ID ZX_FC_CODES_B
ZX_FC_CODES_TL.CLASSIFICATION_ID ZX_FC_CODES_B

[top of page]

ZX.ZX_FC_CODES_B does not reference any database object

ZX.ZX_FC_CODES_B is referenced by following:

APPS
SYNONYM - ZX_FC_CODES_B

[top of page]

Table: ZX_FC_CODES_CATEG_ASSOC

Description: This table stores the association of the classification codes of transaction fiscal classification category with the classification codes of transaction business category.
Primary Key: ZX_FC_CODES_CATEG_ASSOC_PK
  1. TRANS_BUSINESS_CATEG_TYPE_CODE
  2. TRANS_BUSINESS_CATEG_CONCAT
  3. CLASSIFICATION_TYPE_CODE
  4. CLASSIFICATION_CODE_CONCAT

[top of page]

ZX.ZX_FC_CODES_CATEG_ASSOC does not reference any database object

ZX.ZX_FC_CODES_CATEG_ASSOC is referenced by following:

APPS
SYNONYM - ZX_FC_CODES_CATEG_ASSOC

[top of page]

Table: ZX_FC_CODES_DENORM_B

Description: This table stores relations data for fiscal classification code hierarchies in denormalized form. There is one row for each classification code that is present in the hierarchy.
Primary Key: ZX_FC_CODES_DENORM_B_PK
  1. CLASSIFICATION_TYPE_CODE
  2. LANGUAGE
  3. CLASSIFICATION_CODE
  4. ANCESTOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FC_CODES_DENORM_B.CLASSIFICATION_ID ZX_FC_CODES_B
ZX_FC_CODES_DENORM_B.COUNTRY_CODE FND_TERRITORIES
ZX_FC_CODES_DENORM_B.LANGUAGE FND_LANGUAGES

[top of page]

ZX.ZX_FC_CODES_DENORM_B does not reference any database object

ZX.ZX_FC_CODES_DENORM_B is referenced by following:

APPS
SYNONYM - ZX_FC_CODES_DENORM_B

[top of page]

Table: ZX_FC_CODES_TL

Description: This table provides multilingual support (MLS) for each fiscal classification code. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_FC_CODES_TL_PK
  1. CLASSIFICATION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FC_CODES_TL.CLASSIFICATION_ID ZX_FC_CODES_B

[top of page]

ZX.ZX_FC_CODES_TL does not reference any database object

ZX.ZX_FC_CODES_TL is referenced by following:

APPS
SYNONYM - ZX_FC_CODES_TL

[top of page]

Table: ZX_FC_COUNTRY_DEFAULTS

Description: This table stores tax defaults and controls for multiple countries. Each record contains tax defaults and controls for a specific country.
Primary Key: ZX_FC_COUNTRY_DEFAULTS_PK
  1. COUNTRY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FC_COUNTRY_DEFAULTS.COUNTRY_CODE FND_TERRITORIES

[top of page]

ZX.ZX_FC_COUNTRY_DEFAULTS does not reference any database object

ZX.ZX_FC_COUNTRY_DEFAULTS is referenced by following:

APPS
SYNONYM - ZX_FC_COUNTRY_DEFAULTS

[top of page]

Table: ZX_FC_TYPES_B

Description: This table stores the fiscal classification types defined for all classification categories. Each row records a fiscal classification type for a specific classification category.
Primary Key: ZX_FC_TYPES_B_PK
  1. CLASSIFICATION_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FC_TYPES_B.OWNER_ID_NUM MTL_CATEGORY_SETS_B
ZX_FC_TYPES_B.OWNER_ID_CHAR ZX_FC_TYPES_B
ZX_FC_TYPES_B.OWNER_ID_CHAR HZ_CLASS_CATEGORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_FC_TYPES_B.OWNER_ID_CHAR ZX_FC_TYPES_B
ZX_FC_TYPES_REG_ASSOC.CLASSIFICATION_TYPE_CODE ZX_FC_TYPES_B

[top of page]

ZX.ZX_FC_TYPES_B does not reference any database object

ZX.ZX_FC_TYPES_B is referenced by following:

APPS
SYNONYM - ZX_FC_TYPES_B

[top of page]

Table: ZX_FC_TYPES_REG_ASSOC

Description: This table stores association of fiscal classification types to multiple tax regimes. Each row stores an association of a specific fiscal classificaiton type to a tax regime.
Primary Key: ZX_FC_TYPES_REG_ASSOC_PK
  1. CLASSIFICATION_TYPE_CODE
  2. TAX_REGIME_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FC_TYPES_REG_ASSOC.CLASSIFICATION_TYPE_CODE ZX_FC_TYPES_B

[top of page]

ZX.ZX_FC_TYPES_REG_ASSOC does not reference any database object

ZX.ZX_FC_TYPES_REG_ASSOC is referenced by following:

APPS
SYNONYM - ZX_FC_TYPES_REG_ASSOC

[top of page]

Table: ZX_FC_TYPES_TL

Description: This table provides multilingual support (MLS) for each fiscal classification type. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_FC_TYPES_TL_PK
  1. CLASSIFICATION_TYPE_ID
  2. LANGUAGE

[top of page]

ZX.ZX_FC_TYPES_TL does not reference any database object

ZX.ZX_FC_TYPES_TL is referenced by following:

APPS
SYNONYM - ZX_FC_TYPES_TL

[top of page]

Table: ZX_FORMULA_B

Description: This table stores formulas that will be used to calculate taxable basis and tax amounts. Each row stores a formula to determine taxable basis or tax amount for a specific tax.
Primary Key: ZX_FORMULA_B_PK
  1. FORMULA_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_FORMULA_DETAILS.FORMULA_ID ZX_FORMULA_B
ZX_FORMULA_TL.FORMULA_ID ZX_FORMULA_B

[top of page]

ZX.ZX_FORMULA_B does not reference any database object

ZX.ZX_FORMULA_B is referenced by following:

APPS
SYNONYM - ZX_FORMULA_B
SYNONYM - ZX_FORMULA_B_TMP

[top of page]

Table: ZX_FORMULA_DETAILS

Description: For Taxable Basis formulas, this table stores compounding taxes or taxes for which the current tax is a surcharge. For Tax Calculation formulas, it stores taxes whose tax amounts must be added to/subtracted from the calculated tax amount.
Primary Key: ZX_FORMULA_DETAILS_PK
  1. FORMULA_ID
  2. COMPOUNDING_TAX_REGIME_CODE
  3. COMPOUNDING_TAX
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FORMULA_DETAILS.FORMULA_ID ZX_FORMULA_B
ZX_FORMULA_DETAILS.COMPOUNDING_TAX_REGIME_CODE ZX_REGIMES_B

[top of page]

ZX.ZX_FORMULA_DETAILS does not reference any database object

ZX.ZX_FORMULA_DETAILS is referenced by following:

APPS
SYNONYM - ZX_FORMULA_DETAILS

[top of page]

Table: ZX_FORMULA_TL

Description: This table provides multilingual support (MLS) for each tax formula. MLS enables you to store and print data that you define in
Primary Key: ZX_FORMULA_TL_PK
  1. FORMULA_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_FORMULA_TL.FORMULA_ID ZX_FORMULA_B

[top of page]

ZX.ZX_FORMULA_TL does not reference any database object

ZX.ZX_FORMULA_TL is referenced by following:

APPS
SYNONYM - ZX_FORMULA_TL

[top of page]

Table: ZX_ID_TCC_MAPPING_ALL

Description: This table stores the list of tax classification codes applicable for an internal organization. This table also stores the mapping of migrated tax classiifcaiton codes to the tax code identifiers of AP and AR in prior releases.
Primary Key: ZX_ID_TCC_MAPPING_ALL_PK
  1. SOURCE
  2. TAX_RATE_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_ID_TCC_MAPPING_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS
ZX_ID_TCC_MAPPING_ALL.TAX_RATE_CODE_ID AP_TAX_CODES_ALL
ZX_ID_TCC_MAPPING_ALL.TAX_RATE_CODE_ID AR_VAT_TAX_ALL_B
ZX_ID_TCC_MAPPING_ALL.LEDGER_ID %

[top of page]

ZX.ZX_ID_TCC_MAPPING_ALL does not reference any database object

ZX.ZX_ID_TCC_MAPPING_ALL is referenced by following:

APPS
SYNONYM - ZX_ID_TCC_MAPPING
SYNONYM - ZX_ID_TCC_MAPPING_ALL

[top of page]

Table: ZX_IMPORT_TAX_LINES_GT

Description: This global temporary table is used to pass summary or detail tax lines when importing documents with tax.

[top of page]

ZX.ZX_IMPORT_TAX_LINES_GT does not reference any database object

ZX.ZX_IMPORT_TAX_LINES_GT is referenced by following:

APPS
SYNONYM - ZX_IMPORT_TAX_LINES_GT

[top of page]

Table: ZX_ITM_DISTRIBUTIONS_GT

Description: This global temporary table is used to pass document item distributions for calculating recoverable and/or non-recoverable tax distributions for a document.

[top of page]

ZX.ZX_ITM_DISTRIBUTIONS_GT does not reference any database object

ZX.ZX_ITM_DISTRIBUTIONS_GT is referenced by following:

APPS
SYNONYM - ZX_ITM_DISTRIBUTIONS_GT

[top of page]

Table: ZX_JURISDICTIONS_B

Description: This table stores the Tax Jurisdictions for a Tax.
Primary Key: ZX_JURISDICTIONS_B_PK1
  1. TAX_REGIME_CODE
  2. TAX
  3. TAX_JURISDICTION_CODE

[top of page]

ZX.ZX_JURISDICTIONS_B does not reference any database object

ZX.ZX_JURISDICTIONS_B is referenced by following:

APPS
SYNONYM - ZX_JURISDICTIONS_B

[top of page]

Table: ZX_JURISDICTIONS_GT

Description: This global temporary table is used to cache tax jurisdictions during tax processing for transactions when there are multiple jurisdictions found for the same address element on the transaction.

[top of page]

ZX.ZX_JURISDICTIONS_GT does not reference any database object

ZX.ZX_JURISDICTIONS_GT is referenced by following:

APPS
SYNONYM - ZX_JURISDICTIONS_GT

[top of page]

Table: ZX_JURISDICTIONS_TL

Description: This table provides multilingual support (MLS) for each tax jurisdiction. MLS enables you to store and print data that you define in
Primary Key: ZX_JURISDICTIONS_TL_PK
  1. TAX_JURISDICTION_ID
  2. LANGUAGE

[top of page]

ZX.ZX_JURISDICTIONS_TL does not reference any database object

ZX.ZX_JURISDICTIONS_TL is referenced by following:

APPS
SYNONYM - ZX_JURISDICTIONS_TL

[top of page]

Table: ZX_LINES

Description: This table stores detail tax lines for transactions of multiple event classes.
Primary Key: ZX_LINES_PK
  1. TAX_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_EXCEPTION_ID ZX_EXCEPTIONS
ZX_LINES.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.TAX_REGIME_CODE ZX_REGIMES_B
ZX_LINES.TAX_ID ZX_TAXES_B
ZX_LINES.TAX_STATUS_ID ZX_STATUS_B
ZX_LINES.TAX_RATE_ID ZX_RATES_B
ZX_LINES.LEDGER_ID %
ZX_LINES.HQ_ESTB_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.TRX_CURRENCY_CODE FND_CURRENCIES
ZX_LINES.CALC_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.REF_DOC_APPLICATION_ID
ZX_LINES.REF_DOC_ENTITY_CODE 		%
ZX_LINES.RELATED_DOC_APPLICATION_ID
ZX_LINES.RELATED_DOC_ENTITY_CODE 		%
ZX_LINES.APPLIED_FROM_APPLICATION_ID
ZX_LINES.APPLIED_FROM_ENTITY_CODE 		%
ZX_LINES.ADJUSTED_DOC_APPLICATION_ID
ZX_LINES.ADJUSTED_DOC_ENTITY_CODE 		%
ZX_LINES.APPLIED_TO_APPLICATION_ID
ZX_LINES.APPLIED_TO_ENTITY_CODE 		%
ZX_LINES.SUMMARY_TAX_LINE_ID ZX_LINES_SUMMARY
ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID ZX_LINES
ZX_LINES.PLACE_OF_SUPPLY_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_DATE_RULE_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_REGISTRATION_ID ZX_REGISTRATIONS
ZX_LINES.REPORTING_CURRENCY_CODE FND_CURRENCIES
ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.ORIG_TAX_STATUS_ID ZX_STATUS_B
ZX_LINES.ADJUSTED_DOC_TAX_LINE_ID ZX_LINES
ZX_LINES.REVERSED_TAX_LINE_ID ZX_LINES
ZX_LINES.TAX_REG_NUM_DET_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.EVAL_EXMPT_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.EVAL_EXCPT_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.INTERNAL_ORG_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES.TAX_PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.ORIG_TAX_RATE_ID ZX_RATES_B
ZX_LINES.TAX_APPLICABILITY_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.DIRECT_RATE_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.STATUS_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.RATE_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.BASIS_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.THRESH_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_LINE_ID ZX_PROCESS_RESULTS
ZX_LINES.INTERNAL_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
ZX_LINES.APPLICATION_ID
ZX_LINES.ENTITY_CODE 		%
ZX_LINES.APPLICATION_ID
ZX_LINES.ENTITY_CODE
ZX_LINES.EVENT_CLASS_CODE
ZX_LINES.EVENT_TYPE_CODE 		ZX_EVNT_TYP_MAPPINGS
ZX_LINES.TAX_REGIME_CODE
ZX_LINES.TAX
ZX_LINES.ORIG_TAX_JURISDICTION_CODE 		%
ZX_LINES.INTERFACE_TAX_LINE_ID RA_INTERFACE_LINES_ALL
ZX_LINES.TAX_REGIME_CODE
ZX_LINES.TAX
ZX_LINES.TAX_JURISDICTION_CODE 		%
ZX_LINES.TAX_CURRENCY_CODE FND_CURRENCIES
ZX_LINES.TAX_EXEMPTION_ID ZX_EXEMPTIONS
ZX_LINES.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_LINES.TAX_EVENT_CLASS_CODE
ZX_LINES.TAX_EVENT_TYPE_CODE 		ZX_EVNT_CLS_TYPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES_DET_FACTORS.SOURCE_TAX_LINE_ID ZX_LINES
ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID ZX_LINES
ZX_LINES.ADJUSTED_DOC_TAX_LINE_ID ZX_LINES
ZX_LINES.REVERSED_TAX_LINE_ID ZX_LINES

[top of page]

ZX.ZX_LINES does not reference any database object

ZX.ZX_LINES is referenced by following:

APPS
SYNONYM - ZX_LINES

[top of page]

Table: ZX_LINES_DET_FACTORS

Description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class.
Primary Key: ZX_LINES_DET_FACTORS_PK
  1. APPLICATION_ID
  2. EVENT_CLASS_CODE
  3. ENTITY_CODE
  4. TRX_ID
  5. TRX_LINE_ID
  6. TRX_LEVEL_TYPE
  7. ICX_SESSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_LINES_DET_FACTORS.HISTORICAL_TAX_CODE_ID AR_VAT_TAX_ALL_B
ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID HZ_CUST_ACCOUNTS
ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID HZ_CUST_ACCOUNTS
ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID %
ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID %
ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID %
ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID %
ZX_LINES_DET_FACTORS.INTERNAL_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
ZX_LINES_DET_FACTORS.APPLICATION_ID
ZX_LINES_DET_FACTORS.ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS
ZX_LINES_DET_FACTORS.HISTORICAL_TAX_CODE_ID AP_TAX_CODES_ALL
ZX_LINES_DET_FACTORS.APPLICATION_ID
ZX_LINES_DET_FACTORS.ENTITY_CODE
ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS.EVENT_TYPE_CODE 		ZX_EVNT_TYP_MAPPINGS
ZX_LINES_DET_FACTORS.LEDGER_ID %
ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE FND_CURRENCIES
ZX_LINES_DET_FACTORS.DOC_SEQ_ID FND_DOCUMENT_SEQUENCES
ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.TRX_LINE_CURRENCY_CODE FND_CURRENCIES
ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID HZ_LOCATIONS
ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID HZ_LOCATIONS
ZX_LINES_DET_FACTORS.POA_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.POO_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID HZ_LOCATIONS
ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID HZ_LOCATIONS
ZX_LINES_DET_FACTORS.SHIP_TO_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_TO_CUST_ACCT_SITE_USE_ID HZ_CUST_SITE_USES_ALL
ZX_LINES_DET_FACTORS.POA_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POO_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.TITLE_TRANS_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_TO_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POA_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POO_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_TO_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID HZ_CUST_SITE_USES_ALL
ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.REF_DOC_APPLICATION_ID
ZX_LINES_DET_FACTORS.REF_DOC_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID HR_LOCATIONS_ALL
ZX_LINES_DET_FACTORS.APPLIED_FROM_APPLICATION_ID
ZX_LINES_DET_FACTORS.APPLIED_FROM_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.ACCOUNT_CCID GL_CODE_COMBINATIONS
ZX_LINES_DET_FACTORS.ADJUSTED_DOC_APPLICATION_ID
ZX_LINES_DET_FACTORS.ADJUSTED_DOC_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.APPLIED_TO_APPLICATION_ID
ZX_LINES_DET_FACTORS.APPLIED_TO_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.RELATED_DOC_APPLICATION_ID
ZX_LINES_DET_FACTORS.RELATED_DOC_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.FIRST_PTY_ORG_ID HR_ALL_ORGANIZATION_UNITS
ZX_LINES_DET_FACTORS.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_LINES_DET_FACTORS.SOURCE_APPLICATION_ID
ZX_LINES_DET_FACTORS.SOURCE_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.TAX_EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS.TAX_EVENT_TYPE_CODE 		ZX_EVNT_CLS_TYPS
ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SOURCE_TAX_LINE_ID ZX_LINES
ZX_LINES_DET_FACTORS.MERCHANT_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.INTERFACE_LINE_ID RA_INTERFACE_LINES_ALL
ZX_LINES_DET_FACTORS.TRX_BATCH_ID RA_BATCHES_ALL
ZX_LINES_DET_FACTORS.REVERSED_APPLN_ID
ZX_LINES_DET_FACTORS.REVERSED_ENTITY_CODE 		%
ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL

[top of page]

ZX.ZX_LINES_DET_FACTORS does not reference any database object

ZX.ZX_LINES_DET_FACTORS is referenced by following:

APPS
SYNONYM - ZX_LINES_DET_FACTORS
SYNONYM - ZX_LINES_DET_FACTORS_TMP

[top of page]

Table: ZX_LINES_SUMMARY

Description: This table stores the summarized tax lines for transactions of multiple event classes.
Primary Key: ZX_LINES_SUMMARY_PK
  1. SUMMARY_TAX_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_LINES_SUMMARY.INTERNAL_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
ZX_LINES_SUMMARY.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_SUMMARY.TAX_REGIME_CODE ZX_REGIMES_B
ZX_LINES_SUMMARY.TAX_RATE_ID ZX_RATES_B
ZX_LINES_SUMMARY.TAX_REGIME_CODE
ZX_LINES_SUMMARY.TAX
ZX_LINES_SUMMARY.TAX_JURISDICTION_CODE 		%
ZX_LINES_SUMMARY.TAX_EXEMPTION_ID ZX_EXEMPTIONS
ZX_LINES_SUMMARY.APPLICATION_ID
ZX_LINES_SUMMARY.ENTITY_CODE 		%
ZX_LINES_SUMMARY.TAX_EXCEPTION_ID ZX_EXCEPTIONS
ZX_LINES_SUMMARY.LEDGER_ID %
ZX_LINES_SUMMARY.TAX_PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_SUMMARY.APPLIED_FROM_APPLICATION_ID
ZX_LINES_SUMMARY.APPLIED_FROM_ENTITY_CODE 		%
ZX_LINES_SUMMARY.ADJUSTED_DOC_APPLICATION_ID
ZX_LINES_SUMMARY.ADJUSTED_DOC_ENTITY_CODE 		%
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.SUMMARY_TAX_LINE_ID ZX_LINES_SUMMARY
ZX_REC_NREC_DIST.SUMMARY_TAX_LINE_ID ZX_LINES_SUMMARY

[top of page]

ZX.ZX_LINES_SUMMARY does not reference any database object

ZX.ZX_LINES_SUMMARY is referenced by following:

APPS
SYNONYM - ZX_LINES_SUMMARY

[top of page]

Table: ZX_PARAMETERS_B

Description: This table stores definitions of all tax parameters.
Primary Key: ZX_PARAMETERS_B_PK
  1. TAX_PARAMETER_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_PARAMETERS_TL.TAX_PARAMETER_CODE ZX_PARAMETERS_B
ZX_PARAM_DETAILS.TAX_PARAMETER_CODE ZX_PARAMETERS_B

[top of page]

ZX.ZX_PARAMETERS_B does not reference any database object

ZX.ZX_PARAMETERS_B is referenced by following:

APPS
SYNONYM - ZX_PARAMETERS_B

[top of page]

Table: ZX_PARAMETERS_TL

Description: This table provides multilingual support (MLS) for each tax parameter. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_PARAMETERS_TL_PK
  1. TAX_PARAMETER_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_PARAMETERS_TL.TAX_PARAMETER_CODE ZX_PARAMETERS_B

[top of page]

ZX.ZX_PARAMETERS_TL does not reference any database object

ZX.ZX_PARAMETERS_TL is referenced by following:

APPS
SYNONYM - ZX_PARAMETERS_TL

[top of page]

Table: ZX_PARAM_DETAILS

Description: This table stores elements for structured tax parameters.
Primary Key: ZX_PARAM_DETAILS_PK
  1. TAX_PARAMETER_CODE
  2. STRUCT_ELEMENT
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_PARAM_DETAILS.TAX_PARAMETER_CODE ZX_PARAMETERS_B

[top of page]

ZX.ZX_PARAM_DETAILS does not reference any database object

ZX.ZX_PARAM_DETAILS is referenced by following:

APPS
SYNONYM - ZX_PARAM_DETAILS

[top of page]

Table: ZX_PARTY_TAX_PROFILE

Description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities.
Primary Key: ZX_PARTY_TAX_PROFILE_PK
  1. PARTY_TAX_PROFILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_PARTY_TAX_PROFILE.PARTY_ID HZ_PARTIES
ZX_PARTY_TAX_PROFILE.PARTY_ID HZ_PARTY_SITES
ZX_PARTY_TAX_PROFILE.COUNTRY_CODE FND_TERRITORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_API_REGISTRATIONS.API_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_CONTENT_SOURCES.PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_TO_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POA_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POO_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.TITLE_TRANS_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_TO_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POA_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.POO_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_TO_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.MERCHANT_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.HQ_ESTB_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID ZX_PARTY_TAX_PROFILE
ZX_LINES.TAX_PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_SUMMARY.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_LINES_SUMMARY.TAX_PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_PROCESS_RESULTS.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_REC_NREC_DIST.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_REGIMES_B.REP_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGIMES_B.COLL_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGIMES_USAGES.FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.COLL_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.REP_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_RULES_B.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_SRVC_SUBSCRIPTIONS.SRVC_PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_STATUS_B.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_DETAILS.FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_DETAILS.PARENT_FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_OPTIONS.PARENT_FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_TAXES_B.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_TAXES_B.REP_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_TAXES_B.COLL_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_TRX_LINE_APP_REGIMES.TAX_PROVIDER_ID ZX_PARTY_TAX_PROFILE

[top of page]

ZX.ZX_PARTY_TAX_PROFILE does not reference any database object

ZX.ZX_PARTY_TAX_PROFILE is referenced by following:

APPS
SYNONYM - ZX_PARTY_TAX_PROFILE

[top of page]

Table: ZX_PARTY_TYPES

Description: This table stores party types.
Primary Key: ZX_PARTY_TYPES_PK
  1. PARTY_TYPE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_REGIMES_B.DEF_REGISTR_PARTY_TYPE_CODE ZX_PARTY_TYPES
ZX_TAXES_B.DEF_REGISTR_PARTY_TYPE_CODE ZX_PARTY_TYPES

[top of page]

ZX.ZX_PARTY_TYPES does not reference any database object

ZX.ZX_PARTY_TYPES is referenced by following:

APPS
SYNONYM - ZX_PARTY_TYPES

[top of page]

Table: ZX_PO_REC_DIST

Description: This table stores the calculated recovery rate for purcahse orders. This table is used for purchase order tax lines and distributions migration from prior releases.

[top of page]

ZX.ZX_PO_REC_DIST does not reference any database object

ZX.ZX_PO_REC_DIST is referenced by following:

APPS
SYNONYM - ZX_PO_REC_DIST

[top of page]

Table: ZX_PROCESS_RESULTS

Description: 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.
Primary Key: ZX_PROCESS_RESULTS_PK
  1. RESULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_PROCESS_RESULTS.CONDITION_GROUP_CODE ZX_CONDITION_GROUPS_B
ZX_PROCESS_RESULTS.TAX_RULE_ID ZX_RULES_B
ZX_PROCESS_RESULTS.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.CALC_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.PLACE_OF_SUPPLY_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_DATE_RULE_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_REG_NUM_DET_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.EVAL_EXMPT_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.EVAL_EXCPT_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_APPLICABILITY_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.DIRECT_RATE_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.STATUS_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.RATE_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.BASIS_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.THRESH_RESULT_ID ZX_PROCESS_RESULTS
ZX_LINES.TAX_LINE_ID ZX_PROCESS_RESULTS
ZX_REC_NREC_DIST.APPLICABILITY_RESULT_ID ZX_PROCESS_RESULTS

[top of page]

ZX.ZX_PROCESS_RESULTS does not reference any database object

ZX.ZX_PROCESS_RESULTS is referenced by following:

APPS
SYNONYM - ZX_PROCESS_RESULTS

[top of page]

Table: ZX_PRODUCT_OPTIONS_ALL

Description: This table store the tax system options for multiple applications. Each record stores tax options of an operating unit for a specific application.
Primary Key: ZX_PRODUCT_OPTIONS_ALL_PK
  1. ORG_ID
  2. APPLICATION_ID
  3. EVENT_CLASS_MAPPING_ID
Primary Key: ZX_PRODUCT_OPTIONS_PK
  1. PRODUCT_OPTIONS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_PRODUCT_OPTIONS_ALL.APPLICATION_ID FND_APPLICATION
ZX_PRODUCT_OPTIONS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS
ZX_PRODUCT_OPTIONS_ALL.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS

[top of page]

ZX.ZX_PRODUCT_OPTIONS_ALL does not reference any database object

ZX.ZX_PRODUCT_OPTIONS_ALL is referenced by following:

APPS
SYNONYM - ZX_PRODUCT_OPTIONS
SYNONYM - ZX_PRODUCT_OPTIONS_ALL

[top of page]

Table: ZX_PRVDR_HDR_EXTNS_GT

Description: This table stores the user extensible attributes that need to be passed to the partner service at the transaction level for the purpose of tax processing/reporting.
Primary Key: ZX_PRVDR_HDR_EXTNS_GT_PK
  1. EVENT_CLASS_CODE
  2. APPLICATION_ID
  3. ENTITY_CODE
  4. TRX_ID
  5. PROVIDER_ID
  6. TAX_REGIME_CODE

[top of page]

ZX.ZX_PRVDR_HDR_EXTNS_GT does not reference any database object

ZX.ZX_PRVDR_HDR_EXTNS_GT is referenced by following:

APPS
SYNONYM - ZX_PRVDR_HDR_EXTNS_GT

[top of page]

Table: ZX_PRVDR_LINE_EXTNS_GT

Description: This table stores the extensible attributes required/ need to be passed to the partner service at the line level for the purpose of tax processing/reporting.
Primary Key: ZX_PRVDR_LINE_EXTNS_GT_PK
  1. APPLICATION_ID
  2. ENTITY_CODE
  3. EVENT_CLASS_CODE
  4. TRX_ID
  5. TRX_LINE_ID
  6. TRX_LEVEL_TYPE
  7. PROVIDER_ID
  8. TAX_REGIME_CODE

[top of page]

ZX.ZX_PRVDR_LINE_EXTNS_GT does not reference any database object

ZX.ZX_PRVDR_LINE_EXTNS_GT is referenced by following:

APPS
SYNONYM - ZX_PRVDR_LINE_EXTNS_GT

[top of page]

Table: ZX_PTNR_LOCATION_INFO_GT

Description: This table stores flattened location structure for partner reference.
Primary Key: ZX_PTNR_LOCATION_INFO_GT_PK
  1. EVENT_CLASS_MAPPING_ID
  2. TRX_ID
  3. TRX_LINE_ID
  4. TRX_LEVEL_TYPE

[top of page]

ZX.ZX_PTNR_LOCATION_INFO_GT does not reference any database object

ZX.ZX_PTNR_LOCATION_INFO_GT is referenced by following:

APPS
SYNONYM - ZX_PTNR_LOCATION_INFO_GT

[top of page]

Table: ZX_PTNR_NEG_LINE_GT

Description: This global temporary table is used to cache copy of the transaction lines before user modifies them. This copying is carried only for upgraded tax partner integration.

[top of page]

ZX.ZX_PTNR_NEG_LINE_GT does not reference any database object

ZX.ZX_PTNR_NEG_LINE_GT is referenced by following:

APPS
SYNONYM - ZX_PTNR_NEG_LINE_GT

[top of page]

Table: ZX_PTNR_NEG_TAX_LINE_GT

Description: This global temporary table is used to cache copy of the tax lines before user modifies them. This copying is carried only for upgraded tax partner integration.

[top of page]

ZX.ZX_PTNR_NEG_TAX_LINE_GT does not reference any database object

ZX.ZX_PTNR_NEG_TAX_LINE_GT is referenced by following:

APPS
SYNONYM - ZX_PTNR_NEG_TAX_LINE_GT

[top of page]

Table: ZX_PURGE_TRANSACTIONS_GT

Description: This global temporary table is used by the application products to pass the identifiers of the transactions to be purged from the tax repository.

[top of page]

ZX.ZX_PURGE_TRANSACTIONS_GT does not reference any database object

ZX.ZX_PURGE_TRANSACTIONS_GT is referenced by following:

APPS
SYNONYM - ZX_PURGE_TRANSACTIONS_GT

[top of page]

Table: ZX_RATES_B

Description: 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.
Primary Key: ZX_RATES_B_PK
  1. TAX_RATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_RATE_ID ZX_RATES_B
ZX_LINES.ORIG_TAX_RATE_ID ZX_RATES_B
ZX_LINES_SUMMARY.TAX_RATE_ID ZX_RATES_B
ZX_RATES_TL.TAX_RATE_ID ZX_RATES_B
ZX_REC_NREC_DIST.TAX_RATE_ID ZX_RATES_B
ZX_REC_NREC_DIST.RECOVERY_RATE_ID ZX_RATES_B

[top of page]

ZX.ZX_RATES_B does not reference any database object

ZX.ZX_RATES_B is referenced by following:

APPS
SYNONYM - ZX_RATES_B
SYNONYM - ZX_RATES_B_TMP

[top of page]

Table: ZX_RATES_TL

Description: This table provides multilingual support (MLS) for each tax rate. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_RATES_TL_PK
  1. TAX_RATE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_RATES_TL.TAX_RATE_ID ZX_RATES_B

[top of page]

ZX.ZX_RATES_TL does not reference any database object

ZX.ZX_RATES_TL is referenced by following:

APPS
SYNONYM - ZX_RATES_TL

[top of page]

Table: ZX_RECOVERY_TYPES_B

Description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax.
Primary Key: ZX_RECOVERY_TYPES_B_PK
  1. RECOVERY_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_RECOVERY_TYPES_B.TAX_REGIME_CODE ZX_REGIMES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_RECOVERY_TYPES_TL.RECOVERY_TYPE_ID ZX_RECOVERY_TYPES_B
ZX_REC_NREC_DIST.RECOVERY_TYPE_ID ZX_RECOVERY_TYPES_B

[top of page]

ZX.ZX_RECOVERY_TYPES_B does not reference any database object

ZX.ZX_RECOVERY_TYPES_B is referenced by following:

APPS
SYNONYM - ZX_RECOVERY_TYPES_B

[top of page]

Table: ZX_RECOVERY_TYPES_TL

Description: This table provides multilingual support (MLS) for each recovery type. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_RECOVERY_TYPES_TL_PK
  1. RECOVERY_TYPE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_RECOVERY_TYPES_TL.RECOVERY_TYPE_ID ZX_RECOVERY_TYPES_B

[top of page]

ZX.ZX_RECOVERY_TYPES_TL does not reference any database object

ZX.ZX_RECOVERY_TYPES_TL is referenced by following:

APPS
SYNONYM - ZX_RECOVERY_TYPES_TL

[top of page]

Table: ZX_REC_NREC_DIST

Description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line.
Primary Key: ZX_REC_NREC_DIST_PK
  1. REC_NREC_TAX_DIST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_REC_NREC_DIST.TAX_REGIME_CODE ZX_REGIMES_B
ZX_REC_NREC_DIST.EXPENDITURE_ORGANIZATION_ID PA_EXP_ORGS_IT
ZX_REC_NREC_DIST.LEDGER_ID %
ZX_REC_NREC_DIST.SUMMARY_TAX_LINE_ID ZX_LINES_SUMMARY
ZX_REC_NREC_DIST.TRX_CURRENCY_CODE FND_CURRENCIES
ZX_REC_NREC_DIST.APPLICABILITY_RESULT_ID ZX_PROCESS_RESULTS
ZX_REC_NREC_DIST.APPLIED_FROM_TAX_DIST_ID ZX_REC_NREC_DIST
ZX_REC_NREC_DIST.APPLICATION_ID %
ZX_REC_NREC_DIST.APPLICATION_ID ZX_EVNT_TYP_MAPPINGS
ZX_REC_NREC_DIST.TAX_ID ZX_TAXES_B
ZX_REC_NREC_DIST.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_REC_NREC_DIST.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_REC_NREC_DIST.REF_DOC_APPLICATION_ID %
ZX_REC_NREC_DIST.ACCOUNT_CCID GL_CODE_COMBINATIONS
ZX_REC_NREC_DIST.ADJUSTED_DOC_TAX_DIST_ID ZX_REC_NREC_DIST
ZX_REC_NREC_DIST.TAX_STATUS_ID ZX_STATUS_B
ZX_REC_NREC_DIST.TAX_RATE_ID ZX_RATES_B
ZX_REC_NREC_DIST.RECOVERY_TYPE_ID ZX_RECOVERY_TYPES_B
ZX_REC_NREC_DIST.RECOVERY_RATE_ID ZX_RATES_B
ZX_REC_NREC_DIST.REVERSED_TAX_DIST_ID ZX_REC_NREC_DIST
ZX_REC_NREC_DIST.PROJECT_ID PA_PROJECTS_ALL
ZX_REC_NREC_DIST.TASK_ID PA_TASKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_REC_NREC_DIST.APPLIED_FROM_TAX_DIST_ID ZX_REC_NREC_DIST
ZX_REC_NREC_DIST.ADJUSTED_DOC_TAX_DIST_ID ZX_REC_NREC_DIST
ZX_REC_NREC_DIST.REVERSED_TAX_DIST_ID ZX_REC_NREC_DIST

[top of page]

ZX.ZX_REC_NREC_DIST does not reference any database object

ZX.ZX_REC_NREC_DIST is referenced by following:

APPS
SYNONYM - ZX_REC_NREC_DIST

[top of page]

Table: ZX_REC_NREC_DIST_GT

Description: This global temporary table is used to cache tax distributions during tax processing for transactions.

[top of page]

ZX.ZX_REC_NREC_DIST_GT does not reference any database object

ZX.ZX_REC_NREC_DIST_GT is referenced by following:

APPS
SYNONYM - ZX_REC_NREC_DIST_GT

[top of page]

Table: ZX_REGIMES_B

Description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process.
Primary Key: ZX_REGIMES_B_PK
  1. TAX_REGIME_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_REGIMES_B.COUNTRY_CODE FND_TERRITORIES
ZX_REGIMES_B.DEF_REGISTR_PARTY_TYPE_CODE ZX_PARTY_TYPES
ZX_REGIMES_B.PARENT_REGIME_CODE ZX_REGIMES_B
ZX_REGIMES_B.EXCHANGE_RATE_TYPE GL_RATE_TYP
ZX_REGIMES_B.TAX_CURRENCY_CODE FND_CURRENCIES
ZX_REGIMES_B.REP_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGIMES_B.COLL_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGIMES_B.THRSHLD_CHK_TMPLT_CODE ZX_DET_FACTOR_TEMPL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_CONTENT_SOURCES.PROVIDER_REGIME_CODE ZX_REGIMES_B
ZX_CONTENT_SOURCES.STANDARD_REGIME_CODE ZX_REGIMES_B
ZX_FORMULA_DETAILS.COMPOUNDING_TAX_REGIME_CODE ZX_REGIMES_B
ZX_LINES.TAX_REGIME_CODE ZX_REGIMES_B
ZX_LINES_SUMMARY.TAX_REGIME_CODE ZX_REGIMES_B
ZX_RECOVERY_TYPES_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_REC_NREC_DIST.TAX_REGIME_CODE ZX_REGIMES_B
ZX_REGIMES_B.PARENT_REGIME_CODE ZX_REGIMES_B
ZX_REGIMES_USAGES.TAX_REGIME_CODE ZX_REGIMES_B
ZX_REGIME_RELATIONS.PARENT_REGIME_CODE ZX_REGIMES_B
ZX_REGIME_RELATIONS.REGIME_CODE ZX_REGIMES_B
ZX_REGISTRATIONS.TAX_REGIME_CODE ZX_REGIMES_B
ZX_REPORTING_TYPES_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_RULES_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_STATUS_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_SUBSCRIPTION_DETAILS.TAX_REGIME_CODE ZX_REGIMES_B
ZX_TAXES_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_TRX_LINE_APP_REGIMES.TAX_REGIME_CODE ZX_REGIMES_B

[top of page]

ZX.ZX_REGIMES_B does not reference any database object

ZX.ZX_REGIMES_B is referenced by following:

APPS
SYNONYM - ZX_REGIMES_B

[top of page]

Table: ZX_REGIMES_TL

Description: This table provides multilingual support (MLS) for each tax regime. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_REGIMES_TL_PK
  1. TAX_REGIME_ID
  2. LANGUAGE

[top of page]

ZX.ZX_REGIMES_TL does not reference any database object

ZX.ZX_REGIMES_TL is referenced by following:

APPS
SYNONYM - ZX_REGIMES_TL

[top of page]

Table: ZX_REGIMES_USAGES

Description: This table stores the list of regimes for each first party organization, where the transactions of that first party organization can have tax implications.
Primary Key: ZX_REGIMES_USAGES_PK
  1. REGIME_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_REGIMES_USAGES.FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_REGIMES_USAGES.TAX_REGIME_CODE ZX_REGIMES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_SRVC_SUBSCRIPTIONS.REGIME_USAGE_ID ZX_REGIMES_USAGES
ZX_SUBSCRIPTION_OPTIONS.REGIME_USAGE_ID ZX_REGIMES_USAGES

[top of page]

ZX.ZX_REGIMES_USAGES does not reference any database object

ZX.ZX_REGIMES_USAGES is referenced by following:

APPS
SYNONYM - ZX_REGIMES_USAGES

[top of page]

Table: ZX_REGIME_RELATIONS

Description: This table stores hierarchical relationships between tax regimes.
Primary Key: ZX_REGIME_RELATIONS_PK
  1. PARENT_REGIME_CODE
  2. REGIME_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_REGIME_RELATIONS.PARENT_REGIME_CODE ZX_REGIMES_B
ZX_REGIME_RELATIONS.REGIME_CODE ZX_REGIMES_B

[top of page]

ZX.ZX_REGIME_RELATIONS does not reference any database object

ZX.ZX_REGIME_RELATIONS is referenced by following:

APPS
SYNONYM - ZX_REGIME_RELATIONS

[top of page]

Table: ZX_REGISTRATIONS

Description: This table stores tax registrations.
Primary Key: ZX_REGISTRATIONS_PK
  1. REGISTRATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_REGISTRATIONS.PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.TAX_REGIME_CODE ZX_REGIMES_B
ZX_REGISTRATIONS.TAX_JURISDICTION_CODE %
ZX_REGISTRATIONS.TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.COLL_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_REGISTRATIONS.REP_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_REGISTRATION_ID ZX_REGISTRATIONS

[top of page]

ZX.ZX_REGISTRATIONS does not reference any database object

ZX.ZX_REGISTRATIONS is referenced by following:

APPS
SYNONYM - ZX_REGISTRATIONS

[top of page]

Table: ZX_REPORTING_CODES_B

Description: This table stores reporting codes.
Primary Key: ZX_REPORTING_CODES_B_PK
  1. REPORTING_TYPE_ID
  2. REPORTING_CODE_CHAR_VALUE
  3. REPORTING_CODE_DATE_VALUE
  4. REPORTING_CODE_NUM_VALUE
  5. EFFECTIVE_FROM

[top of page]

ZX.ZX_REPORTING_CODES_B does not reference any database object

ZX.ZX_REPORTING_CODES_B is referenced by following:

APPS
SYNONYM - ZX_REPORTING_CODES_B

[top of page]

Table: ZX_REPORTING_CODES_TL

Description: This table provides multilingual support (MLS) for each reporting code. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_REPORTING_CODES_TL_PK
  1. REPORTING_CODE_ID
  2. LANGUAGE

[top of page]

ZX.ZX_REPORTING_CODES_TL does not reference any database object

ZX.ZX_REPORTING_CODES_TL is referenced by following:

APPS
SYNONYM - ZX_REPORTING_CODES_TL

[top of page]

Table: ZX_REPORTING_TYPES_B

Description: This table stores tax reporting types.
Primary Key: ZX_REPORTING_TYPES_B_PK
  1. REPORTING_TYPE_CODE
  2. TAX_REGIME_CODE
  3. TAX
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_REPORTING_TYPES_B.TAX_REGIME_CODE ZX_REGIMES_B

[top of page]

ZX.ZX_REPORTING_TYPES_B does not reference any database object

ZX.ZX_REPORTING_TYPES_B is referenced by following:

APPS
SYNONYM - ZX_REPORTING_TYPES_B

[top of page]

Table: ZX_REPORTING_TYPES_TL

Description: This table provides multilingual support (MLS) for each reporting type. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_REPORTING_TYPES_TL_PK
  1. REPORTING_TYPE_ID
  2. LANGUAGE

[top of page]

ZX.ZX_REPORTING_TYPES_TL does not reference any database object

ZX.ZX_REPORTING_TYPES_TL is referenced by following:

APPS
SYNONYM - ZX_REPORTING_TYPES_TL

[top of page]

Table: ZX_REPORT_CODES_ASSOC

Description: This table stores associate of reporting types and codes with entities like taxes, statuses and rates. Each row stores the association of a reporting code with a specific entity like tax.
Primary Key: ZX_REPORT_CODES_ASSOC_PK
  1. ENTITY_CODE
  2. ENTITY_ID
  3. REPORTING_TYPE_ID
  4. EXCEPTION_CODE
  5. EFFECTIVE_FROM

[top of page]

ZX.ZX_REPORT_CODES_ASSOC does not reference any database object

ZX.ZX_REPORT_CODES_ASSOC is referenced by following:

APPS
SYNONYM - ZX_REPORT_CODES_ASSOC

[top of page]

Table: ZX_REPORT_TYPES_USAGES

Description: This table stores information about the usage of reporting types for specific entities.
Primary Key: ZX_REPORT_TYPES_USAGES_PK
  1. REPORTING_TYPE_ID
  2. ENTITY_CODE

[top of page]

ZX.ZX_REPORT_TYPES_USAGES does not reference any database object

ZX.ZX_REPORT_TYPES_USAGES is referenced by following:

APPS
SYNONYM - ZX_REPORT_TYPES_USAGES

[top of page]

Table: ZX_REP_ACTG_EXT_T

Description: This table stores the accounting information extarcted by the tax extract program from each product transaction table. This table contains one row for every row present in ZX_REP_TRX_DETAIL_T.
Primary Key: ZX_REP_ACTG_EXT_T_PK
  1. ACTG_EXT_LINE_ID

[top of page]

ZX.ZX_REP_ACTG_EXT_T does not reference any database object

ZX.ZX_REP_ACTG_EXT_T is referenced by following:

APPS
SYNONYM - ZX_REP_ACTG_EXT_T

[top of page]

Table: ZX_REP_CONTEXT_T

Description: This table stores context information for tax reports. Each row contains operating unit address information for reports run at the ledger or operating unit level; legal entity information for reports run at the legal entity level.
Primary Key: ZX_REP_CONTEXT_T_PK
  1. REP_CONTEXT_ID

[top of page]

ZX.ZX_REP_CONTEXT_T does not reference any database object

ZX.ZX_REP_CONTEXT_T is referenced by following:

APPS
SYNONYM - ZX_REP_CONTEXT_T

[top of page]

Table: ZX_REP_MATRIX_EXT_T

Description: This table stores tax information for matrix reporting. This table contains one row for every row present in ZX_REP_TRX_DETAIL_T.
Primary Key: ZX_REP_MATRIX_EXT_T_PK
  1. DETAIL_TAX_LINE_MAT_ID

[top of page]

ZX.ZX_REP_MATRIX_EXT_T does not reference any database object

ZX.ZX_REP_MATRIX_EXT_T is referenced by following:

APPS
SYNONYM - ZX_REP_MATRIX_EXT_T

[top of page]

Table: ZX_REP_TRX_DETAIL_T

Description: This table stores the tax lines information from Payables, Receivables and General Ledger.
Primary Key: ZX_REP_TRX_DETAIL_T_PK
  1. DETAIL_TAX_LINE_ID

[top of page]

ZX.ZX_REP_TRX_DETAIL_T does not reference any database object

ZX.ZX_REP_TRX_DETAIL_T is referenced by following:

APPS
SYNONYM - ZX_REP_TRX_DETAIL_T

[top of page]

Table: ZX_REP_TRX_JX_EXT_T

Description: This table stores additional information for tax lines present in ZX_REP_TRX_DETAIL_T. This table contains one row for every row present in ZX_REP_TRX_DETAIL_T.
Primary Key: ZX_REP_TRX_JX_EXT_T_PK
  1. DETAIL_TAX_LINE_EXT_ID

[top of page]

ZX.ZX_REP_TRX_JX_EXT_T does not reference any database object

ZX.ZX_REP_TRX_JX_EXT_T is referenced by following:

APPS
SYNONYM - ZX_REP_TRX_JX_EXT_T

[top of page]

Table: ZX_REVERSE_DIST_GT

Description: This global temporary table is used to pass transaction line distribution identifiers of reversing and reversed documents.

[top of page]

ZX.ZX_REVERSE_DIST_GT does not reference any database object

ZX.ZX_REVERSE_DIST_GT is referenced by following:

APPS
SYNONYM - ZX_REVERSE_DIST_GT

[top of page]

Table: ZX_REVERSE_TRX_LINES_GT

Description:

[top of page]

ZX.ZX_REVERSE_TRX_LINES_GT does not reference any database object

ZX.ZX_REVERSE_TRX_LINES_GT is referenced by following:

APPS
SYNONYM - ZX_REVERSE_TRX_LINES_GT

[top of page]

Table: ZX_RULES_B

Description: 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.
Primary Key: ZX_RULES_B_PK
  1. TAX_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_RULES_B.TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B
ZX_RULES_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_RULES_B.APPLICATION_ID FND_APPLICATION
ZX_RULES_B.DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B
ZX_RULES_B.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_RULES_B.EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_PROCESS_RESULTS.TAX_RULE_ID ZX_RULES_B
ZX_RULES_TL.TAX_RULE_ID ZX_RULES_B

[top of page]

ZX.ZX_RULES_B does not reference any database object

ZX.ZX_RULES_B is referenced by following:

APPS
SYNONYM - ZX_RULES_B
SYNONYM - ZX_RULES_B_TMP

[top of page]

Table: ZX_RULES_TL

Description: This table provides multilingual support (MLS) for each tax rule. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_RULES_TL_PK
  1. TAX_RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_RULES_TL.TAX_RULE_ID ZX_RULES_B

[top of page]

ZX.ZX_RULES_TL does not reference any database object

ZX.ZX_RULES_TL is referenced by following:

APPS
SYNONYM - ZX_RULES_TL

[top of page]

Table: ZX_SERVICE_TYPES

Description: This table stores tax service types.
Primary Key: ZX_SERVICE_TYPES_PK
  1. SERVICE_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_API_REGISTRATIONS.SERVICE_TYPE_ID ZX_SERVICE_TYPES
ZX_SRVC_TYP_PARAMS.SERVICE_TYPE_ID ZX_SERVICE_TYPES

[top of page]

ZX.ZX_SERVICE_TYPES does not reference any database object

ZX.ZX_SERVICE_TYPES is referenced by following:

APPS
SYNONYM - ZX_SERVICE_TYPES

[top of page]

Table: ZX_SIM_CONDITIONS

Description: This table is for future use.

[top of page]

ZX.ZX_SIM_CONDITIONS does not reference any database object

ZX.ZX_SIM_CONDITIONS is referenced by following:

APPS
SYNONYM - ZX_SIM_CONDITIONS

[top of page]

Table: ZX_SIM_PROCESS_RESULTS

Description: This table is for future use.

[top of page]

ZX.ZX_SIM_PROCESS_RESULTS does not reference any database object

ZX.ZX_SIM_PROCESS_RESULTS is referenced by following:

APPS
SYNONYM - ZX_SIM_PROCESS_RESULTS

[top of page]

Table: ZX_SIM_PURGE

Description: This table is used to store information which will be used later for purging data created through tax simulator.
Primary Key: ZX_SIM_PURGE_PK
  1. TRX_ID

[top of page]

ZX.ZX_SIM_PURGE does not reference any database object

ZX.ZX_SIM_PURGE is referenced by following:

APPS
SYNONYM - ZX_SIM_PURGE

[top of page]

Table: ZX_SIM_RULES_B

Description: This table is for future use.

[top of page]

ZX.ZX_SIM_RULES_B does not reference any database object

ZX.ZX_SIM_RULES_B is referenced by following:

APPS
SYNONYM - ZX_SIM_RULES_B

[top of page]

Table: ZX_SIM_RULES_TL

Description: This table is for future use.

[top of page]

ZX.ZX_SIM_RULES_TL does not reference any database object

ZX.ZX_SIM_RULES_TL is referenced by following:

APPS
SYNONYM - ZX_SIM_RULES_TL

[top of page]

Table: ZX_SIM_RULE_CONDITIONS

Description: This table is for future use.

[top of page]

ZX.ZX_SIM_RULE_CONDITIONS does not reference any database object

ZX.ZX_SIM_RULE_CONDITIONS is referenced by following:

APPS
SYNONYM - ZX_SIM_RULE_CONDITIONS

[top of page]

Table: ZX_SIM_TRX_DISTS

Description: This table stores item distribution information for transactions created through tax simulator.
Primary Key: ZX_SIM_TRX_DISTS_PK
  1. TRX_ID
  2. TRX_LINE_ID
  3. TRX_LINE_DIST_ID

[top of page]

ZX.ZX_SIM_TRX_DISTS does not reference any database object

ZX.ZX_SIM_TRX_DISTS is referenced by following:

APPS
SYNONYM - ZX_SIM_TRX_DISTS

[top of page]

Table: ZX_SRVC_SBSCRPTN_EXCLS

Description: This table stores the list of event classes and applications that do not call the services of the tax service provider corresponding to a service subscription.
Primary Key: ZX_SRVC_SBSCRPTN_EXCLS_PK
  1. SRVC_SBSCRPTN_EXCLUSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_SRVC_SBSCRPTN_EXCLS.SRVC_SUBSCRIPTION_ID ZX_SRVC_SUBSCRIPTIONS

[top of page]

ZX.ZX_SRVC_SBSCRPTN_EXCLS does not reference any database object

ZX.ZX_SRVC_SBSCRPTN_EXCLS is referenced by following:

APPS
SYNONYM - ZX_SRVC_SBSCRPTN_EXCLS

[top of page]

Table: ZX_SRVC_SUBSCRIPTIONS

Description: This table stores the list of service subscriptions for each regime of a first party organization defined in ZX_REGIMES_USAGE table.
Primary Key: ZX_SRVC_SUBSCRIPTIONS_PK
  1. SRVC_SUBSCRIPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_SRVC_SUBSCRIPTIONS.SRVC_PROVIDER_ID ZX_PARTY_TAX_PROFILE
ZX_SRVC_SUBSCRIPTIONS.REGIME_USAGE_ID ZX_REGIMES_USAGES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_SRVC_SBSCRPTN_EXCLS.SRVC_SUBSCRIPTION_ID ZX_SRVC_SUBSCRIPTIONS

[top of page]

ZX.ZX_SRVC_SUBSCRIPTIONS does not reference any database object

ZX.ZX_SRVC_SUBSCRIPTIONS is referenced by following:

APPS
SYNONYM - ZX_SRVC_SUBSCRIPTIONS

[top of page]

Table: ZX_SRVC_TYP_PARAMS

Description: This table stores parameters for the service types.
Primary Key: ZX_SRVC_TYP_PARAMS_PK
  1. SERVICE_TYPE_ID
  2. PARAMETER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_SRVC_TYP_PARAMS.SERVICE_TYPE_ID ZX_SERVICE_TYPES

[top of page]

ZX.ZX_SRVC_TYP_PARAMS does not reference any database object

ZX.ZX_SRVC_TYP_PARAMS is referenced by following:

APPS
SYNONYM - ZX_SRVC_TYP_PARAMS

[top of page]

Table: ZX_STATUS_B

Description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner.
Primary Key: ZX_STATUS_B_PK
  1. TAX_STATUS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_STATUS_B.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_STATUS_B.TAX_REGIME_CODE ZX_REGIMES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_STATUS_ID ZX_STATUS_B
ZX_LINES.ORIG_TAX_STATUS_ID ZX_STATUS_B
ZX_REC_NREC_DIST.TAX_STATUS_ID ZX_STATUS_B
ZX_STATUS_TL.TAX_STATUS_ID ZX_STATUS_B

[top of page]

ZX.ZX_STATUS_B does not reference any database object

ZX.ZX_STATUS_B is referenced by following:

APPS
SYNONYM - ZX_STATUS_B
SYNONYM - ZX_STATUS_B_TMP

[top of page]

Table: ZX_STATUS_TL

Description: This table provides multilingual support (MLS) for each tax status. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_STATUS_TL_PK
  1. TAX_STATUS_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_STATUS_TL.TAX_STATUS_ID ZX_STATUS_B

[top of page]

ZX.ZX_STATUS_TL does not reference any database object

ZX.ZX_STATUS_TL is referenced by following:

APPS
SYNONYM - ZX_STATUS_TL

[top of page]

Table: ZX_SUBSCRIPTION_DETAILS

Description: This table stores the detailed interpretations for each enabled content subscription option defined in ZX_SUBSCRIPTION_OPTIONS table.
Primary Key: ZX_SUBSCRIPTION_DETAILS_PK
  1. SUBSCRIPTION_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_SUBSCRIPTION_DETAILS.FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_DETAILS.TAX_REGIME_CODE ZX_REGIMES_B
ZX_SUBSCRIPTION_DETAILS.SUBSCRIPTION_OPTION_ID ZX_SUBSCRIPTION_OPTIONS
ZX_SUBSCRIPTION_DETAILS.PARENT_FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE

[top of page]

ZX.ZX_SUBSCRIPTION_DETAILS does not reference any database object

ZX.ZX_SUBSCRIPTION_DETAILS is referenced by following:

APPS
SYNONYM - ZX_SUBSCRIPTION_DETAILS

[top of page]

Table: ZX_SUBSCRIPTION_OPTIONS

Description: This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIMES_USAGES table.
Primary Key: ZX_SUBSCRIPTION_OPTIONS_PK
  1. SUBSCRIPTION_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_SUBSCRIPTION_OPTIONS.PARENT_FIRST_PTY_ORG_ID ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_OPTIONS.REGIME_USAGE_ID ZX_REGIMES_USAGES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_SUBSCRIPTION_DETAILS.SUBSCRIPTION_OPTION_ID ZX_SUBSCRIPTION_OPTIONS

[top of page]

ZX.ZX_SUBSCRIPTION_OPTIONS does not reference any database object

ZX.ZX_SUBSCRIPTION_OPTIONS is referenced by following:

APPS
SYNONYM - ZX_SUBSCRIPTION_OPTIONS

[top of page]

Table: ZX_TAXES_B

Description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner.
Primary Key: ZX_TAXES_B_PK
  1. TAX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_TAXES_B.TAX_REGIME_CODE ZX_REGIMES_B
ZX_TAXES_B.CONTENT_OWNER_ID ZX_PARTY_TAX_PROFILE
ZX_TAXES_B.DEF_REGISTR_PARTY_TYPE_CODE ZX_PARTY_TYPES
ZX_TAXES_B.EXCHANGE_RATE_TYPE GL_RATE_TYP
ZX_TAXES_B.TAX_CURRENCY_CODE FND_CURRENCIES
ZX_TAXES_B.REP_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_TAXES_B.COLL_TAX_AUTHORITY_ID ZX_PARTY_TAX_PROFILE
ZX_TAXES_B.THRSHLD_CHK_TMPLT_CODE ZX_DET_FACTOR_TEMPL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
ZX_LINES.TAX_ID ZX_TAXES_B
ZX_REC_NREC_DIST.TAX_ID ZX_TAXES_B
ZX_TAXES_TL.TAX_ID ZX_TAXES_B

[top of page]

ZX.ZX_TAXES_B does not reference any database object

ZX.ZX_TAXES_B is referenced by following:

APPS
SYNONYM - ZX_TAXES_B
SYNONYM - ZX_TAXES_B_TMP

[top of page]

Table: ZX_TAXES_TL

Description: This table provides multilingual support (MLS) for each tax. MLS enables you to store and print data that you define in multiple languages.
Primary Key: ZX_TAXES_TL_PK
  1. TAX_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_TAXES_TL.TAX_ID ZX_TAXES_B

[top of page]

ZX.ZX_TAXES_TL does not reference any database object

ZX.ZX_TAXES_TL is referenced by following:

APPS
SYNONYM - ZX_TAXES_TL

[top of page]

Table: ZX_TAX_PRIORITIES_T

Description: This table stores priorities of taxes and regimes. Each row records the priority for either a tax or a regime. This table is used for tax groups migration from prior releases.

[top of page]

ZX.ZX_TAX_PRIORITIES_T does not reference any database object

ZX.ZX_TAX_PRIORITIES_T is referenced by following:

APPS
SYNONYM - ZX_TAX_PRIORITIES_T

[top of page]

Table: ZX_TAX_RELATIONS_T

Description: This table stores parent child relationships of tax codes within tax groups. This table is used for tax groups migration from prior releases.

[top of page]

ZX.ZX_TAX_RELATIONS_T does not reference any database object

ZX.ZX_TAX_RELATIONS_T is referenced by following:

APPS
SYNONYM - ZX_TAX_RELATIONS_T

[top of page]

Table: ZX_TRANSACTION

Description: This table stores transactions entered by the user through tax simulator.
Primary Key: ZX_TRANSACTION_PK
  1. TRX_ID

[top of page]

ZX.ZX_TRANSACTION does not reference any database object

ZX.ZX_TRANSACTION is referenced by following:

APPS
SYNONYM - ZX_TRANSACTION

[top of page]

Table: ZX_TRANSACTION_LINES

Description: This table stores transaction lines entered by the user through tax simulator.
Primary Key: ZX_TRANSACTION_LINES_PK
  1. TRX_ID
  2. TRX_LINE_ID

[top of page]

ZX.ZX_TRANSACTION_LINES does not reference any database object

ZX.ZX_TRANSACTION_LINES is referenced by following:

APPS
SYNONYM - ZX_TRANSACTION_LINES

[top of page]

Table: ZX_TRANSACTION_LINES_GT

Description: This global temporary table is used to pass transaction lines information for tax calculation.

[top of page]

ZX.ZX_TRANSACTION_LINES_GT does not reference any database object

ZX.ZX_TRANSACTION_LINES_GT is referenced by following:

APPS
SYNONYM - ZX_TRANSACTION_LINES_GT

[top of page]

Table: ZX_TRX_HEADERS_GT

Description: This global temporary table is used to pass transaction information for tax calculation.

[top of page]

ZX.ZX_TRX_HEADERS_GT does not reference any database object

ZX.ZX_TRX_HEADERS_GT is referenced by following:

APPS
SYNONYM - ZX_TRX_HEADERS_GT

[top of page]

Table: ZX_TRX_LINE_APP_REGIMES

Description: This table stores the applicable regimes for transactions. Each row stores one applicable regime for a specific transaction line.
Primary Key: ZX_TRX_LINE_APP_REGIMES_PK
  1. EVENT_CLASS_CODE
  2. APPLICATION_ID
  3. ENTITY_CODE
  4. TRX_ID
  5. TRX_LINE_ID
  6. TRX_LEVEL_TYPE
  7. TAX_REGIME_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ZX_TRX_LINE_APP_REGIMES.TAX_REGIME_CODE ZX_REGIMES_B
ZX_TRX_LINE_APP_REGIMES.TAX_PROVIDER_ID ZX_PARTY_TAX_PROFILE

[top of page]

ZX.ZX_TRX_LINE_APP_REGIMES does not reference any database object

ZX.ZX_TRX_LINE_APP_REGIMES is referenced by following:

APPS
SYNONYM - ZX_TRX_LINE_APP_REGIMES

[top of page]

Table: ZX_TRX_PRE_PROC_OPTIONS_GT

Description: This table stores the various provider pre-processing options for the applicable regime of the transaction under consideration before calling respective service of the provider.
Primary Key: ZX_TRX_PRE_PROC_OPTIONS_GT_PK
  1. APPLICATION_ID
  2. ENTITY_CODE
  3. EVENT_CLASS_CODE
  4. TRX_ID

[top of page]

ZX.ZX_TRX_PRE_PROC_OPTIONS_GT does not reference any database object

ZX.ZX_TRX_PRE_PROC_OPTIONS_GT is referenced by following:

APPS
SYNONYM - ZX_TRX_PRE_PROC_OPTIONS_GT

[top of page]

Table: ZX_TRX_TAX_LINK_GT

Description: This global temporary table is used to pass information about allocation of imported tax lines to transaction lines during tax processing for imported transactions.

[top of page]

ZX.ZX_TRX_TAX_LINK_GT does not reference any database object

ZX.ZX_TRX_TAX_LINK_GT is referenced by following:

APPS
SYNONYM - ZX_TRX_TAX_LINK_GT

[top of page]

Table: ZX_UPDATE_CRITERIA_RESULTS

Description: This table stores tax definition information like tax regime, tax and tax status for tax codes. This table is used for tax definition migration from prior releases.

[top of page]

ZX.ZX_UPDATE_CRITERIA_RESULTS does not reference any database object

ZX.ZX_UPDATE_CRITERIA_RESULTS is referenced by following:

APPS
SYNONYM - ZX_UPDATE_CRITERIA_RESULTS

[top of page]

Table: ZX_VALIDATION_ERRORS_GT

Description: This global temporary table is used to return validation errors for imported transactions from tax perspective.

[top of page]

ZX.ZX_VALIDATION_ERRORS_GT does not reference any database object

ZX.ZX_VALIDATION_ERRORS_GT is referenced by following:

APPS
SYNONYM - ZX_VALIDATION_ERRORS_GT

[top of page]

View: ZX_ACCOUNT_RATES_NEW_V

[top of page]

APPS.ZX_ACCOUNT_RATES_NEW_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - GL_LEDGERS
SYNONYM - ZX_ACCOUNT_RATES
VIEW - ZX_FIRST_PARTY_ORGS_ALL_V

APPS.ZX_ACCOUNT_RATES_NEW_V is not referenced by any database object

[top of page]

View: ZX_P2P_CALC_TXN_INPUT_V

[top of page]

APPS.ZX_P2P_CALC_TXN_INPUT_V references the following:

APPS
SYNONYM - ZX_EVNT_CLS_MAPPINGS
SYNONYM - ZX_LINES_DET_FACTORS
SYNONYM - ZX_PRVDR_HDR_EXTNS_GT
SYNONYM - ZX_PRVDR_LINE_EXTNS_GT
SYNONYM - ZX_PTNR_LOCATION_INFO_GT
PACKAGE - ZX_TPI_SERVICES_PKG
SYNONYM - ZX_TRX_PRE_PROC_OPTIONS_GT

APPS.ZX_P2P_CALC_TXN_INPUT_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract