Search Results pa_options_ss




Overview
Explore in AI Chat

Overview

APPS.PA_TEMPLATE_OPTIONS_SS_V is a self-service (SS) reporting view within the Oracle E-Business Suite Projects (PA) module. It exposes the set of Project Options associated with a given project, joined to the descriptive lookup definitions that drive the Projects self-service user interface. The view exists to present, in a single queryable structure, both the options that are already enabled for a project and the options that remain available to it, each annotated with display attributes, licensing status, and drilled-down navigation information.

The view derives its name from the PA_OPTIONS_SS lookup type, which classifies the individual Project Options exposed through the self-service applications. Rather than reading the underlying transaction tables directly, the view resolves option codes to their user-facing meanings and determines whether each option should appear on the interface, making it a convenient source for reporting and for UI-driven queries.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PA_PROJECT_OPTIONS (synonym) — the assignment of options to specific projects; supplies already-enabled options.
  • PA_PROJECTS (synonym) — the project master, used in the second branch to enumerate unassigned options per project.
  • PA_OPTIONS (synonym) — the option catalog, providing hierarchy, level, product, and functional attributes.
  • PA_LOOKUPS (view) — restricted to LOOKUP_TYPE = 'PA_OPTIONS_SS', supplying the display meaning for each option code.
  • FND_FORM_FUNCTIONS (synonym) — outer-joined to provide the web HTML call target for the option.
  • PA_PROJECT_UTILS (package) — check_option_child_exists determines whether a child option exists, driving the drill-down indicator.
  • PA_PROJ_TEMPLATE_SETUP_UTILS (package) — Header_Option resolves the header (top) option for each option.
  • PA_PRODUCT_INSTALL_UTILS (package) — check_function_licensed filters the result to licensed functionality.

Structurally, the view is a UNION ALL of two branches: one for options already assigned to a project, and one for options not yet assigned, using a NOT IN subquery against PA_PROJECT_OPTIONS.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing which Project Options are enabled per project, building self-service menus, and reporting option availability across a portfolio.

  • List all assigned options for a project: 
    SELECT p.option_code, p.meaning, p.displayed_flag
FROM   apps.pa_template_options_ss_v p
WHERE  p.project_id = :project_id
AND    p.displayed_flag = 'Y'
ORDER BY p.sort_order;
  • Find unassigned options available to a project: 
    SELECT option_code, meaning
FROM   apps.pa_template_options_ss_v
WHERE  project_id = :project_id
AND    displayed_flag = 'N';

Queries should respect the filtering already embedded in the view (licensed functions only), and joins to project or option masters may be added for additional descriptive context.