Results for “tp_amt_type_code”

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

Overview

PA_CC_TP_SCHEDULE_LINE_LKP is a denormalized lookup table in the Oracle Projects (PA) schema that supports transfer price processing across organizations in Oracle E-Business Suite 12.1.1 and 12.2.2. The table is maintained by the Cross-Product Costing and transfer price engine to accelerate the resolution of the applicable transfer price rule between a providing organization and a receiving organization within a defined transfer price schedule. Rather than performing repeated multi-block joins at runtime, the transfer pricing process pre-resolves the schedule line relationships into this lookup structure, enabling faster and more predictable query performance during cost distribution and inter-organization billing cycles.

Because the table stores resolved relationship context between organizations and their governing schedule line, the heuristic Data Vault classification is satellite-leaning. In Data Vault modeling terms, the table behaves as a satellite on the transfer price schedule business key, capturing descriptive attributes (amount type, labor flag, active dates, sort order) that qualify the relationship rather than introducing a new independent hub.

Key Information Stored

The table is composed of 16 documented columns, of which the following are most significant:

• TP_SCHEDULE_ID — Identifies the transfer price schedule header, and is also a foreign key to PA_CC_TP_SCHEDULES_BG.
• TP_SCHEDULE_LINE_ID — References the underlying defined schedule line in PA_CC_TP_SCHEDULE_LINES, linking the denormalized record back to its source rule definition.
• PRVDR_ORGANIZATION_ID and RECVR_ORGANIZATION_ID — The business identifiers of the providing and receiving organizations in the transfer.
• PRVDR_ORG_ID and RECVR_ORG_ID — Internal organization identifiers used for the fast lookup resolution.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Define the validity window during which the lookup record applies.
• LABOR_FLAG — Distinguishes whether the transfer price rule applies to labor cost components.
• TP_AMT_TYPE_CODE — Indicates the transfer price amount type governing the relationship.
• SORT_ORDER — Establishes a deterministic evaluation order when multiple candidate rules match.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.

The surrogate primary key is PA_CC_TP_SCHEDULE_LINE_LKP_PK, defined over TP_SCHEDULE_ID, PRVDR_ORGANIZATION_ID, RECVR_ORGANIZATION_ID, PRVDR_ORG_ID, RECVR_ORG_ID, and START_DATE_ACTIVE. The unique index PA_CC_TP_SCHEDULE_LINE_LKP_U1 extends this with LABOR_FLAG, providing the candidate business key that guarantees a single active rule per schedule, organization pair, and labor category.

Common Use Cases and Queries

The primary use case is rule resolution during cost distribution. A typical query retrieves the transfer price rule between two organizations on a given effective date:

• Joining PA_CC_TP_SCHEDULE_LINE_LKP to PA_CC_TP_SCHEDULE_LINES on TP_SCHEDULE_LINE_ID to retrieve the full rule definition.
• Filtering by TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, '31-DEC-4712') to find currently active rules.
• Filtering on LABOR_FLAG and TP_AMT_TYPE_CODE to isolate the correct pricing dimension for a labor or non-labor transaction.
• Ordering by SORT_ORDER to determine precedence when multiple schedule lines satisfy the same organization pair.
• Audit and reconciliation reporting that verifies the denormalized lookup remains synchronized with its source schedule lines.

Related Objects

The following objects are the most significant in relation to this lookup table:

• PA_CC_TP_SCHEDULES_BG — Transfer price schedule header, joined via TP_SCHEDULE_ID.
• PA_CC_TP_SCHEDULE_LINES — Source schedule line definitions, joined via TP_SCHEDULE_LINE_ID.
• PA_CC_TP_SCHEDULE_LINES_BG — Business-group variant supporting schedule line inquiries.
• HR_ALL_ORGANIZATION_UNITS / PER_ORGANIZATION_UNITS — Resolve PRVDR_ORGANIZATION_ID and RECVR_ORGANIZATION_ID to organization names.
• PA_ORG_LINES / PA_ORGANIZATION_RELATIONSHIPS — Define the inter-organization structures over which transfer pricing applies.
• PA_COST_DIST_LINES_ALL — Consumes resolved transfer price rules during cost distribution processing.