Search Results object_creation_date

Overview

AS_ACCESSES_ALL is a validity-filtered view owned by the APPS schema in Oracle E-Business Suite, classified under the AS – Sales Foundation product family. It exposes the operational contents of the sales access repository, which records the assignment of salespersons, partners, and sales teams to customers, addresses, leads, and salesforce entities. The view carries a status of VALID in the EBS data dictionary and is available in both 12.1.1 and 12.2.2 releases.

The defining characteristic of the view is its predicate: it selects only rows from the underlying base object where DELETE_FLAG IS NULL. Conceptually, the table AS_ACCESSES_ALL_ALL holds the complete access history, including logically deleted records retained for audit and multi-organization reasons, while AS_ACCESSES_ALL presents only the currently active access assignments. For reporting, integration, and application-tier queries, AS_ACCESSES_ALL is therefore the appropriate entry point because the deleted-row filtering is applied transparently.

Underlying Base Objects

Per the documented ETRM metadata, AS_ACCESSES_ALL is defined over a single referenced base object: AS_ACCESSES_ALL_ALL, exposed within the APPS schema as a synonym. The naming convention of the base table (the _ALL suffix) indicates that it is a multi-organization (partitioned by ORG_ID) table, and the view preserves the ORG_ID column so that operating unit context is retained at the view level. Because the view is a simple projection with a WHERE clause rather than a join, it is generally updateable for the columns that map directly to the base table, subject to the usual restrictions on views with filtering predicates.

Key Columns

AS_ACCESSES_ALL exposes the complete column list of AS_ACCESSES_ALL_ALL. The primary key is ACCESS_ID, accompanied by standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) and concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).

• ACCESS_TYPE, SALESFORCE_ROLE_CODE, SALESFORCE_RELATIONSHIP_CODE – classify the nature of the assignment and the role played by the salesperson within the salesforce.
• CUSTOMER_ID, ADDRESS_ID, SALESFORCE_ID, PERSON_ID, SALES_GROUP_ID, SALES_LEAD_ID, LEAD_ID – identify the selling entity and the customer, site, lead, or group to which access is granted.
• PARTNER_CUSTOMER_ID, PARTNER_ADDRESS_ID, PARTNER_CONT_PARTY_ID – support partner and channel-management scenarios.
• FREEZE_FLAG, FREEZE_DATE, REASSIGN_FLAG, REASSIGN_REASON, REASSIGN_REQUESTED_PERSON_ID, REASSIGN_REQUEST_DATE, TEAM_LEADER_FLAG, OWNER_FLAG – govern team administration, ownership, and the reassignment workflow.
• ORG_ID, SECURITY_GROUP_ID – enforce multi-organization and security-group access control.
• DOWNLOADABLE_FLAG, INTERNAL_UPDATE_ACCESS, PRM_KEEP_FLAG, OPEN_FLAG, CREATED_BY_TAP_FLAG, LEAD_RANK_SCORE – influence territory assignment, partner relationship management, and lead prioritization.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 – provide the standard DFF extensibility block.
• OBJECT_CREATION_DATE and OBJECT_VERSION_NUMBER – support integration change detection and optimistic locking.

Common Use Cases and Queries

Typical usage includes territory and quota reporting, sales-team visibility analysis, partner access audits, lead-routing validation, and integration extracts for CRM or downstream analytics. Because the view automatically excludes soft-deleted records, most operational queries should select from AS_ACCESSES_ALL rather than the base table.

• List active salespeople assigned to a customer or site: SELECT access_id, person_id, salesforce_id, access_type, salesforce_role_code FROM as_accesses_all WHERE customer_id = :p_customer_id;
• Identify frozen assignments in an operating unit: SELECT access_id, customer_id, person_id, freeze_date FROM as_accesses_all WHERE org_id = :p_org_id AND freeze_flag = 'Y';
• Report open, non-frozen team assignments for a salesforce: SELECT access_id, person_id, team_leader_flag, owner_flag FROM as_accesses_all WHERE salesforce_id = :p_salesforce_id AND open_flag = 'Y';
• Incremental integration extract: SELECT * FROM as_accesses_all WHERE last_update_date >= :p_since;

When soft-deleted history is required, query AS_ACCESSES_ALL_ALL directly and filter on DELETE_FLAG. All queries should respect ORG_ID and security-group policies where applicable.