Results for “pafv_organizations”

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

Overview

PAFV_ORGANIZATIONS is a read-only view owned by the APPS schema within the Oracle E-Business Suite Projects (PA) module. It consolidates information about organizations used across the Projects application, including project organizations, project expenditure organizations, and event organizations. The view presents a denormalized, user-friendly projection of HR organization records joined to Projects-specific organization usage data, exposing translated names, location details, effective dates, and descriptive flexfield references. Because it resolves foreign keys into descriptive values and embeds translatable display attributes, the view serves as a reporting and integration layer for both concurrent programs and external interfaces that need to enumerate valid Projects organizations without joining the underlying HR and PA tables directly. The view is defined with a WITH READ ONLY clause, ensuring that it cannot be used in DML operations and is safe for query-only consumers such as Oracle Business Intelligence, Discoverer workbooks, and custom reports.

Underlying Base Objects

The view is defined over four documented base objects, all referenced through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — the primary organization table, supplying core attributes such as dates, comments, location, and flexfield references.
• HR_ALL_ORGANIZATION_UNITS_TL — the translated table providing organization names in the user's session language.
• HR_LOCATIONS_ALL_TL — supplies the translated location code used as LOCATION_NAME.
• PA_ALL_ORGANIZATIONS — Projects-specific organization usage records, supplying PA_ORG_USE_TYPE, ORG_ID, and INACTIVE_DATE.

Joins are performed on ORGANIZATION_ID across the HR tables, on BUSINESS_GROUP_ID to the business group organization, and on LANGUAGE to USERENV('LANG') for the translatable columns. A security predicate is applied through the '_SEC:PAA.ORG_ID' construct, enforcing organization-level access restrictions for the querying user.

Key Columns

Prominent columns exposed by the view include:

• BUSINESS_GROUP_NAME and ORGANIZATION_NAME — translated business group and organization names.
• ORGANIZATION_ID, ORG_ID, BUSINESS_GROUP_ID, and LOCATION_ID — primary and foreign key identifiers.
• DATE_FROM, DATE_TO, and INACTIVE_DATE — effective dating for the organization and its Projects usage.
• PA_ORG_USE_TYPE and ORG_USE_TYPE — indicates whether the organization is used as a project organization ('PROJECTS') or an expenditure organization, with ORG_USE_TYPE resolving the lookup meaning.
• SOFT_CODING_KEYFLEX_ID and COST_ALLOCATION_KEYFLEX_ID — references to the soft coding and cost allocation key flexfield structures assigned to the organization.
• LOCATION_NAME, INTERNAL_ADDRESS_LINE, COMMENTS, and the lookup-resolved INTERNAL_EXTERNAL_FLAG and TYPE columns.

The SOFT_CODING_KEYFLEX_ID column is of particular interest to implementers, since it links each Projects organization to the key flexfield used to validate soft-coded expenditure entries.

Common Use Cases and Queries

Typical consumers use the view to populate organization list of values, drive Projects setup validation, and report on organization usage. A representative query retrieving project organizations and their soft coding flexfields is:

• SELECT organization_id, organization_name, org_use_type, soft_coding_keyflex_id FROM apps.pafv_organizations WHERE pa_org_use_type = 'PROJECTS' AND (inactive_date IS NULL OR inactive_date > SYSDATE);
• SELECT organization_name, location_name, date_from, date_to FROM apps.pafv_organizations WHERE business_group_id = :p_bg_id ORDER BY organization_name;
• SELECT organization_id, soft_coding_keyflex_id FROM apps.pafv_organizations WHERE org_use_type = 'Expenditure Organization';

Because the view enforces the Projects security predicate, results are automatically filtered to the organizations accessible to the current responsibility, making it suitable for both interactive reporting and batch integration without additional access control logic.