Search Results itax_category




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_WIC_ASSACTS_V is an Oracle E-Business Suite view that exposes assignment action ("ASSACT") records specifically for Japanese withholding income tax (WIC) processing. The view is layered over the base view PAY_JP_WIC_ASSACTS_V2 and applies a de-duplication filter so that only the most current, relevant assignment action for each combination of assignment and withholding tax organization is returned for a given tax year. Its role is primarily to support Japanese payroll tax reporting, statutory year-end adjustment (YEA) processing, and downstream integration of withholding tax category data with external reporting engines.

The name reflects its scope: WIC denotes the Japanese income tax withholding context, ASSACTS denotes assignment actions, and the trailing _V identifies the object as a view. Rather than storing data itself, the view derives its results entirely from the referenced base view.

Underlying Base Objects

The view is defined over PAY_JP_WIC_ASSACTS_V2. In addition, the documented metadata lists FND_DATE (package) and FND_NUMBER (package) as referenced objects. These packages are standard Oracle EBS utilities used for date and numeric conversion and validation, typically applied during formatting or comparison of effective and termination dates.

The defining mechanism is a correlated NOT EXISTS subquery against the same base view (aliased WIC2). A record is retained only when no later action sequence exists for the same assignment, tax organization, and within the same effective year that shares a comparable tax category grouping or carries a valid future YEA category. This produces a "latest applicable action per year" result set.

Key Columns

Common Use Cases and Queries

The most frequent use is retrieval of the prevailing withholding tax category for an employee assignment in a given year, particularly when reconciling the "itax_category" attribute. A representative query is:

SELECT assignment_id,
       itax_category,
       itax_organization_id,
       effective_date
  FROM apps.pay_jp_wic_assacts_v
 WHERE assignment_id = :p_assignment_id
   AND itax_organization_id = :p_org_id;

Another common scenario joins the view to the assignment to identify current tax categories across a population:

SELECT a.assignment_id, a.itax_category, a.itax_yea_category
  FROM apps.pay_jp_wic_assacts_v a, per_all_assignments_f p
 WHERE a.assignment_id = p.assignment_id
   AND a.itax_category IN ('M_KOU','D_KOU','M_OTSU','D_OTSU','D_HEI')
   AND a.effective_date BETWEEN :p_start AND :p_end;

Because the de-duplication logic already suppresses superseded actions and valid future YEA records, the view is well suited to year-end tax reporting extracts and reconciliation of withholding tax categories against statutory filings.