Search Results pon_auc_items_interface

Overview

The PO_LINE_TYPES_B table is a core reference data object within the Oracle E-Business Suite Purchasing (PO) module. It serves as the master repository for defining and storing all purchasing line types available for use in the procurement process. A line type categorizes the nature of a purchase order or requisition line, such as Goods, Services, Freight, or Tax, which in turn drives system behavior, validation, and accounting. This table is fundamental to the transactional integrity of the Purchasing module, as its primary key (LINE_TYPE_ID) is referenced extensively by requisition, purchase order, and sourcing documents to classify every line item entered into the system.

Key Information Stored

While the provided metadata does not list specific columns beyond the key identifiers, based on its role as a reference table, PO_LINE_TYPES_B typically stores the following critical attributes for each line type. The primary key is LINE_TYPE_ID, a unique internal identifier. The table also stores a user-facing LINE_TYPE_CODE (e.g., 'GOODS', 'SERVICE') and a NAME for the line type. A key functional column is CATEGORY_ID, which is a foreign key to MTL_CATEGORIES_B, linking the line type to a specific item category for automatic line-level categorization. Other common columns include ENABLED_FLAG to control active status, DESCRIPTION, and various creation and update audit columns (CREATION_DATE, CREATED_BY, etc.).

Common Use Cases and Queries

This table is primarily queried for validation, reporting, and data integrity checks. A common use case is to generate a list of all active line types for a setup or configuration review. Developers often join this table to transactional tables to translate internal LINE_TYPE_IDs into meaningful names for reports. For instance, to analyze purchase order lines by their type, a query would join PO_LINES_ALL to PO_LINE_TYPES_B. Sample SQL to list all line types linked to an item category would be: SELECT plt.name, plt.line_type_code, mc.segment1 FROM po_line_types_b plt, mtl_categories_b mc WHERE plt.category_id = mc.category_id AND plt.enabled_flag = 'Y'; Another critical use is during data migrations or interfaces, where external line type codes must be correctly mapped to the internal LINE_TYPE_ID stored in this table.

Related Objects

As evidenced by the foreign key relationships in the metadata, PO_LINE_TYPES_B is a central hub referenced by numerous transactional and setup tables across Purchasing and Sourcing. Key relationships include:

• PO_LINES_ALL: The core purchase order lines table references PO_LINE_TYPES_B via LINE_TYPE_ID.
• PO_REQUISITION_LINES_ALL: Requisition lines reference PO_LINE_TYPES_B via LINE_TYPE_ID.
• PO_SYSTEM_PARAMETERS_ALL: References a default LINE_TYPE_ID for system-wide settings.
• PON_AUCTION_ITEM_PRICES_ALL and PON_AUC_ITEMS_INTERFACE: Sourcing (iSupplier) tables reference the line type.
• PO_REQEXPRESS_LINES_ALL, PO_REQUISITIONS_INTERFACE_ALL, PO_LINES_DRAFT_ALL, and PO_LINES_ARCHIVE_ALL: Various interface and staging tables maintain the LINE_TYPE_ID relationship.
• AHL_OSP_ORDER_LINES: A table from the Complex Maintenance, Repair, and Overhaul (MRO) module references PO_LINE_TYPES_B via PO_LINE_TYPE_ID.
• MTL_CATEGORIES_B: PO_LINE_TYPES_B has a foreign key (CATEGORY_ID) to this Inventory table for item category linkage.

These relationships underscore the table's essential role in ensuring consistent line type classification throughout the procurement lifecycle.