Search Results get_pricelist_from_ordertype

Overview

QOT_DEFAULT_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Quoting (QOT) module of Oracle E-Business Suite. Its business purpose is to resolve default values for quote attributes during quote entry and maintenance. Rather than forcing users to key every field manually, Oracle Quoting calls this package to derive sensible defaults for pricing, address, sales representative, currency, payment terms, and order-related attributes from a hierarchy of sources. These sources include the customer account, customer party, agreement, order type, system profile options, and sales rep assignment.

The package is classified as a private (PVT) API, meaning it is an internal implementation utility. Oracle does not publish it as a public integration interface, and it is not intended to be called directly by customer extensions. It is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling user, and it carries the package name constant G_PKG_NAME defined as QOT_DEFAULT_PVT. The header comment is dated 2006, and the object remains present in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes twenty-one functions. Most follow a common signature pattern: they accept a database object name and an attribute code, and return either a NUMBER identifier or a DATE value. They are grouped functionally as follows:

• Customer and pricing defaults: GET_CUSTACCT_FROM_CUSTPARTY, GET_PRICELIST_FROM_AGREEMENT, GET_PRICELIST_FROM_CUSTACCT, GET_PRICELIST_FROM_ORDERTYPE, GET_CURRENCY_FROM_PRICELIST, and GET_CURRENCY_FROM_PROFILE resolve customer account and price list defaults and the currency that follows from them.
• Sales rep and sales group defaults: GET_SALESREP returns the default sales representative; GET_SALESGROUP_FROM_PROFILE and GET_SALESGROUP_FROM_SALESREP derive the sales group from a profile option or from the assigned sales rep, respectively. This is the function family typically referenced by searches involving "get_salesrep."
• Address and contact defaults: GET_QUOTEADDRESS, GET_QUOTEPHONE, GET_BILLADDRESS, and GET_SHIPADDRESS return quote, billing, and shipping address or phone identifiers.
• Commercial term defaults: GET_PAYMENTTERM_FROM_AGREEMENT and GET_PAYMENTTERM_FROM_CUSTOMER resolve payment terms; GET_EXPIRATIONDATE returns a quote expiration date.
• Order attribute defaults: GET_OPERATINGUNIT, GET_ORDERTYPE, GET_CONTRACTTEMPLATE, and GET_REQUESTEDDATETYPE supply operating unit, order type, contract template, and requested date type defaults.

Tables Accessed

The package reads from Oracle Quoting, Trading Community Architecture (TCA), and Order Management tables through APPS synonyms. ASO_QUOTE_HEADERS_ALL provides quote header context. HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUSTOMER_PROFILES, HZ_CONTACT_POINTS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES supply party, account, profile, contact, and address data. Sales rep and group information is drawn from JTF_RS_SALESREPS_MO_V, JTF_RS_RESOURCE_EXTNS, JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, JTF_RS_GROUP_USAGES, and JTF_RS_ROLE_RELATIONS. Product and agreement data comes from MTL_SYSTEM_ITEMS_B and OE_AGREEMENTS_B.

Usage Notes

QOT_DEFAULT_PVT is invoked internally by Oracle Quoting forms and supporting logic when a quote is created or modified, to populate default attribute values. It is not referenced by other documented packages, and no public interface is exposed. Custom code should not call it directly; developers requiring similar defaulting behavior should use supported Oracle Quoting public APIs or profile options. Because the package relies on TCA and resource model views, correct setup of customer profiles, sales rep assignments, and group memberships is a prerequisite for accurate defaulting.