Search Results asg_rate_type




Overview
Explore in AI Chat

Overview

APPS.PO_TEMP_LABOR_RATES_V is a reporting view in Oracle E-Business Suite Purchasing (PO) that exposes temporary labor rate information for standard purchase orders. It consolidates rate-based and fixed-price temporary labor purchase order lines, along with any applicable price differentials, into a single queryable structure. The view is designed to support reporting and integration scenarios where organizations need visibility into contracted labor rates, currency conversion attributes, and pricing adjustments defined on temporary labor agreements.

Because the view surfaces currency-related columns such as CURRENCY_CODE, CURRENCY_RATE, CURRENCY_RATE_TYPE, and CURRENCY_RATE_DATE, it is particularly relevant to users searching for "currency_rate_type." The CURRENCY_RATE_TYPE column maps directly to PO_HEADERS_ALL.RATE_TYPE, allowing consumers to identify the exchange rate type applied to the purchase order currency conversion.

Underlying Base Objects

The view is defined over a documented set of base objects. The primary driving table is PO_HEADERS_ALL (accessed via a synonym), which supplies currency and exchange rate attributes. PO_LINES_ALL provides the individual temporary labor line details, including unit price, amount, unit of measure, and effective dates. PO_LINE_TYPES_B is joined to restrict results to line types whose ORDER_TYPE_LOOKUP_CODE is 'RATE' or 'FIXED PRICE' and whose PURCHASE_BASIS is 'TEMP LABOR'.

Price differential records are sourced from PO_PRICE_DIFFERENTIALS, linked by ENTITY_ID to PO_LINE_ID with ENTITY_TYPE = 'PO LINE' and ENABLED_FLAG = 'Y'. Descriptive currency names come from FND_CURRENCIES_VL, and unit of measure descriptions are resolved through MTL_UNITS_OF_MEASURE. FND_LOOKUPS supplies lookup meanings, and FND_GLOBAL is referenced for session context. The view is a UNION ALL of two branches: one for standard PO lines and one for price differentials.

Key Columns

  • PO_LINE_ID — Identifier of the purchase order line, used for joins back to PO_LINES_ALL.
  • CURRENCY_NAME — Descriptive currency name from FND_CURRENCIES_VL.
  • CURRENCY_CODE — Currency code from the purchase order header.
  • RATE_VALUE — The rate amount; for 'RATE' lines it is the unit price, otherwise the line amount. For price differentials, it is the unit price multiplied by the differential multiplier.
  • RATE_BASIS / RATE_BASIS_DSP — Unit of measure code and its descriptive translation.
  • ASG_RATE_TYPE — Either 'STANDARD' or the price differential PRICE_TYPE.
  • PRICE_TYPE_DSP — Lookup meaning for the price type.
  • START_DATE / END_DATE — Line start and expiration dates.
  • CURRENCY_RATE — The exchange rate stored on the purchase order header.
  • CURRENCY_RATE_TYPE — The rate type (RATE_TYPE) from PO_HEADERS_ALL, central to currency conversion analysis.
  • CURRENCY_RATE_DATE — The effective date of the exchange rate.

Common Use Cases and Queries

This view is commonly used to report temporary labor rates by currency and rate type, to reconcile price differentials against base labor lines, and to feed downstream integrations requiring normalized rate data. A typical query retrieves rate details for a given currency and rate type:

  • SELECT po_line_id, currency_code, currency_rate_type, currency_rate, rate_value, start_date, end_date FROM apps.po_temp_labor_rates_v WHERE currency_rate_type = 'Corporate';

Users may also aggregate by rate type to analyze exposure, or filter by rate basis to examine labor priced per hour versus per unit. Because the view joins multiple transactional and setup tables, it provides a convenient, denormalized source for temporary labor rate reporting without requiring custom joins.