Search Results pa_project_number




Overview
Explore in AI Chat

Overview

APPS.PA_SELECT_TEMPLATE_V is a documented Oracle E-Business Suite view in the Projects (PA) module, owned by the APPS schema and registered under FND Design Data as PA.PA_SELECT_TEMPLATE_V. Its status is VALID, and its view type is classified as Internal, which carries the standard Oracle restriction that the object is provided for Oracle internal use only and is not supported for direct access by customer code except through standard Oracle Applications programs.

The view presents project template information in a denormalized, reporting-friendly form. Rather than forcing consumers to join project template records against operating unit definitions and resource list assignments manually, PA_SELECT_TEMPLATE_V consolidates these into a single query surface. This makes it useful for reporting, data extraction, and integrations that need to enumerate project templates, their associated carrying-out organizations, distribution rules, and default resource lists. Because the view exposes both PA_PROJECT_NUMBER and PA_PROJECT_NAME, it directly answers the common search pattern "pa_project_name" — users seeking a human-readable project or template name alongside its identifier will find PA_PROJECT_NAME on this object.

Underlying Base Objects

Per the ETRM metadata, APPS.PA_SELECT_TEMPLATE_V references the following objects:

The view is not referenced by any other database object, so it functions as a terminal read-only reporting surface rather than as a dependency for other code. The inclusion of MO_GLOBAL indicates the view observes Multi-Org security (MOAC), filtering or deriving rows according to operating unit context.

Key Columns

The view exposes twelve columns of interest:

  • ORG_ID (NUMBER) — the operating unit identifier; drives Multi-Org security.
  • PA_SOURCE_TEMPLATE_ID (NUMBER) — unique identifier for the source project template.
  • PA_PROJECT_NUMBER (VARCHAR2) — the project/template number.
  • PA_PROJECT_NAME (VARCHAR2) — the descriptive project or template name; the primary column matching the user's search term.
  • TEMPLATE_FLAG (VARCHAR2) — indicates whether the record is a template.
  • CREATED_FROM_PROJECT_ID (NUMBER) — the project from which the template was generated.
  • CARRYING_OUT_ORGANIZATION_ID (NUMBER) — the organization responsible for carrying out the template's work.
  • DISTRIBUTION_RULE (VARCHAR2) — the applicable distribution rule.
  • TEMPLATE_START_DATE_ACTIVE / TEMPLATE_END_DATE_ACTIVE (DATE) — the effective active window.
  • DEFAULT_RESOURCE_LIST_ID (NUMBER) — the default resource list associated with the template.
  • OPERATING_UNIT_NAME (VARCHAR2) — the resolved operating unit name.

Common Use Cases and Queries

Typical scenarios include listing available templates for a given operating unit, resolving a template name back to its identifier, and auditing active date ranges or default resource lists. A basic query returning template names and identifiers is:

  • SELECT pa_project_number, pa_project_name, template_flag FROM apps.pa_select_template_v WHERE org_id = :p_org_id;
  • SELECT pa_source_template_id, pa_project_name, operating_unit_name FROM apps.pa_select_template_v WHERE pa_project_name LIKE :p_name%;

Because the view is Internal, direct SQL should be treated as diagnostic rather than supported. For production purposes, Oracle recommends obtaining the same information through standard Projects APIs or concurrent programs.