Search Results itax_dpnt_ref_type




Overview
Explore in AI Chat

Overview

The view APPS.PAY_JP_ITAX_WITHHELD_V is a Japanese localization reporting object within the Oracle EBS Payroll module. It consolidates withholding income tax (ITAX) results calculated for employees during a payroll run, together with social insurance premiums, mutual aid contributions, and dependent-related tax reference attributes. In Oracle EBS 12.1.1 and 12.2.2 it is registered as a VIEW owned by the APPS schema, is currently VALID, and is designated Oracle Internal Use Only with a View Type of Internal. Oracle does not support direct access to this object except through standard Oracle Applications programs, so its role is primarily to support seeded Japanese payroll reports, statutory tax extracts, and dependent declarations rather than to serve as a general-purpose integration interface.

Underlying Base Objects

The view is defined over a mix of payroll transactional tables, HR assignment and period-of-service objects, and a localization calculation view. The documented dependencies are:

  • PAY_JP_PRE_TAX — the Japanese pre-tax calculation view supplying core taxable and tax amount figures.
  • PAY_ASSIGNMENT_ACTIONS — payroll actions at assignment level, linking runs to individual employees.
  • PAY_PAYROLL_ACTIONS and PAY_ACTION_INTERLOCKS — action-level payroll processing metadata and interlock sequencing.
  • PAY_ALL_PAYROLLS_F — the payroll definition used to resolve payroll and period context.
  • PER_ALL_ASSIGNMENTS_F — the dated assignment record providing assignment, person, and organizational context.
  • PER_PERIODS_OF_SERVICE — periods of service supplying hire, termination, and leaving-related data.
  • FND_NUMBER — an Oracle Application Object Library package referenced to support numeric conversion logic.

The view therefore joins payroll tax computation output to assignment and period-of-service context, forming a flattened retention of withholding tax results per assignment, per year, and per ITAX organization.

Key Columns

The view exposes identification, classification, and amount columns:

Common Use Cases and Queries

Typical usage involves validating withholding tax results for a given year or organization, reconciling year-end adjustments, and extracting dependent reference classifications. Although direct querying is unsupported, technical teams frequently query the view for diagnostics.

SELECT person_id,
       assignment_id,
       year,
       itax_category,
       taxable_amt,
       itax,
       itax_dpnt_ref_type
FROM   apps.pay_jp_itax_withheld_v
WHERE  year = :p_year
AND    itax_organization_id = :p_org_id;

To isolate dependent reference types in the tax result:

SELECT itax_dpnt_ref_type, COUNT(*) AS records, SUM(itax) AS total_itax
FROM   apps.pay_jp_itax_withheld_v
WHERE  year = :p_year
GROUP  BY itax_dpnt_ref_type;

Year-over-year comparison of prior figures for reconciliation:

SELECT assignment_id, prev_swot_taxable_amt, prev_swot_itax
FROM   apps.pay_jp_itax_withheld_v
WHERE  year = :p_year
AND    assignment_id = :p_assignment_id;

Because the object is internally designated, any direct SQL should remain read-only and be validated against seeded Japanese payroll reports before use in production reconciliation.