Results for “sat_duration”

50+ results




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

Overview

OKS_ACTION_TIMES_V is an Oracle E-Business Suite view owned by the APPS schema in the Service Contracts (OKS) module. It exposes the contents of the OKS_ACTION_TIMES base table in a stable, read-only form intended for reporting, inquiry, and integration consumption. The object is documented in the E-Business Suite Technical Reference Manual (ETRM) for release 12.2.2 as a VALID view, and as a thin, presentation-oriented layer over contract action time definitions.

The view records the duration allocated to a given service contract action type for each day of the week, expressed in a unit of measure. It is therefore central to service coverage scheduling, response-time modelling, and entitlement calculations where the time window in which a covered action may be performed depends on the day of the week. Because it carries the standard EBS audit and concurrency columns, the view can be joined to other transactional Service Contracts entities and included in extract programs without losing the lineage of the originating row.

Underlying Base Objects

The view is defined over the base object OKS_ACTION_TIMES, accessed through a synonym in the APPS schema. The SELECT list is a one-to-one projection of the underlying table columns, with no filters, joins, or derivations applied. Consequently, every row and attribute in OKS_ACTION_TIMES is visible through OKS_ACTION_TIMES_V without transformation, and the view inherits the table's indexes, constraints, and who-column semantics. Because it is a simple projection, the view is safe for query use; it is not intended as a DML target and is exposed for read access only.

Key Columns

Common Use Cases and Queries

Typical scenarios include reporting the service window defined per covered action type, validating that weekly durations are consistent with agreed service levels, and feeding downstream scheduling or entitlement engines. A frequent pattern joins the view to action type definitions on COV_ACTION_TYPE_ID.

Find all durations for a specific covered action type:

  • SELECT id, cov_action_type_id, uom_code, sun_duration, mon_duration, tue_duration, wed_duration, thu_duration, fri_duration, sat_duration FROM apps.oks_action_times_v WHERE cov_action_type_id = :p_action_type_id;
  • SELECT cov_action_type_id, uom_code, SUM(NVL(sun_duration,0)+NVL(mon_duration,0)+NVL(tue_duration,0)+NVL(wed_duration,0)+NVL(thu_duration,0)+NVL(fri_duration,0)+NVL(sat_duration,0)) weekly_total FROM apps.oks_action_times_v GROUP BY cov_action_type_id, uom_code;
  • SELECT id, cov_action_type_id, cle_id, dnz_chr_id, last_update_date, last_updated_by FROM apps.oks_action_times_v WHERE last_update_date >= TRUNC(SYSDATE) - 7 ORDER BY last_update_date DESC;

Because the view mirrors OKS_ACTION_TIMES exactly, these queries can be rewritten against the base table where indexing or performance tuning requires it.