Results for “aso_quote_accesses”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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.