Results for “pqh_realloc_folder_txn_v”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PQH_REALLOC_FOLDER_TXN_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, registered as VALID and shipped as part of the PQH – Public Sector HR product family. Within the ETRM (E-Business Suite Technical Reference Manual) it is catalogued as a "Folder Transactions view," a naming convention that reflects the HR folder and budget pool hierarchy traditionally used by Public Sector HR, position management, and budget reallocation flows. The view presents a filtered, flattened projection of the PQH_BUDGET_POOLS hierarchy, exposing only those pool records that are children of another pool in the tree. Its most frequently referenced attribute — and the entry point most users search for — is the PARENT_FOLDER_ID column, which identifies the parent node to which each folder transaction belongs.
Because it is a view rather than a table, PQH_REALLOC_FOLDER_TXN_V stores no data of its own; it inherits the storage, indexing, and DML characteristics of its single underlying base object. This makes it suitable for reporting, concurrent program queries, and integration extracts, but restricts any write operations to the underlying table.
Underlying Base Objects
The view is defined over exactly one documented base object: PQH_BUDGET_POOLS, accessed through a SYNONYM in the APPS schema. The view text, as captured in the ETRM metadata, is a simple filtered SELECT:
- SELECT POOL_ID, NAME, PARENT_POOL_ID, OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATED_BY
- FROM PQH_BUDGET_POOLS
- WHERE PARENT_POOL_ID IS NOT NULL
The relationship to the base table is therefore a one-to-one, non-aggregated projection with a mandatory predicate. Every row in the view corresponds to a row in PQH_BUDGET_POOLS whose PARENT_POOL_ID is populated. Root-level pools, which have no parent, are excluded by design. This confirms the semantic intent of the view: it isolates non-root nodes in the budget pool hierarchy, i.e., those destinations that participate in a reallocation or folder-move transaction.
Key Columns
The ETRM metadata lists the view columns using the folder-oriented naming convention, which maps as follows to the base table columns selected in the view text:
- TRANSACTION_ID — maps to POOL_ID in PQH_BUDGET_POOLS; the primary identifier of the budget pool/folder node.
- NAME — the descriptive name of the folder or pool.
- PARENT_FOLDER_ID — maps to PARENT_POOL_ID; the identifier of the parent node. This is the column most often searched for and is guaranteed non-null by the view predicate.
- OBJECT_VERSION_NUMBER — optimistic locking/versioning column maintained on the base record.
- CREATION_DATE, CREATED_BY — audit attributes recording initial row creation.
- LAST_UPDATE_LOGIN, LAST_UPDATED_BY — audit attributes recording the most recent change and the login that performed it.
The audit and versioning columns are inherited unchanged from PQH_BUDGET_POOLS, so the view preserves full WHO-column traceability for downstream reconciliation.
Common Use Cases and Queries
Typical uses include reporting on folder hierarchies involved in budget or position reallocation, driving LOV queries for parent-folder selection, and extracting child-node membership for integration or data-conversion scripts. A representative query that finds all child folders under a given parent:
- SELECT transaction_id, name, parent_folder_id FROM apps.pqh_realloc_folder_txn_v WHERE parent_folder_id = :p_parent_id;
- SELECT transaction_id, name, parent_folder_id FROM apps.pqh_realloc_folder_txn_v ORDER BY parent_folder_id, name;
- SELECT parent_folder_id, COUNT(*) FROM apps.pqh_realloc_folder_txn_v GROUP BY parent_folder_id;
Because PARENT_FOLDER_ID is declared NOT NULL by the view definition, callers can safely rely on it as a join key without null-handling logic. All queries must be qualified with the APPS schema or executed from a synonym-granted environment, and no INSERT, UPDATE, or DELETE should ever be issued against this object.
-
Folder Transactions view
APPS.PQH_REALLOC_FOLDER_TXN_V·↳ PQH_BUDGET_POOLS·Explore PQH module →
-
Folder Transactions view
APPS.PQH_REALLOC_FOLDER_TXN_V·↳ PQH_BUDGET_POOLS·Explore PQH module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - PQH Tables and Views 12.1.1
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
eTRM - PQH Tables and Views 12.2.2
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
eTRM - PQH Tables and Views 12.1.1
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PQH Tables and Views 12.2.2
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.