Results for “expenditure_category_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_EXPEND_CATEGORIES_RES_V is an Oracle E-Business Suite view owned by the APPS schema in the Projects (PA) product family. Its name follows Oracle's resource-view naming convention: RES_V denotes a resource view used by the Oracle Projects resource list mechanism, the same framework that drives the expenditure type, expenditure category, and organization LOVs throughout the Projects application. The documented description states "10Sc Only," indicating the view is scoped to a single responsibility context rather than exposed as a general-purpose reporting entity. It is catalogued as VALID and is available in both EBS 12.1.1 and 12.2.2.

Functionally, the view presents expenditure categories filtered and flagged according to whether they are treated as labor. It splits the result set into two logical groups and unions them together, producing a normalized list suitable for LOV and resource-selection processing.

Underlying Base Objects

The ETRM metadata documents the following referenced objects:

• PA_EXPENDITURE_CATEGORIES (SYNONYM) — the primary source of EXPENDITURE_CATEGORY_ID, EXPENDITURE_CATEGORY, DESCRIPTION, and the active date range columns START_DATE_ACTIVE and END_DATE_ACTIVE.
• PA_EXPENDITURE_TYPES_RES_V (VIEW) — used in correlated EXISTS / NOT EXISTS subqueries to determine whether any expenditure type linked to the category carries TRACK_AS_LABOR_FLAG = 'Y'.
• PA_GET_RESOURCE (PACKAGE) — supplies PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, which governs date filtering behavior.

The date predicate applies a DECODE that returns START_DATE_ACTIVE when inactive resources are included, otherwise TRUNC(SYSDATE), and tests it against the range from START_DATE_ACTIVE to NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)). This ensures only currently effective categories are returned unless the session is configured to include inactive ones.

Key Columns

• EXPENDITURE_CATEGORY_ID — surrogate key from PA_EXPENDITURE_CATEGORIES; used as the resource identifier.
• EXPENDITURE_CATEGORY — the category name visible in LOVs.
• DESCRIPTION — descriptive text for the category.
• TRACK_AS_LABOR_FLAG — derived flag; hard-coded 'N' in the first branch (no labor-tracking expenditure type) and 'Y' in the second.
• UNIT_OF_MEASURE — NULL in the non-labor branch, 'HOURS' in the labor branch.
• ROLLUP_QUANTITY_FLAG — hard-coded 'N' for non-labor, 'Y' for labor.

Common Use Cases and Queries

This view is typically consumed indirectly by resource LOVs, but can be queried directly for diagnostics and reporting on labor versus non-labor expenditure categories.

• List all labor categories: SELECT EXPENDITURE_CATEGORY FROM PA_EXPEND_CATEGORIES_RES_V WHERE TRACK_AS_LABOR_FLAG = 'Y';
• Find non-labor categories with their descriptions: SELECT EXPENDITURE_CATEGORY_ID, EXPENDITURE_CATEGORY, DESCRIPTION FROM PA_EXPEND_CATEGORIES_RES_V WHERE TRACK_AS_LABOR_FLAG = 'N';
• Validate LOV contents by joining to PA_EXPENDITURE_CATEGORIES on EXPENDITURE_CATEGORY_ID.

Because the "10Sc Only" designation limits its exposure, direct use for custom reporting should be validated against the specific responsibility context in which the resource list is invoked.