Search Results oks_pma_v




Overview
Explore in AI Chat

Overview

OKS_PMA_V is an Oracle E-Business Suite view owned by the APPS schema within the OKS – Service Contracts product family. Its purpose is narrow and well defined: it exposes every activity (rule) that has been selected against a contract, presenting that information in a shape optimized for the Service Contracts Forms user interface. The documented description explicitly states that the view is intended only for Forms UI development, meaning it should not be treated as a general-purpose integration or reporting interface. That constraint matters because the view surfaces several columns drawn directly from generic rule-information flexfields rather than from purpose-built attributes.

The view has no independent storage. It is a pure projection over two base rule-group and rule tables and therefore reflects the live state of contract rule configuration at query time.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms in the APPS schema:

  • OKC_RULE_GROUPS_B – aliased as RGP. Supplies the rule-group container, including CLE_ID and DNZ_CHR_ID.
  • OKC_RULES_B – aliased as RUL. Supplies the individual rule rows, their object identifiers, flexfield information, and audit columns.

The join is RUL.RGP_ID = RGP.ID, restricted by three predicates: RGP.RGD_CODE = 'SVC_K', RUL.RULE_INFORMATION_CATEGORY = 'PMA', and the implicit requirement that the rule belongs to a service rule group. Rule identifiers are carried in paired OBJECT1_ID1/OBJECT1_ID2 and OBJECT2_ID1/OBJECT2_ID2 columns, and descriptive flags are read from RULE_INFORMATION1 through RULE_INFORMATION3.

Key Columns

Common Use Cases and Queries

Typical usage is to retrieve selected activities for a given contract or contract line, often filtered on SELECT_FLAG.

  • List all selected PMA activities for a contract line:
    SELECT pma_rule_id, activity_id1, activity_id2, select_flag FROM apps.oks_pma_v WHERE cle_id = :cle_id AND select_flag = 'Y';
  • Check confirmation and scheduling attributes for a contract header:
    SELECT dnz_chr_id, pma_rule_id, confirmation_required, schedule_exists FROM apps.oks_pma_v WHERE dnz_chr_id = :chr_id;
  • Join back to contract structures by CLE_ID/DNZ_CHR_ID for reporting on selected service activities.

Because the view is documented for Forms UI use only, direct queries should be limited to diagnostics and support investigations rather than production reporting or integration, as the underlying flexfield-based columns and the 'PMA' category restriction are not part of a published, stable interface contract.