Search Results op_ordr_typ_b




Overview
Explore in AI Chat

Overview

The OP_ORDR_TYP_B table is a core setup and reference table within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for user-defined order types, which are essential for classifying and managing various transaction orders within the manufacturing and logistics processes. This table provides the foundational data model that enables the segregation and specialized processing of different order categories, such as production orders, transfer orders, or any other custom order types defined by the implementation. Its role is critical for ensuring data integrity and enforcing business rules across the order management lifecycle.

Key Information Stored

The table primarily stores the definitions and descriptive attributes for each unique order type. Based on the provided metadata, the key columns include ORDER_TYPE and ORDER_TYPE_CODE, both of which are defined as unique primary keys. This dual-key structure suggests a design accommodating both a human-readable identifier and a system or short code. While the full column list is not detailed in the excerpt, typical complementary columns would include a description field (e.g., DESCRIPTION), enabled flags, and creation/modification audit columns. The data stored here is static reference data, typically configured during implementation and infrequently changed thereafter.

Common Use Cases and Queries

The primary use case is to validate and categorize order headers. Any transaction creating or querying an order will reference this table to resolve the order type. Common operational and reporting queries include listing all active order types or joining to transaction tables for analysis. A fundamental query pattern is retrieving the description for a specific order header:

  • SELECT hdr.order_number, typ.description FROM gml.op_ordr_hdr hdr JOIN gml.op_ordr_typ_b typ ON hdr.order_type = typ.order_type WHERE hdr.order_number = '12345';

Another standard use case is populating list of values (LOV) in application forms for the ORDER_TYPE field, ensuring users select only valid, pre-defined types.

Related Objects

OP_ORDR_TYP_B has a direct and crucial relationship with the primary order header table, as documented by the foreign key constraint. The OP_ORDR_HDR table references OP_ORDR_TYP_B via its ORDER_TYPE column. This relationship enforces referential integrity, ensuring every order header is assigned a valid type from this master table. The documented primary key OP_ORDR_TYP_B_PK on ORDER_TYPE is the parent key for this relationship. While not listed in the provided excerpt, it is also common for other transactional or setup tables within the GML module to have foreign key relationships to this table to maintain consistent order type classification across the application.