Results for “uom_code”
47 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_CURRENCY_UOM_V is a database view owned by the APPS schema within the Oracle E-Business Suite Projects (PA) module. It is classified in ETRM as VALID and is documented across both Oracle EBS 12.1.1 and 12.2.2 releases. Per its official description, the view is used to configure the currency unit of measure. In practice, it exposes a filtered and derived subset of the PA_LOOKUPS view, restricting the underlying lookup data to a single lookup type and presenting an analytical flag that identifies which records correspond to a monetary (currency) unit of measure.
Because it is a view rather than a base table, PA_CURRENCY_UOM_V does not store data. Instead, it provides a stable, read-only interface that reporting, extensions, and integration layers can query without needing to know the internal filtering logic applied to PA_LOOKUPS. For functional and technical consultants, it serves as the authoritative source for the list of valid unit-of-measure lookup codes and meanings relevant to currency handling in Project Accounting.
Underlying Base Objects
The view is defined over a single documented base object: PA_LOOKUPS, which is itself a view in the APPS schema. PA_LOOKUPS supplies the underlying lookup rows from which PA_CURRENCY_UOM_V derives its content. The view applies a WHERE predicate of LOOKUP_TYPE = 'UNIT', so only lookup codes belonging to the 'UNIT' lookup type are surfaced. It further computes a derived column, CURRENCY_UOM_FLAG, using a DECODE expression that returns 'Y' when the upper-cased MEANING equals 'DOLLARS' and 'N' otherwise. This means the currency designation is inferred from the lookup meaning rather than stored as a separate attribute, a design detail worth noting when the lookup meaning is customized.
Key Columns
- UOM_MEANING — The descriptive meaning of the unit-of-measure lookup, sourced from the MEANING column of PA_LOOKUPS. It provides the human-readable label for the unit.
- UOM_CODE — The lookup code identifying the unit of measure, sourced from LOOKUP_CODE. This is the value typically referenced by other project-related records.
- CURRENCY_UOM_FLAG — A derived indicator computed as DECODE(UPPER(MEANING),'DOLLARS','Y','N'). A value of 'Y' identifies the entry as a currency (Dollars) unit of measure; 'N' indicates a non-currency unit.
Note that the documented view text aliases MEANING and LOOKUP_CODE into the UOM_MEANING and UOM_CODE column names exposed to consumers.
Common Use Cases and Queries
Typical scenarios include validating currency unit-of-measure values in project setup, populating value sets or LOVs for concurrent programs and forms, and joining to project records that reference a UOM code. A frequently issued query retrieves all currency-relevant units:
SELECT uom_code, uom_meaning, currency_uom_flag
FROM apps.pa_currency_uom_v
WHERE currency_uom_flag = 'Y';
A broader listing returns every unit-of-measure lookup:
SELECT uom_code, uom_meaning
FROM apps.pa_currency_uom_v
ORDER BY uom_meaning;
To confirm whether a specific code exists, filter on UOM_CODE:
SELECT uom_code, uom_meaning
FROM apps.pa_currency_uom_v
WHERE uom_code = :p_uom_code;
Because the currency flag depends on the literal meaning 'DOLLARS', implementations that customize lookup meanings should verify the derived flag still returns the expected results. All queries should be executed with the appropriate APPS access grants, as the view resides in the APPS schema.
-
View: PA_CURRENCY_UOM_V 12.1.1
View used to configure currency unit of measure
-
View: PA_CURRENCY_UOM_V 12.2.2
View used to configure currency unit of measure
-
Customizable view for expenditure types used in Self Service Time application.
APPS.PA_ONLINE_EXPENDITURE_TYPES_V·↳ PA_EXPENDITURE_TYPES_EXPEND_V·Explore PA module →
-
10SC Only
APPS.PA_EXPENDITURE_TYPES_EXPEND_V·↳ PA_EXPENDITURE_TYPES·↳ PA_EXPEND_TYP_SYS_LINKS·↳ PA_LOOKUPS·Explore PA module →
-
Customizable view for expenditure types used in Self Service Time application.
APPS.PA_ONLINE_EXPENDITURE_TYPES_V·↳ PA_EXPENDITURE_TYPES_EXPEND_V·Explore PA module →
-
10SC Only
APPS.PA_EXPENDITURE_TYPES_EXPEND_V·↳ PA_EXPENDITURE_TYPES·↳ PA_EXPEND_TYP_SYS_LINKS·↳ PA_LOOKUPS·Explore PA module →
-
PA_TASK_TYPES stores implementation-defined classifications of task.
-
View: PA_TASK_PROG_HIST_V 12.2.2
APPS.PA_TASK_PROG_HIST_V·↳ FND_GLOBAL·↳ HZ_PARTIES·↳ PA_LATEST_PUB_STRUC_TASKS_V·Explore PA module →
-
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
-
PA_TASK_TYPES stores implementation-defined classifications of task.
-
View: PA_EVENTS_AMG_V 12.1.1
This view is based on pa_events table, and stores events assigned to a task that generate revenue and/or billing activities that are not directly associated to the cost and revenue generated by expenditure items.
-
View: PA_EVENTS_AMG_V 12.2.2
This view is based on pa_events table, and stores events assigned to a task that generate revenue and/or billing activities that are not directly associated to the cost and revenue generated by expenditure items.
-
View: PA_TASK_PROG_HIST_V 12.1.1
APPS.PA_TASK_PROG_HIST_V·↳ FND_GLOBAL·↳ HZ_PARTIES·↳ PA_LATEST_PUB_STRUC_TASKS_V·Explore PA module →
-
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
-
10 Sc only
APPS.PA_EVENTS_DELIVERABLE_V·↳ PA_EVENTS·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PROJECTS·Explore PA module →
-
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
-
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
-
APPS.PA_ASSIGNMENT_PROGRESS_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
Commitment transactions for summarized project summary commitment amounts
-
View: PA_EVENTS_MRC_V2 12.1.1
Single currency view
APPS.PA_EVENTS_MRC_V2·↳ PA_EVENTS·↳ PA_MC_EVENTS·Explore PA module →
-
View: PA_EVENTS_MRC_V2 12.2.2
Single currency view
APPS.PA_EVENTS_MRC_V2·↳ PA_EVENTS·↳ PA_MC_EVENTS·Explore PA module →
-
View: PA_EVENTS_V 12.1.1
10 Sc only
APPS.PA_EVENTS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_CONVERSION_TYPES_V·↳ PA_EVENTS·Explore PA module →
-
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
-
View: PA_EVENTS_V 12.2.2
10 Sc only
APPS.PA_EVENTS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_CONVERSION_TYPES_V·↳ PA_EVENTS·Explore PA module →
-
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
-
Pa_Events_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
APPS.PA_ASSIGNMENT_PROGRESS_V·↳ PA_CURRENCY·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
Pa_Events_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
10 Sc only
APPS.PA_EVENTS_DELIVERABLE_V·↳ PA_EVENTS·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PROJECTS·Explore PA module →
-
APPS.PA_ASSIGNMENT_PROG_HIST_V·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·↳ PA_PROJECTS_ALL·Explore PA module →
-
APPS.PA_ASSIGNMENT_PROG_HIST_V·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·↳ PA_PROJECTS_ALL·Explore PA module →
-
This view provides progress data for task assignments.
APPS.PA_TASK_ASSIGNMENTS_AMG_V·↳ PA_EXPENDITURES_UTILS·↳ PA_FIN_PLAN_UTILS·↳ PA_LOOKUPS·Explore PA module →
-
View: PA_COMMITMENT_TXNS_V 12.1.1
A view of all oustanding project-related commitment costs.
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ HR_GENERAL·Explore PA module →
-
APPS.PA_TASKS_ASSIGNS_PROGRESS_V·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·↳ PA_PROGRESS_UTILS·Explore PA module →
-
View: PA_EVENTS_MRC_V 12.1.1
Single currency view
APPS.PA_EVENTS_MRC_V·↳ PA_EVENTS·↳ PA_MC_EVENTS·Explore PA module →
-
View: PA_EVENTS_MRC_V 12.2.2
Single currency view
APPS.PA_EVENTS_MRC_V·↳ PA_EVENTS·↳ PA_MC_EVENTS·Explore PA module →
-
View: PA_COMMITMENTS_V 12.2.2
A view of all oustanding project-related commitment costs
APPS.PA_COMMITMENTS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ JAI_PA_COSTING_PKG·Explore PA module →
-
View: PA_COMMITMENT_TXNS_V 12.2.2
A view of all oustanding project-related commitment costs.
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ FND_PROFILE·Explore PA module →
-
APPS.PA_TASKS_ASSIGNS_PROGRESS_V·↳ PA_ALTERNATE_TASK_PVT·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_TASK_PROGRESS_V 12.1.1
APPS.PA_TASK_PROGRESS_V·↳ PA_CONTROL_ITEMS_UTILS·↳ PA_LOOKUPS·↳ PA_PERCENT_COMPLETES·Explore PA module →
-
Commitment transactions for summarized project summary commitment amounts
-
View: PA_TASK_PROGRESS_V 12.2.2
APPS.PA_TASK_PROGRESS_V·↳ PA_CONTROL_ITEMS_UTILS·↳ PA_LOOKUPS·↳ PA_PERCENT_COMPLETES·Explore PA module →
-
Entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items
-
Entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items
-
This view provides progress data for task assignments.
APPS.PA_TASK_ASSIGNMENTS_AMG_V·↳ PA_EXPENDITURES_UTILS·↳ PA_FIN_PLAN_UTILS·↳ PA_LOOKUPS·Explore PA module →
-
View: PA_EVENTS_FORMS_MRC_V 12.1.1
10 Sc only
Not implemented in this database·Explore PA module →
-
View: PA_EVENTS_FORMS_MRC_V 12.2.2
10 Sc only
Not implemented in this database·Explore PA module →