Results for “company_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ARP_TAX_VIEW_VERTEX is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API. It resides in the Oracle Receivables (AR) product family, where the ARP prefix denotes Receivables-related database objects. The package functions as a tax view vertex holder, meaning it encapsulates the tax-relevant attributes of a transaction or entity — the "vertices" — that Oracle's E-Business Tax (EBTax) engine evaluates when determining applicable tax rules and rates. In EBS 12.1.1 and 12.2.2, tax determination in Receivables is driven by the tax services layer, and the ARP_TAX_VIEW_VERTEX package provides the Receivables-side representation of those vertex attributes so that the tax engine can process them correctly.
The package is documented as VALID in both releases and depends on SYS.STANDARD only, indicating it is a lightweight, self-contained construct that does not itself query application tables directly. It is referenced by ZX_VTX_USER_PKG, the E-Business Tax user-defined vertex package, confirming its role in the tax vertex framework.
Key Procedures and Functions
The ETRM documents sixteen procedures and functions within this package. Their purpose is to expose individual transaction and party attributes as discrete vertex values to the tax engine:
- PRODUCT_CODE — returns the inventory product code used to classify the item being taxed.
- VENDOR_CONTROL_EXEMPTIONS — supplies vendor-controlled exemption information relevant to tax exemption processing.
- COMPANY_CODE and DIVISION_CODE — provide organizational classification attributes used in tax rule qualification.
- TRX_LINE_TYPE — identifies the line type of the transaction line under evaluation.
- CUSTOMER_CLASS and CUSTOMER_CODE — supply customer classification and customer identifier attributes used to match tax rules.
- GET_EXEMPTIONS — retrieves exemption status or exemption details applicable to the current transaction.
- POO_ADDRESS_CODE and POA_ADDRESS_CODE — return "Point of Order Origin" and "Point of Order Acceptance" address codes, two of the standard EBTax address vertices.
- SHIP_FROM_ADDRESS_CODE and SHIP_TO_ADDRESS_CODE — return the ship-from and ship-to location codes central to place-of-supply determination.
- AUDIT_FLAG — indicates whether tax audit information should be captured for the transaction.
- TOTAL_TAX — exposes the total tax amount calculated for the transaction.
- TRANSACTION_DATE — supplies the transaction date used to select effective-dated tax rates and rules.
- OVERRIDE_PARAMETERS — permits certain tax parameter values to be overridden during determination.
Parameter lists are not documented in the ETRM; only the procedural names and their semantic roles are published.
Tables Accessed
The ETRM metadata for ARP_TAX_VIEW_VERTEX does not list any tables referenced via APPS synonyms, and its only dependency is SYS.STANDARD, which is the PL/SQL standard package. This indicates that the package itself does not directly query or modify application tables. Instead, it collects and returns vertex attribute values supplied by its caller — typically the E-Business Tax tax-determination engine or the ZX_VTX_USER_PKG integration layer — which in turn reads the underlying transaction, customer, and address data from Receivables and EBTax tables. Any data access occurs in the calling context rather than within this package.
Usage Notes
The package is invoked indirectly through the E-Business Tax vertex framework rather than being called by end users. When a Receivables transaction is saved, or when the tax engine is invoked during invoice entry, the tax services layer requests vertex values; ARP_TAX_VIEW_VERTEX supplies the Receivables-specific values from the documented functions, and the returned attributes feed tax rule qualification and rate determination. Because ZX_VTX_USER_PKG references this package, it is part of the user-extensible vertex mechanism within EBS 12.1.1 and 12.2.2. Customizations and extensions that require additional tax attributes should generally be implemented through the supported EBTax configuration and user-defined vertex packages rather than by modifying this seeded package. Direct calls from custom PL/SQL are possible but not recommended, as the seeded API signature is not published as a public interface in the ETRM.
-
Created by ORACLE on 14-FEB-97
-
APPS.XTR_SETTLE_ROW_UTILISED_V·↳ XTR_MASTER_CURRENCIES·↳ XTR_SETTLEMENTS_V·↳ XTR_USER_ACCESS·Explore XTR module →
-
APPS.XTR_SETTLE_ROW_UTILISED_V·↳ XTR_MASTER_CURRENCIES·↳ XTR_SETTLEMENTS_V·↳ XTR_USER_ACCESS·Explore XTR module →
-
APPS.XTR_PORTFOLIO_DEAL_AMOUNTS_V·↳ XTR_PORTFOLIO_DEAL_AMOUNTS·Explore XTR module →
-
Created from Entity XTR PORTFOLIO DEAL AMOUNT by ORACLE on 06-MAY-93
-
APPS.XTR_PORTFOLIO_DEAL_AMOUNTS_V·↳ XTR_PORTFOLIO_DEAL_AMOUNTS·Explore XTR module →
-
Not currently used
-
APPS.XTR_BANK_BAL_INTERFACE_V·↳ XTR_BANK_BAL_INTERFACE·Explore XTR module →
-
APPS.XTR_LIMIT_UTILIZATION_FEE_V·↳ XTR_LIMIT_UTILIZATION_FEE·Explore XTR module →
-
Created from Entity XTR GL REFERENCE by ORACLE on 06-MAY-93
-
Created from Entity XTR GL REFERENCE by ORACLE on 06-MAY-93
-
View: XTR_A_GL_REFERENCES_V 12.1.1
APPS.XTR_A_GL_REFERENCES_V·↳ XTR_A_GL_REFERENCES·Explore XTR module →
-
This table contains company settlement codes to be used for the one-step settlement method.
-
This table contains company settlement codes to be used for the one-step settlement method.
-
APPS.XTR_ONE_STEP_SETTLE_CODES_V·↳ FND_GLOBAL·↳ XTR_COMPANY_AUTHORITIES·↳ XTR_DEALER_CODES·Explore XTR module →
-
Sovereign limits information including limit and utilization amounts
-
This table will store transactional parameters specific to each company.
-
This table will store transactional parameters specific to each company.
-
Sovereign limits information including limit and utilization amounts
-
View: XTR_LOAN_SECURITIES_V 12.1.1
APPS.XTR_LOAN_SECURITIES_V·↳ XTR_LOAN_SECURITIES·Explore XTR module →
-
APPS.HR_COMPANY_COST_CENTERS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ORGANIZATION_INFORMATION·Explore PER module →
-
APPS.XTR_CASH_TRANSACTIONS_V·↳ XTR_DEAL_SUBTYPES·↳ XTR_DEAL_TYPES·↳ XTR_ROLLOVER_TRANSACTIONS_V·Explore XTR module →
-
APPS.XTR_CASH_TRANSACTIONS_V·↳ XTR_DEAL_SUBTYPES·↳ XTR_DEAL_TYPES·↳ XTR_ROLLOVER_TRANSACTIONS_V·Explore XTR module →
-
Mapping table for GML and OM order types.
-
Mapping table for GML and OM order types.
-
Created from Entity XTR PORTFOLIO DEAL AMOUNT by ORACLE on 06-MAY-93
-
View: XTR_EFT_CREDITS_V 12.2.2
APPS.XTR_EFT_CREDITS_V·↳ XTR_DEAL_DATE_AMOUNTS_V·↳ XTR_USER_ACCESS·Explore XTR module →
-
View: XTR_GROUP_LIMITS_V 12.2.2
APPS.XTR_GROUP_LIMITS_V·↳ FND_GLOBAL·↳ XTR_COMPANY_AUTHORITIES·↳ XTR_DEALER_CODES·Explore XTR module →
-
APPS.XTR_SOURCE_OF_IMPORTS_V·↳ XTR_SOURCE_OF_IMPORTS·Explore XTR module →
-
View: XTR_GROUP_LIMITS_V 12.1.1
APPS.XTR_GROUP_LIMITS_V·↳ FND_GLOBAL·↳ XTR_COMPANY_AUTHORITIES·↳ XTR_DEALER_CODES·Explore XTR module →
-
This table is designed to store the tolerance setup for the override feature.
-
Stores the hedge accounting structure information used to generate journals.
-
This table is designed to store the tolerance setup for the override feature.
-
APPS.XTR_INTEREST_TOLERANCES_V·↳ FND_GLOBAL·↳ XTR_COMPANY_AUTHORITIES·↳ XTR_DEALER_CODES·Explore XTR module →
-
View: XTR_A_COMPANY_LIMITS_V 12.1.1
APPS.XTR_A_COMPANY_LIMITS_V·↳ XTR_A_COMPANY_LIMITS·Explore XTR module →
-
APPS.XTR_INTEREST_TOLERANCES_V·↳ FND_GLOBAL·↳ XTR_COMPANY_AUTHORITIES·↳ XTR_DEALER_CODES·Explore XTR module →
-
APPS.XTR_COMPANY_LIMITS_EXCL_FX_V·↳ XTR_COMPANY_LIMITS·↳ XTR_LIMIT_TYPES·Explore XTR module →
-
Import source information used for reconciliation
-
View: AMW_AUDIT_UNITS_V 12.1.1
This view returns information about Audit Units
APPS.AMW_AUDIT_UNITS_V·↳ FND_FLEX_VALUES_VL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AMW module →
-
Import source information used for reconciliation
-
This table stores the fundamental information for each batch process.
-
APPS.XTR_ACCOUNT_DEBIT_AUTHS_V·↳ XTR_ACCOUNT_DEBIT_AUTHS·Explore XTR module →