Results for “parent_delivery_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WSH_DELIVERY_ASSIGNMENTS is a Shipping Execution (WSH) table that stores the association between delivery details and the deliveries to which they are assigned. In Oracle EBS 12.1.1 and 12.2.2, this table governs the linkage between line-level delivery content (WSH_DELIVERY_DETAILS) and the header-level delivery records (WSH_NEW_DELIVERIES), including hierarchical parent-child relationships used during delivery consolidation, splitting, and repacking operations. The table is owned by the WSH schema and holds a status of VALID.
From a Data Vault modeling perspective, the documented foreign-key structure — with references to both WSH_NEW_DELIVERIES and WSH_DELIVERY_DETAILS through multiple columns — suggests this object is best classified heuristically as a link table. It records the resolution of relationships (delivery-to-detail and parent-to-child) rather than functioning as a standalone hub of business entities, and its attribute columns are largely transactional and audit-oriented.
Key Information Stored
The table contains 16 documented columns. The most significant are:
- DELIVERY_ASSIGNMENT_ID — the surrogate primary key, enforced by WSH_DELIVERY_ASSIGNMENTS_PK. It is also the business-key candidate via the unique index WSH_DELIVERY_ASSIGNMENTS_U1. This is the column referenced by dependent tables such as WSH_EXCEPTIONS and WSH_DEL_ASSGN_INTERFACE.
- DELIVERY_ID — foreign key to WSH_NEW_DELIVERIES, identifying the delivery header to which the detail is assigned.
- PARENT_DELIVERY_ID — foreign key to WSH_NEW_DELIVERIES, identifying the parent delivery when a delivery hierarchy exists.
- DELIVERY_DETAIL_ID — foreign key to WSH_DELIVERY_DETAILS, identifying the specific delivery detail line.
- PARENT_DELIVERY_DETAIL_ID — foreign key to WSH_DELIVERY_DETAILS, identifying the parent detail for parent-child detail relationships.
- ACTIVE_FLAG — indicates whether the assignment record is currently active.
- TYPE — classifies the nature of the assignment record.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle audit columns present on this and most EBS transactional tables.
- PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — concurrent program context columns identifying the process that created or updated the row.
All four foreign-key columns (DELIVERY_ID, PARENT_DELIVERY_ID, DELIVERY_DETAIL_ID, PARENT_DELIVERY_DETAIL_ID) are critical for correct hierarchical reconstruction of delivery content. The surrogate key DELIVERY_ASSIGNMENT_ID should be treated as the immutable identifier, while no natural composite business key is separately documented in the provided metadata.
Common Use Cases and Queries
Typical reporting scenarios include tracing which details belong to a delivery, reconciling parent and child deliveries, and auditing delivery reassignments. A representative join pattern is:
- Join WSH_DELIVERY_ASSIGNMENTS.DELIVERY_ID to WSH_NEW_DELIVERIES.DELIVERY_ID to retrieve delivery header context.
- Join WSH_DELIVERY_ASSIGNMENTS.DELIVERY_DETAIL_ID to WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID to obtain line-level content.
- Join to WSH_EXCEPTIONS on DELIVERY_ASSIGNMENT_ID to report exceptions raised against specific assignments.
Analysts use this table to validate that every delivery detail has a corresponding active assignment (ACTIVE_FLAG), to identify orphaned parent references, and to support delivery consolidation and split audits. Filtering on PROGRAM_ID and REQUEST_ID assists in tracing rows created by specific concurrent requests, which is useful for troubleshooting shipping processes.
Related Objects
- WSH_NEW_DELIVERIES — referenced twice through DELIVERY_ID and PARENT_DELIVERY_ID; supplies delivery header and hierarchy information.
- WSH_DELIVERY_DETAILS — referenced through DELIVERY_DETAIL_ID and PARENT_DELIVERY_DETAIL_ID; supplies detail-line and parent-detail context.
- WSH_DEL_ASSGN_INTERFACE — references DELIVERY_ASSIGNMENT_ID; used in open interface processing for assignment data.
- WSH_EXCEPTIONS — references DELIVERY_ASSIGNMENT_ID; stores exceptions tied to individual assignments.
These relationships identify the primary integration points for the table and define the join paths most commonly required for shipping execution reporting and interface troubleshooting.
-
Delivery Assignments
-
Delivery Assignment Interface Table
-
Delivery Assignment Interface Table
-
Delivery Assignments
-
APPS.WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
APPS.JAI_OM_WSH_DELIVERIES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_NEW_DELIVERIES·Explore JA module →
-
eTRM - WSH Tables and Views 12.2.2
Stores hierarchy for zones. Each region component of a zone has a record in this table.
-
eTRM - WSH Tables and Views 12.1.1
Stores hierarchy for zones. Each region component of a zone has a record in this table.