Search Results holdreas_code

Overview

The OP_HOLD_CDS table is a foundational reference table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. Its primary function is to serve as the master repository for sales order hold reason codes. These standardized codes are used to categorize and document the specific reasons why sales orders, quotations, and related documents are placed on a business hold within the system. The table is integral to maintaining data integrity and providing consistent, auditable tracking of order management holds across the application, enabling business process control and operational reporting.

Key Information Stored

The table's structure is designed to define and describe each unique hold reason. The primary key column, HOLDREAS_CODE, stores the unique identifier for each hold reason. While the provided metadata does not list all columns, a typical structure for such a reference table would also include descriptive columns such as a name or description (e.g., HOLDREAS_DESC), an effective date range (START_DATE, END_DATE), and an active indicator (ACTIVE_FLAG). The TEXT_CODE column, referenced by a foreign key from the OP_TEXT_HDR table, indicates an association with a longer, descriptive text block that can provide detailed instructions or notes for the hold reason.

Common Use Cases and Queries

The primary use case is the validation and population of hold reason fields across order management transactions. When a user places an order, quotation header, or line on hold, the application validates the entered code against this table. Common reporting and query scenarios include analyzing hold patterns and generating lists of active codes for user interfaces. Example SQL patterns include:

• Listing all active hold reasons: SELECT holdreas_code, holdreas_desc FROM gml.op_hold_cds WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY 1;
• Finding orders on a specific hold: SELECT ooh.order_number FROM gml.op_ordr_hdr ooh WHERE ooh.holdreas_code = 'CREDIT_CHECK';
• Joining to retrieve descriptive text: SELECT ohc.holdreas_code, oth.meaning FROM gml.op_hold_cds ohc, gml.op_text_hdr oth WHERE ohc.text_code = oth.text_code(+);

Related Objects

OP_HOLD_CDS is centrally linked to several key transactional tables in the GML module, as defined by its foreign key relationships. The HOLDREAS_CODE column is directly referenced by the OP_ORDR_HDR and OP_ORDR_DTL tables for sales order headers and lines, and by the OP_PRSL_HDR and OP_PRSL_DTL tables for quotation (proposal) headers and lines. This design ensures referential integrity for holds applied at both the header and detailed line levels. Furthermore, its relationship with the OP_TEXT_HDR table (via TEXT_CODE) allows for the association of extensive textual explanations or procedures with a specific hold reason code, enriching the informational context available to users.