Results for “open_asgmt”

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

Overview

The view APPS.PA_PROJ_ASGN_LEG_DET_V is a lightweight lookup view in the Oracle E-Business Suite Projects (PA) module. It exposes a decoded list of staffing-related project system statuses, pairing the internal status code with its user-facing meaning and the descriptive status name. The name of the view—"Proj Asgn Leg Det" (project assignment legacy detail)—indicates it was introduced to support assignment staffing flows, and the term open_asgmt referenced in user searches corresponds directly to the OPEN_ASGMT system status code that this view filters upon.

Its role in Oracle EBS reporting and integration is narrow but well defined: it provides a small, pre-filtered reference set of assignment state values that can be joined or displayed in forms, reports, and concurrent programs that deal with project staffing eligibility. Because the view already restricts results to a specific list of lookup types and system status codes, it is commonly used as a pick-list source for assignment status selection rather than as a general status repository.

Underlying Base Objects

The view is defined over two referenced objects owned by APPS:

• PA_LOOKUPS (VIEW) — the public lookup view that resolves lookup codes to their display meanings. In this view it is aliased as LUP, and its MEANING and LOOKUP_CODE columns drive the output and the join.
• PA_PROJECT_STATUSES (SYNONYM) — the public synonym for the project statuses table, aliased as ST, supplying PROJECT_STATUS_NAME and PROJECT_SYSTEM_STATUS_CODE.

The join is a simple equi-join on LUP.LOOKUP_CODE = ST.PROJECT_SYSTEM_STATUS_CODE. Two filter conditions constrain the result set: the project system status code must be one of OPEN_ASGMT, STAFFED_ASGMT_CONF or STAFFED_ASGMT_PROV, and the lookup type must be one of STAFFED_ASGMT_SYSTEM_STATUS or OPEN_ASGMT_SYSTEM_STATUS. Because there is no explicit outer join, only statuses present in both objects are returned.

Key Columns

• MEANING — the user-facing description of the lookup code, taken from PA_LOOKUPS. This is the value typically shown in LOVs and report column headers.
• PROJECT_STATUS_NAME — the descriptive name of the project status from PA_PROJECT_STATUSES, providing the functional label associated with the underlying system status code.

Although the projected list is limited to these two columns, the underlying PROJECT_SYSTEM_STATUS_CODE is referenced in the WHERE, IN, and ORDER BY clauses, and therefore drives the membership and ordering of the returned rows even though it is not selected. Consumers requiring the raw code should query the base objects directly.

Common Use Cases and Queries

Typical scenarios include populating an assignment status LOV, validating that a requested staffing state is legitimate, and generating declarative reporting on available staffing statuses. The predefined ordering uses a DECODE expression to sequence confirmed staffing first, provisional staffing second, then open assignment, and then fallback values.

A representative query is:

• SELECT meaning, project_status_name FROM apps.pa_proj_asgn_leg_det_v; — returns the scoped list of assignment-related statuses for pick-list or validation use.
• Joining the view to a custom staging table on MEANING or PROJECT_STATUS_NAME to confirm that incoming assignment statuses are among the permitted OPEN_ASGMT/staffed set.

Because the view is small and filter-bound, it is inexpensive to query and safe to embed in forms and concurrent programs without additional restriction predicates.