Results for “rate_basis”

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

Overview

PO_TEMP_LABOR_RATES_V is a Purchasing (PO) module view owned by the APPS schema and validated in Oracle EBS 12.1.1 and 12.2.2. It exposes rate information for temporary labor lines and their associated price differentials on Standard purchase orders. The view consolidates two logical datasets via UNION ALL: the first branch retrieves the base rate of temp labor PO lines, and the second branch retrieves price differentials applied to those lines. In EBS reporting and integration, this view is typically consumed to produce rate cards, labor rate extracts, and interface payloads where the effective bill rate — including differentials — must be computed and presented alongside currency context.

Underlying Base Objects

The view is defined over the following documented objects:

• PO_HEADERS_ALL — provides the Standard PO header, currency code, and exchange rate attributes.
• PO_LINES_ALL — supplies the PO line, unit price, amount, unit of measure, and effective dates.
• PO_LINE_TYPES_B — determines whether the line is RATE or FIXED PRICE and identifies PURCHASE_BASIS = 'TEMP LABOR'.
• PO_PRICE_DIFFERENTIALS — used in the second branch to obtain multipliers and price types for differentials.
• FND_CURRENCIES_VL — resolves the currency name from the header currency code, which is directly relevant to the currency_name search term.
• FND_LOOKUPS — supplies display meanings for price differential lookups.
• MTL_UNITS_OF_MEASURE — an outer-joined synonym providing the unit of measure display value.
• FND_GLOBAL — a package referenced for session-level context.

Joins are anchored on PO_LINES_ALL.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID, with the header restricted to TYPE_LOOKUP_CODE = 'STANDARD'. The line must map to a line type whose PURCHASE_BASIS = 'TEMP LABOR' and whose ORDER_TYPE_LOOKUP_CODE is RATE or FIXED PRICE.

Key Columns

• PO_LINE_ID — the PO line identifier, the primary key to the source line.
• CURRENCY_NAME — the descriptive name of the currency, sourced from FND_CURRENCIES_VL.NAME.
• CURRENCY_CODE — the ISO currency code from the PO header.
• RATE_VALUE — for base lines, the unit price (RATE) or amount (FIXED PRICE); for differentials, the line unit price multiplied by NVL(MULTIPLIER,1).
• RATE_BASIS / RATE_BASIS_DSP — the unit of measure code and its translated description.
• ASG_RATE_TYPE — 'STANDARD' for base lines; the price type for differentials.
• PRICE_TYPE_DSP — the lookup meaning for the price differential type.
• START_DATE / END_DATE — the line's effective and expiration dates.
• CURRENCY_RATE, CURRENCY_RATE_TYPE, CURRENCY_RATE_DATE — the header exchange rate, its type, and its effective date.

Common Use Cases and Queries

A frequent requirement is to list all temp labor rates with their currency names for a given PO:

• Validate that rate values are correctly stored against the expected currency and unit of measure.
• Extract effective-dated rate cards for downstream time-and-expense interfaces.
• Report price differentials separately from base rates using ASG_RATE_TYPE.

Sample query:

SELECT po_line_id, currency_name, currency_code, rate_value, rate_basis_dsp, asg_rate_type, start_date, end_date FROM apps.po_temp_labor_rates_v WHERE currency_name = :p_currency ORDER BY po_line_id, asg_rate_type;

Because base rates and differentials share the same PO_LINE_ID, aggregating RATE_VALUE across both rows yields the total effective rate, while filtering on ASG_RATE_TYPE = 'STANDARD' isolates the base rate alone.