Search Results prvdr_org_id




Overview
Explore in AI Chat

Overview

The PA_CC_TP_SCHEDULE_LINE_LKP table is a denormalized lookup table within Oracle E-Business Suite Projects (PA) module. Its primary function is to enable high-performance retrieval of transfer price rules between specific provider and receiver organizations that are defined within a transfer price schedule. This table is a critical performance optimization component in the inter-organization cost processing architecture for Oracle Projects, particularly in versions 12.1.1 and 12.2.2. By storing pre-processed, denormalized data, it eliminates the need for complex, multi-table joins during real-time transaction processing, thereby accelerating the identification of the applicable transfer pricing rule for a given expenditure item or cost distribution.

Key Information Stored

The table's structure is designed to uniquely identify a transfer price rule based on key organizational and scheduling parameters. Its primary key constraint, PA_CC_TP_SCHEDULE_LINE_LKP_PK, enforces uniqueness on a combination of columns that define the rule's context. The most significant columns include TP_SCHEDULE_ID, which links to the master transfer price schedule, and the pairings of PRVDR_ORGANIZATION_ID with RECVR_ORGANIZATION_ID (or PRVDR_ORG_ID with RECVR_ORG_ID), which define the specific provider and receiver organization relationship. The START_DATE_ACTIVE column is crucial for determining the valid effective date of the pricing rule, allowing for historical and future-dated schedule management.

Common Use Cases and Queries

This table is primarily accessed during the cost collection and transfer price calculation processes. When an expenditure item is incurred in a provider organization and needs to be charged to a receiver organization, the application queries this lookup table to find the correct markup or pricing rule efficiently. A typical query pattern would involve filtering on the schedule, provider, receiver, and a specific transaction date to find the active rule.

  • Sample Query: SELECT * FROM pa.pa_cc_tp_schedule_line_lkp WHERE tp_schedule_id = :p_sched_id AND prvdr_organization_id = :p_org_id AND recvr_organization_id = :r_org_id AND :p_trx_date BETWEEN start_date_active AND NVL(end_date_active, :p_trx_date);
  • Reporting Use Case: Generating a summary report of all active transfer price relationships defined across schedules for audit or reconciliation purposes.
  • Data Validation: Scripts to identify orphaned lookup records or duplicate active rules for the same organization pair within a schedule.

Related Objects

The PA_CC_TP_SCHEDULE_LINE_LKP table has a direct foreign key relationship with the master transfer price schedule table, as documented in the provided metadata. This relationship is fundamental to its integrity and function.

  • PA_CC_TP_SCHEDULES_BG: This is the primary parent table. The foreign key from PA_CC_TP_SCHEDULE_LINE_LKP.TP_SCHEDULE_ID references the primary key in PA_CC_TP_SCHEDULES_BG. This ensures that every lookup record is associated with a valid, high-level transfer price schedule.

While not explicitly listed in the provided excerpt, this lookup table is logically related to the detailed transfer price schedule lines table (typically named like PA_CC_TP_SCHEDULE_LINES) from which its denormalized data is sourced, and to the core transaction tables in Projects (PA_EXPENDITURE_ITEMS_ALL) and Cost Management (CST_CC_COST_DTLS) that consume its data during cost processing.