Results for “equipment_resource_flag”

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

Overview

The PA_NON_LABOR_RESOURCES_RES_V view is a Projects (PA) module database object owned by the APPS schema. Its ETRM documentation describes it succinctly as "10Sc Only," indicating it originated in the Oracle E-Business Suite 10SC (Projects) code line and has been preserved through 12.1.1 and 12.2.2 for backward compatibility, primarily for resource-list and non-labor resource lookups that still depend on the legacy Projects schema. It presents a filtered, active-dated projection of non-labor resources—such as equipment, material, or other non-labor expenditure items—so that forms, reports, and integrations can resolve a valid resource at a given point in time without re-implementing date-effectivity logic.

Unlike its sibling view PA_NON_LABOR_RESOURCES_V, this view carries the RES (resource) designation and exposes the EQUIPMENT_RESOURCE_FLAG column, which is of particular interest to users searching for that term. It is therefore the natural entry point when an end user or developer needs to enumerate non-labor resources together with their equipment classification.

Underlying Base Objects

The view text is defined over a single base table, PA_NON_LABOR_RESOURCES, which is referenced through a synonym. In addition, the WHERE clause invokes the PL/SQL package function PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, which returns a flag ('Y' or otherwise). The effect is:

• If INCLUDE_INACTIVE_RESOURCES resolves to 'Y', the view returns all rows regardless of the current date, comparing START_DATE_ACTIVE against itself.
• Otherwise, it restricts output to resources where TRUNC(SYSDATE) falls between START_DATE_ACTIVE and NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)), so only currently effective resources are returned.

The view performs no joins to lookup tables or primary-key tables; it is a straight column projection with a date-effectivity predicate, making it inexpensive to query.

Key Columns

• NON_LABOR_RESOURCE_ID – Primary key of the underlying non-labor resource record.
• NON_LABOR_RESOURCE – The resource name/code used by users and forms.
• DESCRIPTION – Descriptive text for the resource.
• EXPENDITURE_TYPE – The expenditure type associated with the resource.
• TRACK_AS_LABOR_FLAG – Hard-coded to 'N' in the view, confirming non-labor treatment.
• UNIT_OF_MEASURE – Hard-coded to NULL in this legacy view definition (a known quirk of the 10SC-era projection).
• ROLLUP_QUANTITY_FLAG – Hard-coded to 'N'.
• EQUIPMENT_RESOURCE_FLAG – Derived via NVL(EQUIPMENT_RESOURCE_FLAG,'N'); 'Y' identifies the resource as equipment. This is the column most often targeted by users searching for equipment_resource_flag.
• START_DATE_ACTIVE / END_DATE_ACTIVE – Date-effectivity bounds controlling whether a row appears in the result set.

Common Use Cases and Queries

Typical uses include LOV (list of values) population on expenditure-entry forms, validation of resource names prior to expenditure import, and reporting that isolates equipment resources for cost or utilization analysis.

To retrieve all currently active non-labor resources:

SELECT non_labor_resource_id, non_labor_resource, description,
       expenditure_type, equipment_resource_flag
FROM   pa_non_labor_resources_res_v;

To list only equipment items:

SELECT non_labor_resource, description, start_date_active, end_date_active
FROM   pa_non_labor_resources_res_v
WHERE  equipment_resource_flag = 'Y';

Because the view already enforces date effectivity through PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, callers who require inactive resources must set that package variable to 'Y' before querying rather than adding their own date predicates. This behavior distinguishes the view from a direct table query and should be considered whenever the result set appears smaller than expected.