Results for “oke_fldmx_article_rtree_v”

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

Overview

The view APPS.OKE_FLDMX_ARTICLE_RTREE_V is a reporting and integration object within the Oracle E-Business Suite OKE – Project Contracts module. It presents a hierarchical, tree-structured result set of article subjects that have been assigned to business areas within a flowdown matrix. The view is designed specifically to feed tree-style user interfaces and reports, where each row carries a context identifier, a sort/depth indicator, and a display label, allowing the consuming application to reconstruct a two-level hierarchy of business areas and the article subjects governed under each one.

The name suffix RTREE indicates a "reporting tree" structure. Rather than returning a flat relational set, the view emits synthetic context rows (business areas) plus detail rows (articles) using UNION and literal columns, so a caller can render an expandable tree without additional recursion. The view is owned by the APPS schema and is documented as VALID in the ETRM metadata for both 12.1.1 and 12.2.2.

Underlying Base Objects

The documented base objects referenced by the view are:

• OKE_ARTICLE_SUBJECTS_V (VIEW) – supplies article subject names and codes.
• OKE_BUSINESS_AREAS_V (VIEW) – supplies business area names and codes.
• OKE_FLOWDOWNS (SYNONYM) – the underlying flowdown matrix that associates article subjects with business areas.

The view text joins these three sources on matching ARTICLE_SUBJECT_CODE and BUSINESS_AREA_CODE values. Article subjects only appear in the ARTICLE branch of the UNION when a corresponding flowdown assignment exists, so the view effectively returns the intersection of defined article subjects and active flowdown rows. The business area branch is emitted unconditionally from all rows of OKE_BUSINESS_AREAS_V, ensuring parent nodes are always available for the tree.

Key Columns

• CTX – context discriminator. Holds the literal 'BIZAREA' for parent business-area rows and 'ARTICLE' for child article rows, letting the caller distinguish hierarchy levels.
• INIT_STAT – initialization/status flag. Value -1 marks business-area nodes; value 0 marks article nodes. Callers commonly reference this attribute when searching for tree initialization state.
• DEPTH – the tree depth. 1 for business areas, 2 for article subjects.
• LABEL – the display text. For business areas it is the business area name; for articles it is the article subject name.
• DATA – the underlying key value. Business areas return the business area code; articles return the padded business area code concatenated with the article subject code.
• SORT_KEY – the ordering key. Business areas use the name; articles concatenate the padded business area name and article subject name to keep children ordered under their parent.

Common Use Cases and Queries

The view is typically consumed by flowdown matrix maintenance screens, contract terms setup pages, and reporting that lists which article subjects apply to a given business area. A representative query filtering on initialization status is:

SELECT CTX, DEPTH, LABEL, DATA
FROM   APPS.OKE_FLDMX_ARTICLE_RTREE_V
WHERE  INIT_STAT IN (-1, 0)
ORDER  BY DEPTH, SORT_KEY;

To retrieve only the article subjects assigned to a specific business area:

SELECT LABEL
FROM   APPS.OKE_FLDMX_ARTICLE_RTREE_V
WHERE  CTX = 'ARTICLE'
AND    DATA LIKE 'BA_CODE%';

Because the business-area branch is derived from a UNION, callers should avoid applying restrictive predicates that would eliminate parent nodes, or the resulting tree will lose its hierarchy.