Search Results get_billaddress

Overview

QOT_DEFAULT_PVT is a private PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Quoting (QOT) module. Its central purpose is to supply default values for attributes on a quote, deriving those values from the quoting context, customer records, sales resources, price lists, agreements, and profile options. Functionally, the package acts as a server-side resolution engine: when a quote is created or edited, the Quoting application must pre-populate fields such as the quote address, bill-to and ship-to addresses, payment terms, currency, sales representative, sales group, price list, and order type. Rather than hard-coding this logic in the middle tier or forms layer, Oracle centralizes it in QOT_DEFAULT_PVT so that defaults are computed consistently and remain aligned with EBS data model rules. The package is classified as a private API (PVT), meaning it is intended for internal use by the Quoting product and other Oracle modules, not as a public extension interface. The header comment shows a revision dated 2007, and the object is present across both the 12.1.1 and 12.2.2 releases, maintaining the same general contract. The documented package includes 21 procedures and functions, several of which are overloaded by attribute code, with the search term get_quoteaddress mapping to the GET_QUOTEADDRESS function.

Key Procedures and Functions

The documented routines fall into several logical groups:

• Address defaults: GET_QUOTEADDRESS, GET_BILLADDRESS, and GET_SHIPADDRESS resolve the quote-level, bill-to, and ship-to addresses respectively, reading party site and customer account data to determine the applicable location.
• Contact defaults: GET_QUOTEPHONE returns the telephone number associated with the resolved contact or address.
• Customer and pricing defaults: GET_CUSTACCT_FROM_CUSTPARTY derives the customer account from a party identifier; GET_PRICELIST_FROM_AGREEMENT, GET_PRICELIST_FROM_CUSTACCT, and GET_PRICELIST_FROM_ORDERTYPE establish the applicable price list from agreement, customer account, or order type context; GET_CURRENCY_FROM_PRICELIST and GET_CURRENCY_FROM_PROFILE return the transaction currency.
• Terms and dates: GET_PAYMENTTERM_FROM_AGREEMENT and GET_PAYMENTTERM_FROM_CUSTOMER resolve payment terms, while GET_EXPIRATIONDATE and GET_REQUESTEDDATETYPE return date-oriented defaults.
• Sales resources: GET_SALESREP, GET_SALESGROUP_FROM_SALESREP, and GET_SALESGROUP_FROM_PROFILE determine the sales representative and sales group.
• Operating unit and order type: GET_OPERATINGUNIT, GET_ORDERTYPE, and GET_CONTRACTTEMPLATE supply the operating unit, order type, and contract template defaults.

The visible source shows GET_OPERATINGUNIT calling MO_UTILS.GET_DEFAULT_OU and setting the multi-org policy context via MO_GLOBAL, and GET_ORDERTYPE following a similar SELECT-based pattern.

Tables Accessed

The package references APPS synonyms spanning Quoting, Oracle Receivables (HZ), Service (JTF_RS), and Order Management (OE) schemas:

• ASO_QUOTE_HEADERS_ALL — the base quote header record supplying the current quote context.
• HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_CONTACT_POINTS, HZ_CUST_ACCOUNTS, HZ_CUSTOMER_PROFILES — party, site, contact point (phone), account, and profile data used for address, contact, currency, and terms defaults.
• JTF_RS_SALESREPS_MO_V, JTF_RS_RESOURCE_EXTNS, JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, JTF_RS_GROUP_USAGES, JTF_RS_ROLE_RELATIONS — sales representative and sales group resolution.
• MTL_SYSTEM_ITEMS_B — item-related defaults.
• OE_AGREEMENTS_B — agreement data for price list and payment term defaults.

Usage Notes

QOT_DEFAULT_PVT is invoked primarily from the Oracle Quoting application, including the Quoting forms and its underlying business logic, at the moment a quote or quote line is initialized so that defaultable attributes are populated without user entry. Because it is a private package, it is not published for customer extension; customizations that require the same defaults are generally expected to call the corresponding public APIs (for example, ASO_QUOTE_PUB or the attribute-defaulting layer) rather than calling QOT_DEFAULT_PVT directly. The metadata records zero packages referencing it, indicating that within the documented dependency set no other packaged object calls it, consistent with its role as an internal helper. Developers investigating behavior such as the searched get_quoteaddress function should note that parameters are not documented here and must be confirmed from the package specification. Behavior is largely consistent between 12.1.1 and 12.2.2, though multi-org policy context handling via MO_GLOBAL should be verified when the operating unit default is used in cross-org scenarios.