Results for “rate_code”

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

Overview

OKS_ENT_BILL_RATES_V is an APPS-owned database view in the Oracle E-Business Suite Service Contracts (OKS) module. It is documented in ETRM as the "Billing Rates View For Service Contracts" and is validated in both 12.1.1 and 12.2.2 environments. The view presents entitlement billing rate definitions — that is, the priced rate lines used to charge for services performed under a service contract — in a flattened, report-friendly form.

The view is particularly relevant because it exposes a derived column named RATE_NAME. Users and developers searching for "rate_name" against this object are usually looking to display the human-readable name of a billing rate rather than the internal rate code. In this view, RATE_NAME is not a physical column on any base table; it is computed at runtime by calling OKS_ENT_UTIL_PVT.GET_BILLRATE with the stored BILL_RATE_CODE. This design means the view is convenient for direct querying but the name lookup is executed per row, which can affect performance on large extracts.

Underlying Base Objects

ETRM documents three referenced base objects for this view, all resolved through synonyms in the APPS schema:

• OKC_K_LINES_B — the Contracts Core line table that carries contract, entitlement, and line-level attributes. It is aliased as KL and supplies the line identity (KL.ID) and the entitlement line type (KL.LSE_ID).
• OKS_BILLRATE_SCHEDULES — the schedule table that holds the actual billing rate definitions, including rate code, UOM, amount, percent, labor item, inventory organization, and the time-of-day and day-of-week eligibility flags. It is aliased as BSC.
• OKS_ENT_UTIL_PVT — the Service Contracts utility package whose GET_BILLRATE function converts a rate code into a display name.

The view joins OKC_K_LINES_B to OKS_BILLRATE_SCHEDULES on KL.ID = BSC.CLE_ID and filters to KL.LSE_ID IN (6, 24, 60), restricting output to the specific entitlement line types that represent billing rate records.

Key Columns

• BILL_RATE_ID — the underlying schedule line identifier (KL.ID); the primary key for a rate row.
• BILLING_TYPE_ID — the entitlement line identifier (KL.CLE_ID) linking the rate back to its parent billing type.
• RATE_CODE and RATE_NAME — the stored code and the derived display name returned by GET_BILLRATE.
• RATE_UOM, RATE_AMOUNT, RATE_PERCENT — the unit of measure, flat rate, and percentage over list price respectively.
• LABOR_ITEM_ID and INV_ORGANIZATION_ID — converted from OBJECT1_ID1 and OBJECT1_ID2 for labor-based rates.
• SCH_START and SCH_END — the covered time window, formatted as zero-padded HH:MI strings.
• SCH_FOR_SUNDAY through SCH_FOR_SATURDAY and SCH_FOR_HOLIDAY — day-of-week and holiday eligibility flags, defaulted to 'N' when null.

Common Use Cases and Queries

Typical uses include billing rate listings for contract review, rate audit extracts, and integration feeds into external pricing or invoicing systems. Because the view already resolves the rate name and joins the schedule, it eliminates the need to write the OKC_K_LINES_B to OKS_BILLRATE_SCHEDULES join manually.

List all rates with their names:

• SELECT BILL_RATE_ID, BILLING_TYPE_ID, RATE_CODE, RATE_NAME, RATE_UOM, RATE_AMOUNT, RATE_PERCENT FROM APPS.OKS_ENT_BILL_RATES_V ORDER BY RATE_NAME;

Filter to labor-based rates for a specific inventory organization:

• SELECT BILL_RATE_ID, RATE_NAME, LABOR_ITEM_ID, INV_ORGANIZATION_ID, RATE_AMOUNT FROM APPS.OKS_ENT_BILL_RATES_V WHERE INV_ORGANIZATION_ID = :org_id AND LABOR_ITEM_ID IS NOT NULL;

Identify rates eligible on weekends or holidays:

• SELECT BILL_RATE_ID, RATE_NAME, SCH_START, SCH_END FROM APPS.OKS_ENT_BILL_RATES_V WHERE SCH_FOR_SATURDAY = 'Y' OR SCH_FOR_SUNDAY = 'Y' OR SCH_FOR_HOLIDAY = 'Y';

Only base tables are queried; no secured columns are exposed, so standard APPS read privileges on the view suffice.