Results for “okc_report_htm_v”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_REPORT_HTM_V is a reporting view owned by the APPS schema within the OKC — Contracts Core product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to support Contract Printing by exposing the HTML presentation of a contract that has been generated and stored by the contract authoring and printing process. In practice, the view acts as a language-filtered window onto the stored HTML report content, allowing printing, previewing, and integration routines to retrieve the rendered contract text without reading the full underlying table directly.
The view is classified as VALID in ETRM and is defined over a single base table, OKC_REPORT_HTM, accessed through a synonym. It exposes the identity, versioning, and audit columns of the HTML report row along with the HTM_TEXT payload itself. Because contract printing is version-aware, the view preserves both major and minor version identifiers so downstream consumers can select the precise rendition of a contract document.
Underlying Base Objects
The view is defined over OKC_REPORT_HTM, referenced in the ETRM metadata as a synonym within the APPS schema. The defining query selects columns directly from that base object, applying a single filter predicate:
- Base object: OKC_REPORT_HTM (SYNONYM) — stores the HTML presentation generated during contract printing.
- Filter:
WHERE LANGUAGE = USERENV('LANG')— restricts rows to the language of the current session, so each user sees only the HTML rendition matching their session language.
No joins, aggregations, or transformations are applied. The view therefore behaves as a secured, language-scoped projection of the base table, and inherits the base table's ownership, privileges, and data lifecycle. Any DML integrity, indexing, or partitioning characteristics of OKC_REPORT_HTM apply equally to queries executed against the view.
Key Columns
- CHR_ID — Contract header identifier; ties the HTML rendition to a specific contract header record.
- MAJOR_VERSION — Major version number of the contract document, incremented for substantive contract revisions.
- MINOR_VERSION — Minor version number, incremented for lesser revisions such as formatting or wording changes; combined with MAJOR_VERSION it identifies a unique document rendition.
- XST_ID — Status identifier associated with the report rendition.
- SCN_ID — Scenario identifier for the report rendition.
- HTM_TEXT — The HTML presentation (rich text) of the contract as generated for printing.
- CREATED_BY, CREATION_DATE — Standard WHO audit columns recording creation context.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification context.
Common Use Cases and Queries
Typical consumers include contract printing concurrent programs, report previews, and custom integrations that must retrieve the stored HTML for a given contract and version. Because the view is language-filtered, callers should ensure the session language matches the language in which the contract HTML was generated.
Retrieve all HTML renditions for a contract, newest major and minor version first:
SELECT chr_id, major_version, minor_version, htm_text
FROM okc_report_htm_v
WHERE chr_id = :p_chr_id
ORDER BY major_version DESC, minor_version DESC;
Select a specific major/minor version for printing or export:
SELECT htm_text
FROM okc_report_htm_v
WHERE chr_id = :p_chr_id
AND major_version = :p_major
AND minor_version = :p_minor;
Because the view filters on USERENV('LANG'), queries return only rows in the session language; to inspect alternate language renditions, the base table may be queried directly where privileges permit.
-
View: OKC_REPORT_HTM_V 12.2.2
Used in Contract Printing. Keeps html presentation of the contract.
-
View: OKC_REPORT_HTM_V 12.1.1
Used in Contract Printing. Keeps html presentation of the contract.
-
VIEW: APPS.OKC_REPORT_HTM_V 12.2.2
-
VIEW: APPS.OKC_REPORT_HTM_V 12.1.1
-
SYNONYM: APPS.OKC_REPORT_HTM 12.2.2
-
SYNONYM: APPS.OKC_REPORT_HTM 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - OKC Tables and Views 12.2.2
Intersection entity between rules and templates
-
eTRM - OKC Tables and Views 12.2.2
Intersection entity between rules and templates
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.