Results for “gml_gasno_order_text_v”

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

Overview

The GML_GASNO_ORDER_TEXT_V view is a seeded Oracle E-Business Suite database object owned by the APPS schema and defined within the GML (Process Manufacturing Logistics) product family. It is documented as a "Sales Order Header Text view," and its purpose is to expose header-level text associated with process manufacturing sales orders in a denormalized, query-friendly form. In EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration access point for order header text, allowing reports, concurrent programs, and interface routines to retrieve text paragraphs keyed to an order without navigating the underlying text-code relationships directly.

The presence of the LANG_CODE_INT column is significant, as it indicates that the view supports multi-language text retrieval. Users searching for "lang_code_int" are typically investigating how ETRM surfaces language-specific text for sales orders, and this view is the documented object where that column is exposed.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms:

• OP_ORDR_HDR (SYNONYM) — the process manufacturing sales order header table, supplying ORDER_ID and the TEXT_CODE used to join to text data.
• OP_TEXT_TBL (SYNONYM) — the text storage table, supplying the language code, paragraph identifiers, line numbers, and the actual text content.

The join condition correlates the order header's TEXT_CODE with the text table's TEXT_CODE. Filtering clauses restrict output to active, non-deleted orders: OH.DELETE_MARK = 0 excludes logically deleted headers, and OH.ORDER_STATUS != -1 excludes headers flagged with the cancellation/special status value of -1.

Key Columns

• ORDER_ID — Unique identifier of the sales order header; the primary correlation key for reporting.
• LANG_CODE_INT — Internal language code from the text table, identifying the language of the retrieved text. This column underpins multi-language behavior and is the focus of the "lang_code_int" search.
• PARA_CODE_INT — Internal paragraph code, categorizing the text block within the header text structure.
• SUB_PARACODE — Sub-paragraph code, providing finer granularity within a paragraph.
• LINE_NO — Sequence number of the text line, used to order multiple lines of a paragraph.
• TEXT — The actual text content associated with the order header.

Common Use Cases and Queries

Typical scenarios include generating sales order documentation, extracting header remarks for interfaces, and auditing language-specific order text. A standard query selecting order text with its language designation might read:

SELECT order_id,
       lang_code_int,
       para_code_int,
       sub_paracode,
       line_no,
       text
FROM   apps.gml_gasno_order_text_v
WHERE  order_id = :p_order_id
ORDER  BY para_code_int, sub_paracode, line_no;

To isolate text in a specific language, filter on the language column:

SELECT order_id, line_no, text
FROM   apps.gml_gasno_order_text_v
WHERE  lang_code_int = :p_lang_code;

Because the view already excludes deleted and cancelled headers, downstream reports inherit consistent filtering without additional predicates. In integration contexts, the view can be joined back to order header queries on ORDER_ID to append header text to order extracts.