Search Results po_text_hdr




Overview
Explore in AI Chat

Overview

The PO_TEXT_HDR table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module, specifically supporting the OPM (Oracle Process Manufacturing) Purchasing application. It functions as a centralized header text repository, providing a mechanism to store and manage descriptive text entries that can be associated with various purchasing documents and master data entities. Its primary role is to eliminate redundant text storage by allowing multiple transactional and master tables to reference a single, reusable text record via a foreign key. This design enforces data integrity and consistency across the OPM Purchasing landscape in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary key, TEXT_CODE, which serves as the unique identifier for each text entry. While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships imply it stores the descriptive content itself, likely in one or more columns (potentially of type VARCHAR2 or CLOB). The TEXT_CODE is the critical column, acting as the lookup key used by all related tables. The data stored typically includes notes, instructions, or descriptions pertinent to purchase orders, receipts, returns, vendors, and cost management.

Common Use Cases and Queries

A primary use case is retrieving the descriptive text for a specific purchasing document. For instance, to obtain the header text for a purchase order, a query would join PO_ORDR_HDR to PO_TEXT_HDR. Common reporting needs include listing all text entries or finding documents containing specific keywords within their attached notes.

  • Sample Query (Get Text for a Purchase Order Header):
    SELECT poh.po_number, pth.*
    FROM po_ordr_hdr poh,
    po_text_hdr pth
    WHERE poh.text_code = pth.text_code
    AND poh.po_number = '<PO_NUMBER>';
  • Sample Query (Find Unused Text Entries):
    SELECT pth.text_code
    FROM po_text_hdr pth
    WHERE NOT EXISTS (SELECT 1 FROM po_ordr_hdr poh WHERE poh.text_code = pth.text_code)
    AND NOT EXISTS (SELECT 1 FROM po_ordr_dtl pod WHERE pod.text_code = pth.text_code)
    -- Additional NOT EXISTS clauses for other key referencing tables...

Related Objects

PO_TEXT_HDR is a central reference table with extensive foreign key relationships, as documented. The TEXT_CODE column is referenced by numerous OPM Purchasing transactional and master tables, including:

These relationships are enforced via foreign keys from the listed tables' TEXT_CODE columns back to the PO_TEXT_HDR.TEXT_CODE primary key. This network of dependencies underscores the table's critical role in the OPM Purchasing data model.