Search Results system_linkage_function_m




Overview
Explore in AI Chat

Overview

APPS.PA_BILL_RATES_JOB is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as PA.PA_BILL_RATES_JOB. It presents bill rate schedule information in a denormalized, form-friendly layout, joining labor bill rates to job definitions and descriptive lookup values. The view carries a VALID status in both 12.1.1 and 12.2.2, and its column list is consistent across those releases.

Oracle explicitly classifies this object as a supplementary view used to simplify Oracle Forms coding, and the documentation warns that querying or altering data through it is not recommended because its definition may change dramatically in subsequent minor or major releases. As a result, it should be treated as an internal presentation layer for the Projects (PA) module rather than a supported integration or reporting interface. The column of interest in the originating search, SYSTEM_LINKAGE_FUNCTION_M, is exposed here as a VARCHAR2 field and is one of several descriptive attributes carried alongside the rate definition.

Underlying Base Objects

The documented base objects referenced by the view are:

  • PA_BILL_RATES (SYNONYM) — the primary source of bill rate schedule rows, supplying identifiers, rate amounts, markup percentages, effective dates, rate currency, and the standard WHO columns.
  • PER_JOBS (SYNONYM) — supplies job definition attributes such as JOB_ID and JOB_NAME, and contributes the job group reference exposed as JOB_GROUP_ID.
  • FND_LOOKUP_VALUES (SYNONYM) — resolves coded values into user-facing descriptions, notably supporting the SYSTEM_LINKAGE_FUNCTION and SYSTEM_LINKAGE_FUNCTION_M pair that carries the base lookup code and its translated meaning.

Because the view is defined over synonyms owned by APPS, it resolves to the underlying PA and HR tables at runtime. Consumers should reference PA_BILL_RATES, PER_JOBS, and FND_LOOKUP_VALUES directly when building supported queries.

Key Columns

Common Use Cases and Queries

The typical use of this view is diagnostic: identifying the system linkage function assigned to a job-based bill rate line, or retrieving the descriptive meaning of a coded linkage value. A representative query follows.

SELECT bill_rate_sch_id, std_bill_rate_schedule, job_name,
       system_linkage_function, system_linkage_function_m,
       rate, rate_currency_code, bill_rate_unit_m
 FROM apps.pa_bill_rates_job
 WHERE job_id = :job_id
   AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Because the view is unsupported for direct querying, production code should instead join PA_BILL_RATES to PER_JOBS and FND_LOOKUP_VALUES directly, applying the same effective-date logic. The view remains valuable, however, as a reference for reconstructing the intended join logic and column semantics during analysis, upgrades, or troubleshooting of Oracle Forms behavior in Release 12.1.1 and 12.2.2.