Search Results pa_pt_co_impl_statuses_pk

Overview

The PA_PT_CO_IMPL_STATUSES table is a core setup table within the Oracle E-Business Suite Projects module (PA). Its primary role is to store the configuration that integrates Change Order (CO) document types with Financial Plan types. This integration is a critical part of the project financial and change management setup, enabling the system to control and track the financial implications of project changes based on their document type and the associated project status. The table acts as a junction, defining valid relationships and governing the workflow for implementing financial changes stemming from approved change documents.

Key Information Stored

The table's structure centers on linking three key entities. The primary identifier is the system-generated PT_CO_IMPL_STATUSES_ID. The core foreign key columns define the relationships: CI_TYPE_ID references the specific type of Change Document (from PA_CI_TYPES_B), and FIN_PLAN_TYPE_ID references the associated Financial Plan Type (from PA_FIN_PLAN_TYPES_B). A crucial column is STATUS_CODE, which links to PA_PROJECT_STATUSES. This status code typically represents the project status at which the financial plan integration for a given change document type is considered valid or required, playing a key role in the change implementation workflow.

Common Use Cases and Queries

This table is primarily referenced during the setup and execution of project change management processes. A common operational query is to determine which financial plan type should be used when implementing a change order of a specific type for a project in a given status. For reporting and audit purposes, administrators may query the configured integrations to ensure setup completeness. A typical validation SQL pattern would join this table to its referenced setup tables to list all active relationships.

SELECT ps.status_code,
       ct.name ci_type_name,
       fpt.name fin_plan_type_name
  FROM pa_pt_co_impl_statuses cis,
       pa_project_statuses ps,
       pa_ci_types_b ct,
       pa_fin_plan_types_b fpt
 WHERE cis.status_code = ps.status_code
   AND cis.ci_type_id = ct.ci_type_id
   AND cis.fin_plan_type_id = fpt.fin_plan_type_id
 ORDER BY 1,2;

Related Objects

The table has defined foreign key relationships with several fundamental Projects setup tables, as documented in the ETRM metadata:

• PA_FIN_PLAN_TYPES_B: Linked via PA_PT_CO_IMPL_STATUSES.FIN_PLAN_TYPE_ID. This table stores the definition of financial plan types used for budgeting and forecasting.
• PA_CI_TYPES_B: Linked via PA_PT_CO_IMPL_STATUSES.CI_TYPE_ID. This table defines the types of change documents (e.g., Change Order, Budget Revision).
• PA_PROJECT_STATUSES: Linked via PA_PT_CO_IMPL_STATUSES.STATUS_CODE. This table holds the valid statuses for a project within its lifecycle.

The primary key constraint PA_PT_CO_IMPL_STATUSES_PK on PT_CO_IMPL_STATUSES_ID ensures the uniqueness of each configured integration record.