Search Results aso_shipments

Overview

The ASO_SHIPMENTS table is a core data object within the Oracle E-Business Suite (EBS) Order Capture module (ASO). It serves as the central repository for storing shipping information associated with sales quotes. A quote can have multiple shipment records, as this table supports the definition of shipping details at both the overall quote header level and for individual quote lines. This granularity allows for complex quoting scenarios where different items on a single quote may have distinct shipping requirements, destinations, or schedules. The table's integrity is maintained through a primary key and a comprehensive set of foreign key relationships, ensuring data consistency with related quote, customer, and financial entities.

Key Information Stored

The table's primary identifier is the SHIPMENT_ID column. Each record is explicitly linked to either a quote header via QUOTE_HEADER_ID or a specific quote line via QUOTE_LINE_ID, establishing the context for the shipment data. Critical shipping destination information is stored through foreign key references to the Trading Community Architecture (TCA) registry, including SHIP_TO_PARTY_ID (the organization or person), SHIP_TO_PARTY_SITE_ID (the specific address location), and SHIP_TO_CUST_PARTY_ID (the customer account). While the provided metadata focuses on keys, typical columns in such a table would also capture requested ship dates, shipping methods, freight terms, and delivery instructions, forming a complete shipping profile for the quoted item.

Common Use Cases and Queries

This table is essential for processes that require a consolidated view of quote-related shipping logistics. Common use cases include generating shipping manifests or pick slips from approved quotes, calculating freight charges during the quote process, and validating ship-to address information against customer master data. A frequent reporting query involves joining ASO_SHIPMENTS with quote and customer tables to list all shipping arrangements for a specific quote or customer.

• Retrieve all shipments for a specific quote header: SELECT * FROM ASO_SHIPMENTS WHERE QUOTE_HEADER_ID = <header_id>;
• List quote lines with their associated shipment addresses: SELECT aql.quote_line_id, aql.line_number, hps.party_site_name FROM ASO_QUOTE_LINES_ALL aql, ASO_SHIPMENTS ash, HZ_PARTY_SITES hps WHERE aql.quote_line_id = ash.quote_line_id AND ash.ship_to_party_site_id = hps.party_site_id;

Related Objects

ASO_SHIPMENTS has extensive relationships within the ASO schema and beyond, highlighting its central role. It is a parent table to numerous critical transactional entities. Key child tables include ASO_FREIGHT_CHARGES, ASO_PAYMENTS, ASO_PRICE_ADJUSTMENTS, and ASO_TAX_DETAILS, meaning financial calculations are often anchored to a specific quote shipment record. Its primary foreign key dependencies are on ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL for the quote context, and on HZ_PARTIES and HZ_PARTY_SITES for customer and address data. Other dependent objects, such as CS_LINE_INST_DETAILS for service installations and JAI_CRM_QUOTE_TAXES for region-specific tax calculations, demonstrate its integration with other EBS modules like Service and localized tax engines.