Results for “int_start_date”

10 results




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

Overview

OKC_LAUNCH_COMMGRID_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the OKC – Contracts Core product. The view presents a consolidated, denormalized projection of Oracle Contracts interaction and communication activity, joining contract header records to their associated interaction (communication) history, media, agents, parties, action items, and outcomes. Its principal role is to back the "Communications Grid" or launch-page summary that surfaces, for a given contract, the communications exchanged with customers, the responsible agents, and the results recorded against each interaction.

The view is read-only and exists purely for reporting and integration consumption rather than transactional processing. It is typically surfaced through Oracle Forms, OAF pages, or custom concurrent programs, and is commonly queried by developers extending the Contracts module. The presence of OUTCOME_MEANING in the projection makes the view particularly relevant to outcome-based communication reporting.

Underlying Base Objects

The view is defined over a UNION ALL of two similar SELECT statements, each joining the same eleven to twelve core objects. The documented base objects are:

The initial SELECT drives party-based touchpoints (TOUCHPOINT1_TYPE = 'PARTY') joined to HZ_PARTIES; the UNION ALL branch handles the alternate party source (ROL.SOURCE_NAME) for non-standard touchpoint configurations.

Key Columns

The OUTCOME_MEANING column, resolved from the short description of JTF_IH_OUTCOMES_VL, allows reports to display human-readable results without an additional lookup join.

Common Use Cases and Queries

Typical uses include building a communications dashboard for a contract, analysing outcome distributions, and auditing agent activity. A representative query filtering by contract and surfacing outcome detail:

  • SELECT contract_id, party_name, agent_name, media_meaning, outcome_meaning, act_start_date FROM okc_launch_commgrid_v WHERE contract_id = :p_contract_id ORDER BY act_start_date DESC;
  • Outcome-based reporting, e.g. grouping interactions by OUTCOME_MEANING to measure communication effectiveness across a period.
  • Agent activity summaries joining AGENT_ID to JTF_RS resources for workload analysis.
  • Media-channel breakdowns using MEDIA_MEANING joined through FND_LOOKUPS values under lookup type JTF_MEDIA_TYPE.

Because the view is read-only, it should never be used for DML. When performance is a concern, restrict queries by CONTRACT_ID, PARTY_ID, or date ranges to limit the UNION ALL scan, as the object joins multiple VL and synonym objects that can be expensive without selective predicates.