Search Results prnt_code

Overview

The view APPS.AMW_EXPORT_PROCESS_V is an Oracle E-Business Suite database object belonging to the Application Management Workbench (AMW) module, which forms part of the ETRM (Enterprise Transaction and Records Management) toolset delivered with Oracle EBS 12.1.1 and 12.2.2. Its principal role is to present a flattened, export-ready representation of process hierarchy data, exposing both child and parent process attributes in a single row so that downstream reporting, integration, and extract routines can consume the information without performing recursive joins at runtime.

Unlike base tables that store raw transactional values, this view resolves numerous descriptive attributes by joining coded process flags and statuses against the AMW_LOOKUPS table, returning human-readable meanings in place of internal lookup codes. This makes the view particularly well suited to interface extracts, data migration, and analytical reporting where consumers expect deciphered values rather than raw identifiers.

Underlying Base Objects

The view text is defined over the AMW process hierarchy structures. The documented source references a hierarchical alias ALHRV (an AMW lookup or hierarchy view supplying child_order_number, child_process_id, child_process_code, child_display_name, parent_process_id, parent_process_code, and parent_display_name), and joins outward to AMW_PROCESS for process type and control activity attributes, and to AMW_LOOKUPS for meaning resolution.

The ETRM 12.2.2 metadata documents no explicit base tables, so the dependency mapping is inferred from the embedded SQL. In practice the view is anchored on the AMW process hierarchy data and its supporting lookups, with inline correlated subqueries handling code-to-meaning translation for process type, category, approval status, and the various process flags.

Key Columns

• SEQ_NUM – child order number, providing sequence positioning within the parent process.
• PRC_ID / PRC_CODE / PRC_NAME – child process identifier, code, and display name.
• PRNT_ID / IMM_PRNT_ID / PRNT_CODE / PRNT_NAME – parent process identifier, immediate parent, and parent code/name, enabling hierarchical traceability.
• PRC_STS – decoded approval status resolved from the AMW_PROCESS_APPROVAL_STATUS lookup.
• PRC_TYPE – decoded process type derived from AMW_PROCESS and AMW_PROCESS_TYPE.
• PRC_CAT – decoded process category from AMW_PROCESS_CATEGORY.
• PRC_SIG / PRC_STD – decoded significant-process and standard-process flags.
• REVISE – a revision-enabled indicator sourced from the AMW_REVISE_PROCESS_FLAG lookup.

Common Use Cases and Queries

Because the view delivers decoded attribute values and parent/child relationships simultaneously, it is frequently used for export extracts and hierarchy validation reports. A representative query enumerating all active child processes with their decoded status and type is shown below:

SELECT seq_num, prc_id, prc_code, prc_name,
       prnt_id, prnt_code, prnt_name,
       prc_sts, prc_type, prc_cat
FROM   apps.amw_export_process_v
WHERE  prc_sts IS NOT NULL
ORDER  BY prnt_id, seq_num;

Typical scenarios include generating audit reconciliation extracts of process hierarchies, populating external workflow or GRC tools, building revision-controlled process listings, and validating that significant and standard process designations are correctly assigned. When querying in EBS 12.1.1 or 12.2.2, users should ensure the APPS schema responsibilities and AMW access grants are in place, since the view resolves lookup meanings against AMW_LOOKUPS with active-date filtering that reflects the current system date.