Results for “ws_rt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.BEN_CWB_REPT_STOCK_DETAIL_V is a reporting view in the Oracle E-Business Suite Compensation Workbench (CWB) module. It is owned by the APPS schema and is registered in the FND Design Data repository as BEN.BEN_CWB_REPT_STOCK_DETAIL_V. The view is of type "Web view," a construct designed to simplify access to underlying data from Oracle Self-Service Web Applications. As its name implies, the view presents stock plan details by manager, exposing the awards allocated to employees together with the organizational hierarchy context needed for managerial reporting. The view is valid in both Oracle EBS 12.1.1 and 12.2.2 environments and is typically consumed by Compensation Workbench reporting pages and by custom extracts that need manager-oriented views of stock award data.

Underlying Base Objects

The view is defined over a substantial set of base tables, views, and packages. Compensation Workbench entities include BEN_ACTY_BASE_RT_F, BEN_CWB_HRCHY, BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_RT, BEN_PER_IN_LER, BEN_PIL_ELCTBL_CHC_POPL, BEN_PL_F, and BEN_PRTT_RT_VAL, which supply activity rates, hierarchy relationships, eligibility and electable choices, enrollment rates, plan definitions, and participant rate values. Human Resources objects supply person, assignment, organization, job, and grade data: PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ASSIGNMENT_EXTRA_INFO, PER_GRADES, PER_GRADES_TL, PER_JOBS, PER_JOBS_TL, PER_JOB_DEFINITIONS, PER_PAY_PROPOSALS, PER_PERSON_TYPES, PER_PERSON_TYPE_USAGES_F, PER_BUSINESS_GROUPS_PERF, HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_UNITS, and HR_LOOKUPS. Supporting packages and utilities referenced include BENUTILS, HR_API, HR_GENERAL, and HR_SECURITY; the latter enforces row-level security so that a manager only sees the population they are authorized to view.

Key Columns

The view exposes the following columns, which together describe a stock award within manager and employee context:

• RT_STRT_DT – rate start date for the award.
• PLAN_NAME – the stock plan name.
• EMP_FULL_NAME, EMP_BRIEF_NAME, EMPNO – identifying data for the employee receiving the award.
• IMM_MGR_FULL_NAME, IMM_MGR_BRIEF_NAME – the immediate manager. The user's search term imm_mgr_full_name maps directly to this column.
• WS_MGR_FULL_NAME, WS_MGR_BRIEF_NAME – the worksheet (workflow/plan) manager.
• WS_AMOUNT, WS_AMOUNT_UNITS – the awarded amount and its unit of measure.
• LEVELS_DOWN – hierarchy depth relative to the manager.
• COMMENTS – free-text comments (length 35).
• JOB, JOB_SEGMENT1..5, GRADE, BASE_SALARY – assignment attributes from HR.
• PERSON_ATTRIBUTE1..10 – descriptive flexfield segments for person-level context.

The IMM_MGR_FULL_NAME column is particularly useful when reports must present an employee's direct supervisor alongside the awarding manager, since the two are not always the same.

Common Use Cases and Queries

Typical uses include CWB stock award reporting, compensation review extracts, and manager-level audit of stock allocations. Because the view is secured through HR_SECURITY, it is normally queried in the context of the logged-in user's responsibility. A sample query that retrieves stock awards with the awardee and immediate manager is shown below:

SELECT plan_name,
       emp_full_name,
       empno,
       imm_mgr_full_name,
       ws_amount,
       ws_amount_units,
       rt_strt_dt
  FROM apps.ben_cwb_rept_stock_detail_v
 WHERE rt_strt_dt BETWEEN :p_start AND :p_end
 ORDER BY imm_mgr_full_name, emp_full_name;

For downstream integration, the same view can be joined on EMPNO to APPS.PER_ALL_PEOPLE_F to enrich records with additional person attributes or to reconcile against other CWB reports such as salary and bonus detail views. As with all APPS reporting views, performance and security depend on the base objects and the HR security profile applied to the calling user, so queries should be filtered to a specific plan, manager, or date range wherever possible.