Search Results pa_proj_type_distributions_all




Overview
Explore in AI Chat

Overview

The PA_PROJ_TYPE_DISTRIBUTIONS_ALL table is a core setup table within Oracle E-Business Suite Projects (PA) module. It defines the valid, implementation-specific relationships between project types and distribution rules. This table acts as a control mechanism, ensuring that only pre-approved distribution rules can be assigned to projects of a given type. Its role is to enforce business rules at the configuration level, providing a controlled list of available distribution options (like how labor or expense costs are allocated) for each project type defined in the system. The '_ALL' suffix indicates it is a multi-organization table, storing data partitioned by the ORG_ID (Operating Unit).

Key Information Stored

The table's structure is relatively simple, as its primary function is to maintain association records. The key columns are the composite primary key: PROJECT_TYPE, DISTRIBUTION_RULE, and ORG_ID. The PROJECT_TYPE column stores the code for a project type defined in PA_PROJECT_TYPES_ALL. The DISTRIBUTION_RULE column stores the name of a distribution rule defined in PA_DISTRIBUTION_RULES. The ORG_ID column stores the identifier for the operating unit, enabling the setup to vary by organization. Together, these columns create a unique record permitting a specific distribution rule for a specific project type within a specific operating unit.

Common Use Cases and Queries

A primary use case is validating available distribution rules during project entry or maintenance. When a user creates a project and selects a project type, the application references this table to populate the list of allowable distribution rules. For reporting and audit purposes, administrators often query this table to review or document the configuration. A typical query would join to the related setup tables for descriptive information:

  • Configuration Review: SELECT pt.project_type, dr.distribution_rule, dr.description FROM pa_proj_type_distributions_all ptd, pa_project_types_all pt, pa_distribution_rules dr WHERE ptd.project_type = pt.project_type AND ptd.distribution_rule = dr.distribution_rule AND ptd.org_id = :p_org_id ORDER BY 1, 2;
  • Validation Check: SELECT 'INVALID' FROM pa_proj_type_distributions_all WHERE project_type = :p_proj_type AND distribution_rule = :p_dist_rule AND org_id = :p_org_id; This is used to verify if a rule is permitted for a given type.

Related Objects

This table has defined foreign key relationships with two other key setup tables, as per the provided metadata:

  • PA_PROJECT_TYPES_ALL: The PROJECT_TYPE and ORG_ID columns in PA_PROJ_TYPE_DISTRIBUTIONS_ALL reference the same columns in PA_PROJECT_TYPES_ALL. This ensures every project type in the distributions table is a valid, defined project type.
  • PA_DISTRIBUTION_RULES: The DISTRIBUTION_RULE column in PA_PROJ_TYPE_DISTRIBUTIONS_ALL references the DISTRIBUTION_RULE column in PA_DISTRIBUTION_RULES. This ensures every distribution rule linked to a project type is a valid, defined rule.

These relationships are critical for maintaining referential integrity in the Projects setup. The table is also centrally referenced by the application logic that governs project creation and maintenance workflows.