Search Results aso_map_quote_order_int

Overview

The APPS.ASO_MAP_QUOTE_ORDER_INT package is a public PL/SQL API within the Oracle E-Business Suite Order-to-Cash (O2C) flow, classified in the ETRM 12.2.2 repository under the OTHER API classification. Its principal business function is to map data from an Oracle Quoting (ASO) quote structure to the corresponding Order Management (OE) order structure, so that a quote can be converted into a sales order. It serves as the integration bridge between the quoting data model (ASO_QUOTE_HEADERS_ALL, tax details, sales credits, payments and pricing attributes) and the order data model exposed through OE_ORDER_PUB and ASO_QUOTE_PUB. The package is owned by the APPS schema and holds a VALID status. It carries 17 documented procedures/functions and references 14 documented tables via APPS synonyms, and it is itself referenced by six other packages, indicating a central role in quote-to-order processing rather than an isolated utility.

Key Procedures and Functions

The documented interface is composed of one primary entry point and a set of granular mapping helpers that populate specific order attributes from their quote counterparts.

MAP_QUOTE_TO_ORDER — The primary entry point. It drives the overall translation of a quote into an order structure, orchestrating the individual header-, line-, pricing-, and customer-level mapping steps.
GET_ORG_CONTACT, GET_ORG_CONTACT_ROLE, GET_CUST_ACCT_ROLES, GET_ACCT_SITE_USES, GET_CUST_ACCNT_ID — Customer and contact resolution routines. They derive organization contacts, contact roles, customer account roles, account site uses, and the customer account identifier required on the resulting order.
MAP_HEADER_PRICE_ATTR and MAP_HEADER_PRICE_ADJ, MAP_HEADER_PRICE_ADJ_ATTR, MAP_HEADER_PRICE_ADJ_RLTN — Header-level pricing routines that migrate price attributes, price adjustments, adjustment attributes, and adjustment relationships from the quote to the order header.
MAP_LINE_PRICE_ATT, MAP_LINE_PRICE_ADJ, MAP_LINE_PRICE_ADJ_RLTN — Line-level equivalents that carry price attributes, price adjustments, and adjustment relationships onto order lines.
MAP_HEADER_SALES_CREDITS and MAP_LINE_SALES_CREDIT — Map sales credit assignments at header and line level respectively.
MAP_LOT_SERIAL — Maps lot and serial number information associated with quote lines.
MAP_LINE_PAYMENTS — Maps payment details attached to quote lines.

Parameter lists are not documented in the ETRM metadata and should be confirmed against the package specification in the target instance.

Tables Accessed

Documented table access is performed through APPS synonyms.

ASO_QUOTE_HEADERS_ALL, ASO_TAX_DETAILS — Source quote header data and associated tax details used when constructing the order.
HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_ORG_CONTACTS, HZ_PARTIES, HZ_PARTY_SITES, HZ_RELATIONSHIPS — TCA customer model tables consulted by the GET_* routines to resolve the bill-to/ship-to context, contacts, roles, and relationships.
OE_ORDER_SOURCES, OE_TRANSACTION_TYPES_ALL — Order Management setup tables used to validate or supply order source and transaction type information for the generated order.
PLITBLM — The standard PL/SQL integer table type synonym, typically used for internal collection handling.

Usage Notes

This package is invoked as part of the quote-to-order conversion path rather than being called directly by end users. It is referenced by ASO_ORDER_INT, ASO_ATP_INT, ASO_CHECK_TCA_PVT, ASO_CREDIT_CHECK_PVT, ASO_PARTY_INT, and ASO_SOURCING_PVT, which indicates it is exercised during order integration, availability, credit checking, party validation, and sourcing operations. It may be reached from Oracle Quoting and Order Management forms and related concurrent programs that submit quote-to-order conversions. Custom code should treat it as a shared internal API: validate against the package specification for the specific 12.1.1 or 12.2.2 patch level, and prefer the documented public wrappers over direct manipulation of the underlying tables.

PACKAGE: APPS.ASO_MAP_QUOTE_ORDER_INT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_MAP_QUOTE_ORDER_INT, status:VALID,
PACKAGE: APPS.ASO_MAP_QUOTE_ORDER_INT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_MAP_QUOTE_ORDER_INT, status:VALID,
PACKAGE BODY: APPS.ASO_MAP_QUOTE_ORDER_INT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_MAP_QUOTE_ORDER_INT, status:VALID,
PACKAGE BODY: APPS.ASO_MAP_QUOTE_ORDER_INT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_MAP_QUOTE_ORDER_INT, status:VALID,
PACKAGE: APPS.ASO_PARTY_INT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_PARTY_INT, status:VALID,
PACKAGE: APPS.ASO_CHECK_TCA_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_CHECK_TCA_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_SOURCING_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SOURCING_PVT, status:VALID,
SYNONYM: APPS.ASO_TAX_DETAILS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:ASO_TAX_DETAILS, status:VALID,
SYNONYM: APPS.ASO_TAX_DETAILS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:ASO_TAX_DETAILS, status:VALID,
PACKAGE: APPS.ASO_PARTY_INT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_PARTY_INT, status:VALID,
PACKAGE BODY: APPS.ASO_SOURCING_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SOURCING_PVT, status:VALID,
SYNONYM: APPS.JTF_RS_SALESREPS_MO_V 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_RS_SALESREPS_MO_V, status:VALID,
SYNONYM: APPS.JTF_RS_SALESREPS_MO_V 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_RS_SALESREPS_MO_V, status:VALID,
PACKAGE: APPS.ASO_CHECK_TCA_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_CHECK_TCA_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_CHECK_TCA_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_CHECK_TCA_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_CREDIT_CHECK_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_CREDIT_CHECK_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_CHECK_TCA_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_CHECK_TCA_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_CREDIT_CHECK_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_CREDIT_CHECK_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_PARTY_INT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_PARTY_INT, status:VALID,
PACKAGE BODY: APPS.ASO_PARTY_INT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_PARTY_INT, status:VALID,
PACKAGE BODY: APPS.ASO_ATP_INT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_ATP_INT, status:VALID,
PACKAGE BODY: APPS.ASO_ATP_INT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_ATP_INT, status:VALID,
SYNONYM: APPS.OE_ORDER_SOURCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_ORDER_SOURCES, status:VALID,
PACKAGE: APPS.OE_ORDER_SCH_UTIL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_SCH_UTIL, status:VALID,
SYNONYM: APPS.OE_ORDER_SOURCES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_ORDER_SOURCES, status:VALID,
PACKAGE: APPS.OE_ORDER_SCH_UTIL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ORDER_SCH_UTIL, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.ASO_MAP_QUOTE_ORDER_INT 12.1.1
PACKAGE BODY: APPS.ASO_ORDER_INT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_ORDER_INT, status:VALID,
PACKAGE BODY: APPS.ASO_ORDER_INT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_ORDER_INT, status:VALID,
PACKAGE: APPS.ASO_MAP_QUOTE_ORDER_INT 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.ASO_ORDER_INT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_ORDER_INT, status:VALID,
PACKAGE: APPS.ASO_ORDER_INT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_ORDER_INT, status:VALID,
SYNONYM: APPS.OE_TRANSACTION_TYPES_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_TRANSACTION_TYPES_ALL, status:VALID,
PACKAGE: APPS.OE_PROFILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_PROFILE, status:VALID,
PACKAGE: APPS.OE_PROFILE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_PROFILE, status:VALID,
SYNONYM: APPS.OE_TRANSACTION_TYPES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_TRANSACTION_TYPES_ALL, status:VALID,
PACKAGE: APPS.ASO_QUOTE_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_QUOTE_PUB, status:VALID,
VIEW: APPS.CSI_SYSTEMS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CSI.CSI_SYSTEMS_VL, object_name:CSI_SYSTEMS_VL, status:VALID,
PACKAGE: APPS.ASO_QUOTE_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_QUOTE_PUB, status:VALID,
SYNONYM: APPS.ASO_QUOTE_HEADERS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:ASO_QUOTE_HEADERS_ALL, status:VALID,
SYNONYM: APPS.ASO_QUOTE_HEADERS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:ASO_QUOTE_HEADERS_ALL, status:VALID,
PACKAGE: APPS.ASO_DEBUG_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_DEBUG_PUB, status:VALID,
PACKAGE: APPS.ASO_DEBUG_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_DEBUG_PUB, status:VALID,
PACKAGE: APPS.ASO_UTILITY_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_UTILITY_PVT, status:VALID,
PACKAGE: APPS.ASO_UTILITY_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_UTILITY_PVT, status:VALID,
SYNONYM: APPS.HZ_CUST_ACCOUNT_ROLES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_CUST_ACCOUNT_ROLES, status:VALID,