Search Results aso_quote_accesses

Overview

ASO_QUOTE_ACCESSES is a table owned by the ASO schema within the Oracle E-Business Suite Order Capture (ASO) module. It stores quote sales team information — the assignment of sales resources, resource groups, territories, and roles to individual quotes — enabling access control and team-based visibility over quote records. In Oracle EBS 12.1.1 and 12.2.2, this table is a core component of Oracle Quoting and Order Capture functionality, governing which sales representatives and organizations may view, update, or act upon a given quote.

Based on heuristic Data Vault classification mined from its foreign key structure, this object is modeled as a standalone table. In Data Vault terms, it does not naturally resolve to a pure hub, link, or satellite, since it carries its own surrogate key (ACCESS_ID) while also acting as an associative record between quotes and sales resources. Practitioners designing a Data Vault layer should treat this as a candidate link or dependent satellite requiring explicit design decisions around its association semantics.

Key Information Stored

The table contains 42 documented columns. The most significant are:

ACCESS_ID — Surrogate primary key, enforced by unique index ASO_QUOTE_ACCESSES_U1.
QUOTE_NUMBER, RESOURCE_ID — Business-key candidates forming unique index ASO_QUOTE_ACCESSES_U2, linking each access record to a specific quote and sales resource.
RESOURCE_GRP_ID — Resource group associated with the access entry, enabling group-level team assignment.
TERRITORY_ID, TERRITORY_SOURCE_FLAG — Territory assignment and its originating source, supporting territory-based access rules.
ROLE_ID — Sales role granted to the resource for the quote, distinguishing primary owners from supporting team members.
KEEP_FLAG, UPDATE_ACCESS_FLAG, CREATED_BY_TAP_FLAG — Control flags governing retention, update privileges, and territory assignment program (TAP) origin.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org / security group isolation.
OBJECT_VERSION_NUMBER — Optimistic locking column used by the ASO framework during concurrent updates.
ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — DFF (descriptive flexfield) columns for extensibility.
WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID for concurrent program traceability.

Common Use Cases and Queries

Typical usage involves identifying the sales team for a quote, auditing access grants, and validating territory or role assignment. Reporting scenarios include team composition analysis and quote ownership audits.

Retrieve the sales team for a quote: SELECT RESOURCE_ID, RESOURCE_GRP_ID, ROLE_ID, TERRITORY_ID FROM ASO.ASO_QUOTE_ACCESSES WHERE QUOTE_NUMBER = :quote_number;
List all quotes accessible by a resource: SELECT QUOTE_NUMBER FROM ASO.ASO_QUOTE_ACCESSES WHERE RESOURCE_ID = :resource_id AND UPDATE_ACCESS_FLAG = 'Y';
Territory-driven team assignments: filter on TERRITORY_ID and TERRITORY_SOURCE_FLAG to report TAP-derived access.
Audit trail queries joining REQUEST_ID to concurrent program logs for team-recalculation programs.

Related Objects

The table's documented foreign key references FND_SECURITY_GROUPS via SECURITY_GROUP_ID, tying access rows to Oracle Application Object Library security. Functionally, it joins to ASO_QUOTES_HEADERS_ALL on QUOTE_NUMBER, and RESOURCE_ID links to JTF_RS_RESOURCE_EXTNS or PER_ALL_PEOPLE_F for resource identity. RESOURCE_GRP_ID joins to JTF_RS_GROUPS_VL, TERRITORY_ID to JTF_TERR_VL / ASO_TERR_ASSIGNMENTS, and ROLE_ID to JTF_RS_ROLES_VL. The Oracle Quoting APIs (ASO_QUOTE_PUB and the Quote Access public API) maintain this table, while forms such as ASO_QUOTE (Quote) expose the sales team UI that populates these rows.

Table: ASO_QUOTE_ACCESSES 12.2.2
owner:ASO, object_type:TABLE, fnd_design_data:ASO.ASO_QUOTE_ACCESSES, object_name:ASO_QUOTE_ACCESSES, status:VALID, product: ASO - Order Capture , description: Stores quote sales team information , implementation_dba_data: ASO.ASO_QUOTE_ACCESSES ,
Table: ASO_QUOTE_ACCESSES 12.1.1
owner:ASO, object_type:TABLE, fnd_design_data:ASO.ASO_QUOTE_ACCESSES, object_name:ASO_QUOTE_ACCESSES, status:VALID, product: ASO - Order Capture , description: Stores quote sales team information , implementation_dba_data: ASO.ASO_QUOTE_ACCESSES ,
SYNONYM: APPS.ASO_QUOTE_ACCESSES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:ASO_QUOTE_ACCESSES, status:VALID,
SYNONYM: APPS.ASO_QUOTE_ACCESSES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:ASO_QUOTE_ACCESSES, status:VALID,
VIEW: ASO.ASO_QUOTE_ACCESSES# 12.2.2
owner:ASO, object_type:VIEW, object_name:ASO_QUOTE_ACCESSES#, status:VALID,
APPS.AS_GAR_QOT_PUB SQL Statements 12.1.1
APPS.AS_GAR_QOT_PUB SQL Statements 12.2.2
VIEW: APPS.ASO_OA_QUOTE_ACCESSES_V 12.2.2
VIEW: APPS.ASO_OA_QUOTE_ACCESSES_V 12.1.1
APPS.ASO_SECURITY_INT SQL Statements 12.2.2
APPS.ASO_SALES_TEAM_PVT SQL Statements 12.1.1
APPS.ASO_SECURITY_INT SQL Statements 12.1.1
VIEW: ASO.ASO_QUOTE_ACCESSES# 12.2.2
12.2.2 DBA Data 12.2.2
APPS.ASO_SALES_TEAM_PVT SQL Statements 12.2.2
APPS.ASO_SALES_CREDIT_PVT SQL Statements 12.1.1
12.1.1 DBA Data 12.1.1
APPS.ASO_SALES_CREDIT_PVT SQL Statements 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.ASO_SECURITY_INT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SECURITY_INT, status:VALID,
PACKAGE BODY: APPS.ASO_QUOTE_ACCESSES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_QUOTE_ACCESSES_PKG, status:VALID,
PACKAGE BODY: APPS.ASO_QUOTE_ACCESSES_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_QUOTE_ACCESSES_PKG, status:VALID,
PACKAGE BODY: APPS.ASL_EXCEL_UTIL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASL_EXCEL_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.ASL_EXCEL_UTIL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASL_EXCEL_UTIL_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 FND Design Data 12.1.1
PACKAGE BODY: APPS.ASO_SECURITY_INT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SECURITY_INT, status:VALID,
PACKAGE BODY: APPS.ASO_PROJ_COMM_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_PROJ_COMM_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.ASO_PROJ_COMM_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_PROJ_COMM_PVT, status:VALID,
PACKAGE BODY: APPS.AS_GAR_QOT_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AS_GAR_QOT_PUB, status:VALID,
APPS.ASO_QUOTE_ACCESSES_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.AS_GAR_QOT_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AS_GAR_QOT_PUB, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.ASO_SALES_TEAM_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SALES_TEAM_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_SALES_TEAM_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SALES_TEAM_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_SALES_CREDIT_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SALES_CREDIT_PVT, status:VALID,
PACKAGE BODY: APPS.ASO_SALES_CREDIT_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_SALES_CREDIT_PVT, status:VALID,
APPS.ASO_QUOTE_ACCESSES_PKG SQL Statements 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.ASO_OPP_QTE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_OPP_QTE_PUB, status:VALID,
PACKAGE BODY: APPS.ASO_OPP_QTE_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ASO_OPP_QTE_PUB, status:VALID,
PACKAGE BODY: APPS.ASO_QUOTE_ACCESSES_PKG 12.1.1
PACKAGE BODY: APPS.ASO_QUOTE_ACCESSES_PKG 12.2.2
TABLE: ASO.ASO_QUOTE_ACCESSES 12.1.1
owner:ASO, object_type:TABLE, fnd_design_data:ASO.ASO_QUOTE_ACCESSES, object_name:ASO_QUOTE_ACCESSES, status:VALID,
PACKAGE BODY: APPS.AS_GAR_QOT_PUB 12.2.2
PACKAGE BODY: APPS.AS_GAR_QOT_PUB 12.1.1
TABLE: ASO.ASO_QUOTE_ACCESSES 12.2.2
owner:ASO, object_type:TABLE, fnd_design_data:ASO.ASO_QUOTE_ACCESSES, object_name:ASO_QUOTE_ACCESSES, status:VALID,