Search Results proc_basic

Overview

AMW_EXPORT_KEY_ACC_V is a database view owned by the APPS schema in Oracle E-Business Suite, defined within the AMW – Internal Controls Manager product module. Its purpose is to expose the association between business processes (and their hierarchical placements) and the natural accounts registered as financial key accounts in the Internal Controls Manager repository, in a flattened form suitable for export and reporting. The view returns a context column (ACC_CTX), a parent-process identifier (ACC_PPID), a process display name, name information, natural account details, and a fixed party identifier, so that downstream consumers can reconcile process definitions against the accounts that participate in key controls.

The view is relevant to the term "acc_ppid," which is exposed directly as the ACC_PPID column. This column carries the process identifier used to link exported account rows back to a process definition, and it takes the sentinel value -1 in the first branch of the view definition, marking the top-level or reserved hierarchy placement.

Underlying Base Objects

The view is defined over five base objects, drawn from the AMW schema. Although the repository metadata documents no referenced base objects explicitly, the view text identifies them clearly:

• AMW_PROCESS_VL — the process view (base plus translation), supplying PROCESS_ID and DISPLAY_NAME.
• AMW_ACCT_ASSOCIATIONS — the association table linking objects (such as processes) to natural accounts, filtered on OBJECT_TYPE = 'PROCESS'.
• AMW_FIN_KEY_ACCOUNTS_B — the base financial key account table, supplying the natural account value and identifier.
• AMW_FIN_KEY_ACCOUNTS_TL — the translation table for key accounts, supplying the localized account name.
• AMW_PROC_HIERARCHY_DENORM — the denormalized process hierarchy, used to determine hierarchy placement (UP_DOWN_IND = 'D', HIERARCHY_TYPE = 'L').

Each of the three UNION ALL branches joins the same tables, differing primarily in how the hierarchy is filtered and in the ACC_CTX value assigned to the resulting rows.

Key Columns

• ACC_CTX — the context discriminator for the row, with values 'PROC_HIER' and 'PROC_BASIC' appearing in the documented excerpt.
• ACC_PPID — the process parent/primary identifier, populated from APHD.PROCESS_ID or APV.PROCESS_ID depending on the branch; the sentinel value -100 does not apply here, but -1 is used for the top hierarchy placement.
• PDN — the process display name, sourced from AMW_PROCESS_VL.
• ANM — the translated account name from AMW_FIN_KEY_ACCOUNTS_TL.
• NATURAL_ACCOUNT_VALUE and NATURAL_ACCOUNT_ID — the account identifier and its stored value.
• PARTY_ID — a constant –100, indicating that no operational party is associated in this projection.

Common Use Cases and Queries

Typical use is to export the mapping of processes to key accounts, or to inspect how processes are placed within the hierarchy for control reporting. A representative query is:

SELECT acc_ctx, acc_ppid, pdn, anm, natural_account_value
FROM apps.amw_export_key_acc_v
WHERE acc_ppid = :process_id;

Analysts may also aggregate to determine account coverage by context. The ACC_PPID column is the primary filter when tracing a specific process, since it provides the direct link between the process definition and its associated financial key accounts.