Search Results receivable_interfaced_status




Overview
Explore in AI Chat

Overview

APPS.WSHBV_PACKED_CONTAINER is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Shipping Execution module. It presents the physical and transactional state of a container — the outer handling unit into which items are packed — at the moment it exists in a packed state. Its FND Design Data reference is OE.WSHBV_PACKED_CONTAINER, and it is registered in the APPLSYS schema-authorized hierarchy as owner APPS with a VALID status. The view serves as a reporting and integration surface: rather than exposing raw transactional tables, it projects a denormalized, query-friendly representation of packing activity for downstream BI, warehouse management, and order-to-cash reporting. In EBS 12.1.1 and 12.2.2 the definition is materially identical.

The name recovered by the user search — "receivable_interfaced_status" — corresponds directly to a documented column in this view, RECEIVABLE_INTERFACED_STATUS, which indicates whether the packed container has been passed to the Receivables interface for invoicing. This makes the view relevant whenever a user needs to know whether a packed container has crossed the Shipping-to-Receivables boundary in the fulfillment flow.

Underlying Base Objects

Per the ETRM dependency section, APPS.WSHBV_PACKED_CONTAINER references two base objects, both accessed via synonyms:

  • WSH_PACKED_CONTAINERS — the primary driving table holding the packing record for each container, including delivery association, container inventory item, packed quantity, sequence hierarchy, weight and UOM, and the Inventory/Receivable interfaced status flags.
  • MTL_SYSTEM_ITEMS — the inventory item master, joined to resolve the container inventory item attributes such as description and other item-level details projected through the view (for example CONTAINER_DESCRIPTION).

The view performs no aggregation beyond joining these two objects; it is a straightforward projection of the container packing record enriched with item metadata. It is not referenced by any other database object, so it functions as a terminal reporting entity rather than an intermediate dependency.

Key Columns

Common Use Cases and Queries

Typical scenarios include tracking containers pending Receivables interface, reconciling packed quantities against delivery lines, and feeding manifesting or BI reports. The following returns packed containers not yet interfaced to Receivables:

  • SELECT container_id, delivery_id, container_inventory_item_id, packed_quantity, receivable_interfaced_status FROM apps.wshbv_packed_container WHERE receivable_interfaced_status = 'N';
  • SELECT delivery_id, COUNT(*) containers, SUM(packed_quantity) units FROM apps.wshbv_packed_container GROUP BY delivery_id;

Because the view exposes both interfaced-status flags alongside the full packing and audit lineage, it is well suited to interface monitoring and shipping reconciliation reporting.