Search Results aso_quote_accesses_u1

Overview

ASO.ASO_QUOTE_ACCESSES is an Oracle EBS table that stores quote sales team information within the ASO (Oracle Sales) schema. It records which sales representatives are granted access to a given quote and, by extension, the level of access they hold. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, characteristics consistent with a transactional detail table that participates in frequent insert and update activity during the quote lifecycle.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is standalone. This suggests the table behaves as an independently maintained entity rather than a pure transaction hub or a dependent satellite keyed to a parent hub. In the ETRM 12.2.2 documented physical schema, the object is deployed with 42 columns. Its design ties each access record to a specific quote number and resource, with security group and territory-related attributes layered on to support access control semantics.

Key Information Stored

The most important columns in ASO_QUOTE_ACCESSES are:

• ACCESS_ID — the surrogate primary key of the table. It is enforced by the unique index ASO_QUOTE_ACCESSES_U1 and uniquely identifies each access row.
• QUOTE_NUMBER — the quote number that the access record belongs to. Together with RESOURCE_ID, it forms the business-key candidate enforced by the unique index ASO_QUOTE_ACCESSES_U2.
• RESOURCE_ID — the sales representative (resource) granted access to the quote. A nonunique index, ASO_QUOTE_ACCESSES_N1, supports lookups by resource.
• RESOURCE_GRP_ID — the group identifier associated with the sales representative, enabling group-level access resolution.
• ROLE_ID — the role assigned to the resource for the quote, which governs what actions the representative may perform.
• UPDATE_ACCESS_FLAG — a flag indicating whether the sales representative has update access to the quote.
• KEEP_FLAG — a flag indicating whether the record will be retained by TAP (Territory Assignment/processing logic).
• TERRITORY_ID and TERRITORY_SOURCE_FLAG — the territory associated with the access record and a flag describing how the territory was derived.
• SECURITY_GROUP_ID — the security group cross-reference, with a foreign key to FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — the optimistic locking counter used by the framework for concurrent update control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard "Who" audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — the concurrent program "Who" columns that track the last program to touch the row.
• ATTRIBUTE1 through ATTRIBUTE20 and ATTRIBUTE_CATEGORY — the descriptive flexfield (DFF) columns reserved for customer-specific extensions.

Common Use Cases and Queries

Typical uses center on sales-team access reporting and integration checks. A common query lists all resources with access to a specific quote:

• SELECT quote_number, resource_id, resource_grp_id, update_access_flag FROM aso.aso_quote_accesses WHERE quote_number = :quote_number;
• Identifying quotes where a specific sales representative can update: filter on resource_id and update_access_flag = 'Y'.
• Reconciliation of security group scoping by joining on security_group_id to FND_SECURITY_GROUPS.
• Audit and concurrency diagnostics using object_version_number and the last_update_date column to detect stale updates.

When building extracts, prefer driving from the unique index ASO_QUOTE_ACCESSES_U2 (QUOTE_NUMBER, RESOURCE_ID) for deterministic single-row retrieval, and use ASO_QUOTE_ACCESSES_U1 when ACCESS_ID is known.

Related Objects

The table's dependencies are primarily defined through its foreign keys and the parent quote structures:

• ASO_QUOTE_HEADERS_ALL — the parent quote header; join on quote_number to resolve quote-level context.
• FND_SECURITY_GROUPS — referenced via the foreign key ASO_QUOTE_ACCESSES.SECURITY_GROUP_ID; join on security_group_id to resolve security group names.
• FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY for audit attribution.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN.
• FND_CONCURRENT_REQUESTS — referenced by REQUEST_ID.
• FND_CONCURRENT_PROGRAM and FND_APPLICATION — referenced by PROGRAM_ID and PROGRAM_APPLICATION_ID respectively.
• ASO_QUOTE_RESOURCES / resource-related ASO views — commonly joined on resource_id to enrich representative details.

These relationships make ASO_QUOTE_ACCESSES the central access-control detail for quotes, linking sales resources, roles, territories, and security groups to individual quotes.