Results for “pay_emea_payment_values_v”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view APPS.PAY_EMEA_PAYMENT_VALUES_V is a payroll reporting object within the Oracle E-Business Suite (EBS) Payroll (PAY) module. According to the documented metadata, its stated purpose is to support the online payslip feature, presenting aggregated payment amounts for assignment actions so that payslip pages and related reporting interfaces can display the monetary value processed against specific element input values. The object is classified as a VIEW owned by the APPS schema and is documented as VALID in both the 12.1.1 and 12.2.2 releases. Because it is a view rather than a table, it does not store data; it derives its contents dynamically from the underlying payroll cost and run result tables at query time. This makes it a read-only, reporting-oriented construct intended for consumers such as the online payslip framework, custom reports, and integrations that require EMEA-region payment value extraction without directly navigating the complex normalized structure of payroll run results.
Underlying Base Objects
The view is defined over the following documented base objects within the APPS schema:
- FND_NUMBER (PACKAGE) — used to convert stored character result values into numeric values via the CANONICAL_TO_NUMBER function.
- PAY_ACTION_INTERLOCKS (SYNONYM) — provides the locking association between action context and assignment actions.
- PAY_ASSIGNMENT_ACTIONS (SYNONYM) — the assignment-level processing actions.
- PAY_ELEMENT_TYPES_F (SYNONYM) — element type definitions, including processing priority and effective dating.
- PAY_INPUT_VALUES_F (SYNONYM) — input value definitions filtered to name 'PAY VALUE' with UOM 'M'.
- PAY_PAYROLL_ACTIONS (SYNONYM) — the payroll action header supplying the effective date.
- PAY_RUN_RESULTS (SYNONYM) — run results with status restricted to 'P' and 'PA'.
- PAY_RUN_RESULT_VALUES (SYNONYM) — the stored result value character strings.
Key Columns
- ROW_ID — the ROWID of the element type row, useful as a surrogate identifier.
- ELEMENT_TYPE_ID — identifies the element type whose payment value is reported.
- INPUT_VALUE_ID — identifies the specific input value (here the 'PAY VALUE' input) contributing the amount.
- RESULT_VALUE — the summed numeric payment amount, produced by aggregating canonical numeric conversions of the stored result values.
- PROCESSING_PRIORITY — the element type processing priority, useful for controlling display order.
- ASSIGNMENT_ACTION_ID — derived from the locking action identifier, linking the result to an assignment action.
Common Use Cases and Queries
The primary use case is populating online payslip displays and supplementary payroll reports with consolidated payment amounts. A secondary use is integration extraction for downstream financial or statutory reporting.
SELECT element_type_id,
input_value_id,
result_value,
processing_priority,
assignment_action_id
FROM apps.pay_emea_payment_values_v
WHERE assignment_action_id = :p_assignment_action_id
ORDER BY processing_priority;
To aggregate totals per element type for a reporting period, the view can be joined to payroll action data through the assignment action identifier. Because the view aggregates using SUM and GROUP BY, consumers should expect one row per element type, input value, and locking action combination.
-
APPS.PAY_EMEA_PAYMENT_VALUES_V·↳ FND_NUMBER·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
Used to support online payslip
APPS.PAY_EMEA_PAYMENT_VALUES_V·↳ FND_NUMBER·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
Used to support online payslip
APPS.PAY_EMEA_PAYMNTS_ACTION_INFO_V·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·↳ PAY_ACTION_INTERLOCKS·Explore PAY module →
-
APPS.PAY_EMEA_PAYMNTS_ACTION_INFO_V·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·↳ PAY_ACTION_INTERLOCKS·Explore PAY module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
12.2.2 DBA Data 12.2.2
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.