Results for “user_status_name”

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

Overview

PA_PROJ_ASGN_LEG_DET_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Projects (PA) module. It is a lightweight lookup-oriented view whose purpose is to expose the valid system statuses and their corresponding user-facing status names that govern project assignment processing. The view acts as a translation layer between the internal system status codes used by Oracle Projects assignment logic and the descriptive lookup meanings presented to users in forms, reports, and integrations.

The view is marked VALID and is available in both EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it stores no data of its own and is not exposed through standard Oracle Projects concurrent programs; it is primarily consumed by custom reports, extensions, and external integrations that need to validate or display assignment system statuses consistently with the application's own Rules.

Underlying Base Objects

The documented definition of PA_PROJ_ASGN_LEG_DET_V joins two objects: PA_LOOKUPS (itself a view) and PA_PROJECT_STATUSES (exposed to APPS as a synonym). The join condition links a lookup row to a project status row by equating PA_LOOKUPS.LOOKUP_CODE to PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE. The view therefore derives its descriptive text from PA_LOOKUPS.MEANING and its user-facing label from PA_PROJECT_STATUSES.PROJECT_STATUS_NAME, producing a two-column result set of system status name and user status name.

Rows are restricted to system status codes OPEN_ASGMT, STAFFED_ASGMT_CONF, and STAFFED_ASGMT_PROV, and to lookup types STAFFED_ASGMT_SYSTEM_STATUS and OPEN_ASGMT_SYSTEM_STATUS. This constraint keeps the view scoped strictly to the assignment lifecycle rather than to the wider set of project statuses.

Key Columns

• SYSTEM_STATUS_NAME — Maps to PA_LOOKUPS.MEANING. It is the descriptive text associated with the internal assignment system status code, used to render the status in a readable form.
• USER_STATUS_NAME — Maps to PA_PROJECT_STATUSES.PROJECT_STATUS_NAME. It is the user-defined status label configured for the project status record.

The result set is ordered deterministically by a DECODE expression applied to PROJECT_SYSTEM_STATUS_CODE, so that STAFFED_ASGMT_CONF appears first, then STAFFED_ASGMT_PROV, then OPEN_ASGMT, followed by lower-priority codes. Consumers can rely on this ordering without adding their own ORDER BY clause.

Common Use Cases and Queries

The view is typically used to populate assignment status list-of-values sources, to validate status values during data conversion, or to resolve internal codes to display text in custom reporting. Standard usage is a direct, unfiltered select:

• SELECT system_status_name, user_status_name FROM pa_proj_asgn_leg_det_v; — returns the complete assignment status mapping in the view's predefined order.
• SELECT system_status_name FROM pa_proj_asgn_leg_det_v WHERE user_status_name = :status; — resolves the display name supplied by a user back to the system status code.

Because the view contains only lookup-level reference data, it is safe to query at any time and has no meaningful data volume concerns. Custom code should not modify these values, as they are maintained by Oracle Projects setup rather than by the view itself.