Search Results psi_column33

Overview

AMW_PROJECTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMW – Internal Controls Manager product. Its stated purpose is to return information about Audit Projects, exposing project definition, status, scheduling, organizational, and geographic attributes in a single denormalized structure. The view is marked VALID in the ETRM metadata and is available in both the 12.1.1 and 12.2.2 releases.

In the context of a user search for public_sector_flag, this column is one of the first attributes projected by the view, appearing immediately after the carrying-out organization name. It identifies whether an audit project pertains to the public sector, and it is paired with a companion PUBLIC_SECTOR column that supplies the descriptive value. Together these columns support segmentation of audit and internal-control projects by sector, which is directly relevant to public-sector audit reporting, risk classification, and organization-specific configuration.

Underlying Base Objects

The documented ETRM metadata for this view lists no referenced base objects. The view text is defined as a projection over an alias PPV, which is not further resolved in the supplied documentation. Because the columns exposed — project number, project type, carrying-out organization, project status, currency, person, customer, and the PSI column family — correspond to Project Management and Projects Foundation structures, the view is functionally an extension of the projects data model, joining project header information with organizational, customer, resource, and geographic attributes. The PPV alias suggests a project-projections source that consolidates Projects-related columns into an audit-friendly shape. Consumers should treat the base tables as undocumented here and rely on the view's public contract rather than assuming a specific join path.

Key Columns

• PROJECT_ID, NAME, SEGMENT1 — project identifier, descriptive name, and project number.
• PUBLIC_SECTOR_FLAG — indicates whether the audit project is public sector; the column central to the user's search.
• PUBLIC_SECTOR — descriptive public-sector classification associated with the flag.
• PROJECT_TYPE, PROJECT_STATUS_CODE, PROJECT_STATUS_NAME — project classification and current lifecycle state.
• CARRYING_OUT_ORGANIZATION_ID / _NAME — the organization responsible for executing the audit project.
• START_DATE, COMPLETION_DATE, CLOSED_DATE, plus actual, early, late, and scheduled date pairs — full schedule and progress tracking.
• DESCRIPTION, PROJECT_VALUE, OPPORTUNITY_VALUE — narrative and monetary context.
• PERSON_ID / PERSON_NAME, CUSTOMER_ID / CUSTOMER_NAME, RESOURCE_ID — ownership and party associations.
• ORG_ID, PROJECT_CURRENCY_CODE, LOCATION_ID, COUNTRY_CODE / _NAME, REGION, CITY — multi-org and geographic attributes.
• PROBABILITY_PERCENTAGE, PROGRESS_STATUS_CODE / _NAME, PROGRESS_ICON — risk and progress indicators.
• PSI_COLUMN4 through PSI_COLUMN33, VIEW_PSI_COLUMNS — descriptive flexfield-style public sector information columns.
• TEMPLATE_FLAG, ENABLED_FLAG, SUMMARY_FLAG, RECORD_VERSION_NUMBER — structural and concurrency-control flags.

Common Use Cases and Queries

The view is typically queried to list audit projects, filter by sector, and drive reporting joins to organizations or statuses. A representative query filtering on the flag of interest:

• SELECT project_id, segment1, name, public_sector, project_status_name FROM apps.amw_projects_v WHERE public_sector_flag = 'Y' AND org_id = :org_id;
• SELECT segment1, name, carrying_out_organization_name, start_date, completion_date FROM apps.amw_projects_v WHERE project_status_code = 'OPEN';
• SELECT country_name, region, COUNT(*) FROM apps.amw_projects_v WHERE public_sector_flag = 'Y' GROUP BY country_name, region;

Because the view carries ORG_ID, all access should be constrained by operating unit in multi-org environments, and reporting should filter on ENABLED_FLAG and TEMPLATE_FLAG to exclude templates and disabled records where appropriate.