Results for “internal_external_flag”

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

Overview

PABV_ORGANIZATIONS is an APPS-owned, read-only view in the Oracle E-Business Suite Projects (PA) module. It presents a consolidated, security-filtered list of organizations that are enabled for use within Oracle Projects, joining human resources organization data with Projects-specific configuration. The "PABV" prefix indicates that this is a Projects (PA) Business View, a class of views that Oracle Projects exposes for reporting, inquiry, and integration purposes rather than as an application base table.

In Oracle EBS 12.1.1 and 12.2.2, the view serves as the primary reporting interface for project and expenditure organizations. It answers the recurring question of which HR organizations may be assigned as project organizations or expenditure organizations, and it resolves the descriptive information (name, location, dates, use type) required for display in forms, concurrent programs, and custom reports. Because the view contains a security predicate based on the Projects implementation Org ID, its results are scoped to the operating unit or organization context in which the query is executed.

Underlying Base Objects

The view is defined over the following documented objects:

• HR_ALL_ORGANIZATION_UNITS — the base HR organization table, supplying the organization identifier, business group, type, location, dates, and key flexfield identifiers.
• HR_ALL_ORGANIZATION_UNITS_TL — the translation table, providing the organization name (T1) and business group name (T2) in the session language.
• HR_LOCATIONS_ALL_TL — the translated locations table, providing the location code (LOCATION_NAME) via an outer join.
• PA_ALL_ORGANIZATIONS — the Projects organization classification table, supplying PA_ORG_USE_TYPE, ORG_ID, and INACTIVE_DATE.
• PA_IMPLEMENTATIONS_ALL — the Projects implementation table, used to match the configured project organization type and to apply the Org ID security predicate.
• FND_COMMON_LOOKUPS — resolves the use-type lookup code to its meaning (for example, PA_PROJECT_ORG or PA_EXPENDITURE_ORG).
• HR_GENERAL and FND_GLOBAL — packages used to decode lookups and resolve session context such as USERENV('LANG') and security.

Key Columns

• ORGANIZATION_ID — primary identifier of the HR organization unit.
• ORGANIZATION_NAME — translated name of the organization.
• BUSINESS_GROUP_NAME — translated name of the parent business group.
• ORG_USE_TYPE / ORGANIZATION_USE_TYPE_CODE — the Projects classification, derived from PA_ALL_ORGANIZATIONS.PA_ORG_USE_TYPE.
• MEANING — the decoded lookup meaning for the use type.
• DATE_FROM / DATE_TO / INACTIVE_DATE — effective and inactivation dates governing organization usability.
• LOCATION_NAME — location code from HR_LOCATIONS_ALL_TL.
• INTERNAL_EXTERNAL_FLAG, TYPE, INTERNAL_ADDRESS_LINE, COMMENTS — descriptive organization attributes.
• ORG_ID, BUSINESS_GROUP_ID, LOCATION_ID, COST_ALLOCATION_KEYFLEX_ID, SOFT_CODING_KEYFLEX_ID — identifier and key flexfield references used for joins and integration.

Common Use Cases and Queries

The view is typically queried as a validation list source, an LOV backing query, or a reporting data source. A common pattern is to list all project organizations available to the current session:

• SELECT organization_id, organization_name, org_use_type, meaning FROM apps.pabv_organizations WHERE org_use_type = 'PA_PROJECT_ORG'
• SELECT organization_id, organization_name, location_name, inactive_date FROM apps.pabv_organizations WHERE inactive_date IS NULL ORDER BY organization_name
• Use as a security-filtered validation query in a custom concurrent program or OAF page where the effective Org ID must be respected.

Because the view includes a WITH READ ONLY clause and a security predicate, no DML is permitted and results are restricted to the accessible implementation. It is most reliable when queried within the correct Projects responsibility and operating unit context.