Search Results natural_account_id




Overview
Explore in AI Chat

Overview

APPS.AMW_EXPORT_KEY_ACC_V is a reporting view within the Oracle E-Business Suite Advanced Management Module (AMW), a component historically associated with the Enterprise Territory Management and related accounting intelligence functionality delivered under the ETRM (Enterprise Territory and Resource Management) product family. The view exposes a flattened, presentation-ready projection of accounting key accounts (natural accounts) as they relate to territory or processing hierarchies. Its primary role is to supply downstream consumers—reporting queries, concurrent programs, and export/integration routines—with a denormalized list of natural accounts keyed against process definitions and their hierarchical relationships.

In Oracle EBS 12.1.1 and 12.2.2, the AMW schema objects support the assignment of natural accounts to processes and party definitions. AMW_EXPORT_KEY_ACC_V is intended specifically to feed export operations, where a consolidated and distinct set of account identifiers is required. It is not a base transactional table; it is a read-only projection constructed from the AMW family of tables and views.

Underlying Base Objects

Although the view metadata documentation does not enumerate its referenced base objects, the view's definition references several AMW objects:

The view is a UNION ALL of two similarly structured SELECT statements, distinguished by context and party linkage.

Key Columns

The most relevant columns, and those returned by the user's search term "natural_account_id," include:

  • ACC_CTX — context identifier, hardcoded here as 'PROC_HIER' to denote the process-hierarchy context.
  • ACC_PPID — the parent/processing hierarchy process ID (mapped from APHD.PROCESS_ID).
  • PDN — the process display name.
  • PCD — the process code.
  • ANM — the account name derived from the translated financial key accounts.
  • natural_account_value — the account value string.
  • natural_account_id — the numeric identifier of the natural account, central to account-key resolution.
  • party_id — set to -100 in the first branch and sourced from a role view in the second.
  • naid — a composite concatenated string built from natural_account_value, account_group_id, natural_account_id, and parent_natural_account_id, used as a unique display key.

Common Use Cases and Queries

Typical usage includes extracting the distinct natural accounts associated with a process hierarchy for export, reconciliation, or migration. For example:

SELECT natural_account_id, natural_account_value, ANM, PCD, PDN FROM APPS.AMW_EXPORT_KEY_ACC_V WHERE ACC_CTX = 'PROC_HIER';

To filter by a specific account group or parent account, join to AMW_FIN_KEY_ACCOUNTS_B or filter NAID. The view is commonly queried by concurrent export programs and by analysts tracing which natural accounts map to a given process code (PCD). Because it is a view, no DML should be attempted against it; all maintenance must occur on the underlying AMW base tables.