Search Results get_line_ship_to_site_use

Overview

ASO_SOURCING_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle Order Capture and Oracle Quoting sourcing engine. In Oracle EBS 12.1.1 and 12.2.2, the ASO (Auto Source Order) schema family provides the runtime logic used to determine how a quote line is sourced, priced, and fulfilled before the quote is converted into an order. ASO_SOURCING_PVT belongs to the "PVT" API classification, meaning it is an internal implementation package rather than a public, supported interface. It is invoked by the public ASO packages and by the sourcing workflow to derive sourcing attribute values for quote headers and quote lines.

The package resolves the contextual data required by sourcing rules: the customer classification, the account and channel through which the transaction is being placed, the relevant ship-to and invoice-to sites, and the quantities, amounts, and dates associated with the document. These values are then consumed by the Order Management sourcing and pricing engines during the Get Sourcing and pricing integrations referenced in its dependency list, including ASO_PRICING_INT, ASO_MAP_QUOTE_ORDER_INT, and QP_ATTR_MAPPING_PUB.

Key Procedures and Functions

The documented package exposes thirty procedures and functions, predominantly implemented as getter routines. The following are representative of the documented set:

• GET_CUSTOMER_CLASS, GET_ACCOUNT_TYPE, GET_SALES_CHANNEL, GET_GSA — return customer classification, account type, sales channel, and General Services Administration flag values used as sourcing and pricing qualifiers.
• GET_CUST_ACCT, GET_SHIP_TO_SITE_USE, GET_LINE_SHIP_TO_SITE_USE, GET_INVOICE_TO_SITE_USE, GET_LINE_INVOICE_SITE_USE — return the customer account and the applicable ship-to and invoice-to site use identifiers, at both header and line level.
• GET_SHIP_TO_PARTY_SITE, GET_LINE_SHIP_PARTY_SITE, GET_INVOICE_TO_PARTY_SITE, GET_LINE_INVOICE_PARTY_SITE — return the corresponding party site identifiers for header and line contexts.
• GET_QUOTE_QTY, GET_QUOTE_AMOUNT, GET_SHIPPABLE_FLAG — return quote quantity, quote amount, and the shippable indicator used in sourcing decisions.
• GET_CUST_PO, GET_LINE_CUST_PO, GET_REQUEST_DATE, GET_LINE_REQUEST_DATE — return the customer purchase order number and requested date at header and line level.

All routines operate on the quote context passed by the calling public API; parameter lists are not part of the documented metadata.

Tables Accessed

The package reads and writes the core Order Capture tables through APPS synonyms. Quote data is taken from ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, and ASO_QUOTE_LINE_DETAILS. Line relationship and shipment information is sourced from ASO_LINE_RELATIONSHIPS, ASO_SHIPMENTS, and ASO_PAYMENTS. Customer data is drawn from HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_CUSTOMER_PROFILES. Item defaults come from MTL_SYSTEM_ITEMS_B and the ASO_I_ITEMS_V view, while OE_ORDER_LINES_ALL provides the order line context during quote-to-order mapping. Utilities FND_API, FND_DATE, FND_NUMBER, and ASO_DEBUG_PUB are used for error handling, date and number conversion, and debug output.

Usage Notes

Because ASO_SOURCING_PVT is a PVT package, it is not intended for direct invocation by customers. It is called internally from the Oracle Quoting and Order Capture forms and from the sourcing and pricing integration workflows during quote entry and quote-to-order conversion. The dependency metadata confirms that no other database object references it, and it is not referenced by any external package, reinforcing its internal role. Custom code should call the corresponding public ASO APIs rather than this package. Debugging can be enabled through ASO_DEBUG_PUB when tracing sourcing attribute derivation.