Search Results labor_dist_code




Overview
Explore in AI Chat

Overview

HXT_BATCH_SUM_AMOUNTS_HOURS_V is a reporting view in the Oracle EBS Time and Labor (HXT) module. It presents summarized timecard data, aggregating hours worked and monetary amounts by batch, assignment, and element. Unlike transactional views that expose individual time entries, this view consolidates detail into a batch-level summary suitable for reconciliation, payroll costing, and labor distribution reporting.

The view is documented in ETRM for Oracle EBS 12.1.1 and 12.2.2. Notably, its metadata records it as Not implemented in this database, meaning the object may not be instantiated in every environment. It is nonetheless a recognized dictionary object within the Time and Labor schema and is relevant to implementations that rely on batch summarization of hours and amounts.

The view carries a strong costing and payroll orientation. Its column set includes rate information, labor distribution codes, cost allocation keyflex segments, and tax treatment flags, positioning it as a bridge between Time and Labor timecard data and downstream payroll or costing processes.

Underlying Base Objects

The view is defined over the following objects, drawn from the ETRM view text:

  • HXT_TIMECARDS (TIM) — supplies the BATCH_ID used to group records.
  • HXT_DET_HOURS_WORKED (HRW) — the primary detail source for hours, amounts, rates, and distribution identifiers.
  • PER_TIME_PERIODS (PTP) — defines the time period boundaries used to derive effective from/to dates.
  • PER_ASSIGNMENTS_F (ASM) — provides assignment number and assignment effective dates.
  • PAY_ELEMENT_TYPES_F (ELT) — supplies the element name and element effective dates.
  • PAY_COST_ALLOCATION_KEYFLEX (PCAK) — the cost allocation keyflex, exposed through concatenated and individual segments.
  • FND_FLEX_VALUES (FFVL, FFVR) — value sets for the labor distribution code and rate code, joined with outer joins.
  • HR_LOCATIONS (LOC) — the locality worked, joined with an outer join.

The date derivation logic uses nested DECODE and SIGN functions to intersect the time period, assignment, and element effective date ranges, producing a FROM_DATE and TO_DATE per summarized row.

Key Columns

Common Use Cases and Queries

Typical uses include verifying batch totals of hours and amounts before payroll costing, auditing labor distribution by cost center, and reconciling elements against assignments. A representative query retrieving hours by batch is:

  • SELECT BATCH_ID, ASSIGNMENT_NUMBER, ELEMENT_NAME, HOURS_WORKED, AMOUNT FROM HXT_BATCH_SUM_AMOUNTS_HOURS_V WHERE BATCH_ID = :p_batch_id ORDER BY ASSIGNMENT_NUMBER;
  • SELECT LABOR_DIST_CODE, SUM(HOURS_WORKED) FROM HXT_BATCH_SUM_AMOUNTS_HOURS_V GROUP BY LABOR_DIST_CODE;
  • SELECT CONCATENATED_SEGMENTS, SUM(AMOUNT) FROM HXT_BATCH_SUM_AMOUNTS_HOURS_V GROUP BY CONCATENATED_SEGMENTS;

Because the view is documented as not implemented in some databases, administrators should confirm its presence before referencing it in custom reports.