Search Results op_port_mst




Overview
Explore in AI Chat

Overview

The OP_PORT_MST table is a master data table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for defining and maintaining shipping and receiving port codes used throughout the logistics and order management lifecycle. This table is foundational for managing the physical movement of goods in international and domestic trade, enabling the system to consistently reference specific ports of embarkation (departure) and debarkation (arrival) on key transactional documents. Its role is critical for ensuring accurate shipment planning, freight documentation, and logistics reporting.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships indicate the core data elements. The table's primary key is the PORT_CODE, which uniquely identifies each port record. Each record is also associated with a descriptive text block via the TEXT_CODE foreign key to the OP_TEXT_HDR table, which stores detailed descriptions and names. Furthermore, the ADDR_ID column establishes a foreign key relationship to the SY_ADDR_MST table, linking each port to a standardized physical address record. This structure allows the system to store both the logistical code and the comprehensive address details for each port location.

Common Use Cases and Queries

The primary use case for OP_PORT_MST is the validation and population of port fields on shipping and purchasing documents. When users create a Bill of Lading, Sales Order, Purchase Order Receipt, or a Proposal, the system validates the entered port codes against this master table. A common reporting requirement is to list all active ports with their associated addresses. A typical query would join OP_PORT_MST with SY_ADDR_MST to retrieve the full location details:

  • SELECT pm.port_code, pm.text_code, sa.address_line1, sa.city, sa.state FROM gml.op_port_mst pm, sy.sy_addr_mst sa WHERE pm.addr_id = sa.addr_id;

Another frequent operational query involves identifying all transactional documents associated with a specific port, which is essential for logistics analysis and auditing.

Related Objects

OP_PORT_MST is a referenced parent table for numerous key transactional entities, as evidenced by its foreign key relationships. The primary documented relationships are:

  • OP_TEXT_HDR: Joined via OP_PORT_MST.TEXT_CODE for descriptive text.
  • SY_ADDR_MST: Joined via OP_PORT_MST.ADDR_ID for address details.
  • OP_BILL_LAD: References OP_PORT_MST for both EMBARKATION_PORT and DEBARKATION_PORT.
  • OP_ORDR_DTL, OP_ORDR_HDR: Reference OP_PORT_MST for EMBARKATION_PORT and DEBARKATION_PORT on order lines and headers.
  • OP_PRSL_DTL, OP_PRSL_HDR: Reference OP_PORT_MST for EMBARKATION_PORT and DEBARKATION_PORT on proposal details and headers.
  • PO_RECV_HDR: References OP_PORT_MST for EMBARKATION_PORT and DEBARKATION_PORT on purchase receipt headers.

These relationships underscore the table's integral role in the logistics data model, ensuring referential integrity for port data across sales, shipping, and procurement transactions.