Search Results op_prsl_typ_b




Overview
Explore in AI Chat

Overview

The OP_PRSL_TYP_B table is a foundational data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the master reference table for presales order types, defining the valid codes and descriptions that can be assigned to presales order documents. While historical documentation from earlier releases (11i) indicates it was not utilized, its presence and defined relationships in releases 12.1.1 and 12.2.2 confirm its active role in the application's data model. Its primary function is to enforce data integrity by providing a controlled list of types for presales orders, which are preliminary sales documents used in process manufacturing environments.

Key Information Stored

The table's structure is centered on a concise set of key columns that define the order type. The primary column is PRESALES_ORD_CODE, which acts as the unique identifier or short code for the order type. This column forms the table's primary key. The companion column, PRESALES_ORD_TYPE, typically stores the full descriptive name corresponding to the code. This two-column structure allows for efficient data storage and clear presentation of type descriptions within the application's user interface and reports.

Common Use Cases and Queries

The primary use case for OP_PRSL_TYP_B is to provide a validation list for the order type field when creating or querying presales order headers in the system. It is essential for ensuring consistency in reporting and process flows. Common queries involve joining this table to the header table to retrieve descriptive information. A fundamental reporting query would be:

  • SELECT hdr.ORDER_NUMBER, typ.PRESALES_ORD_TYPE FROM GML.OP_PRSL_HDR hdr INNER JOIN GML.OP_PRSL_TYP_B typ ON hdr.PRESALES_ORD_TYPE = typ.PRESALES_ORD_CODE WHERE hdr.ORDER_DATE > SYSDATE - 30;

Administrative queries might also retrieve the full list of configured types for setup or audit purposes: SELECT PRESALES_ORD_CODE, PRESALES_ORD_TYPE FROM GML.OP_PRSL_TYP_B ORDER BY 1;

Related Objects

OP_PRSL_TYP_B has a direct and critical relationship with the primary transactional table for presales orders. As documented in the ETRM metadata, the table is referenced by a foreign key constraint.

  • OP_PRSL_HDR (Presales Order Header): This is the main transactional table that references OP_PRSL_TYP_B. The column OP_PRSL_HDR.PRESALES_ORD_TYPE is a foreign key that must contain a value present in OP_PRSL_TYP_B.PRESALES_ORD_CODE. This relationship ensures every presales order header is assigned a valid, predefined order type.