Search Results op_lkbx_mst




Overview
Explore in AI Chat

Overview

The OP_LKBX_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 lockbox codes. In the context of financial operations, a lockbox is a specialized banking service used by companies to expedite the collection and processing of customer payments. This table provides a standardized reference for these codes, enabling their consistent application across various transactional and master data entities within the logistics and order management domains of the application.

Key Information Stored

While the provided metadata does not list specific columns beyond the key, the table's structure can be inferred from its relationships. The primary identifier is the LOCKBOX_CODE column, which is the table's primary key. A critical foreign key column is ADDR_ID, which links to the SY_ADDR_MST table (a generic address master), indicating that each lockbox record is associated with a specific physical or remittance address. Other columns likely include descriptive fields for the lockbox, control flags, and audit information such as creation date and last update date, which are standard in EBS master tables.

Common Use Cases and Queries

The primary use case for OP_LKBX_MST is to support the configuration and reporting of customer payment processing. When setting up a customer (OP_CUST_MST), a default lockbox code can be assigned to streamline remittance instructions. This code then propagates to sales orders (OP_ORDR_HDR, OP_ORDR_DTL) and price lists (OP_PRSL_HDR, OP_PRSL_DTL). A common reporting requirement is to list all configured lockboxes with their associated addresses. A typical query would join OP_LKBX_MST to SY_ADDR_MST to retrieve the complete remittance details:

  • SELECT lkbx.lockbox_code, addr.address_line1, addr.city, addr.state FROM gml.op_lkbx_mst lkbx, sy.sy_addr_mst addr WHERE lkbx.addr_id = addr.addr_id(+);

Another frequent operational query involves identifying all customers assigned to a specific lockbox for communication or audit purposes, joining OP_LKBX_MST to OP_CUST_MST_OPM or OP_CUST_MST.

Related Objects

OP_LKBX_MST is a key reference table with several documented foreign key relationships, primarily in customer and order management entities.

  • SY_ADDR_MST: Linked via OP_LKBX_MST.ADDR_ID. Provides the physical address details for the lockbox.
  • OP_CUST_MST_OPM & OP_CUST_MST: Reference OP_LKBX_MST via their LOCKBOX_CODE column to assign a default remittance lockbox to a customer.
  • OP_ORDR_HDR & OP_ORDR_DTL: Reference OP_LKBX_MST via their LOCKBOX_CODE column, inheriting the lockbox from the customer or allowing transaction-specific overrides.
  • OP_PRSL_HDR & OP_PRSL_DTL: Reference OP_LKBX_MST via their REMIT_TO_LOCKBOX column, specifying the lockbox for payments related to a specific price list agreement.