Search Results change_amount

Overview

PA_CI_SUPPLIER_DETAILS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the impact of change orders on suppliers and purchase orders. It records how a control item change propagates to supplier commitments and PO documents, capturing cost, revenue, and quote negotiation attributes tied to a specific change impact. The table is owned by the PA schema and is documented with 46 columns in the ETRM 12.2.2 physical schema.

From a modeling perspective, the mined foreign-key structure suggests a link classification in a Data Vault heuristic. The table sits between control items, change impacts, change types, vendors, and purchasing documents, and each row asserts an association rather than describing a standalone hub business key. This classification is a suggested interpretation, not a mandated construct.

Key Information Stored

The surrogate primary key is CI_TRANSACTION_ID, enforced by PA_CI_SUPPLIER_DETAILS_PK. Two unique indexes provide business-key candidates: PA_CI_SUPPLIER_DETAILS_U1 on CI_TRANSACTION_ID and PA_CI_SUPPLIER_DETAILS_U2 on the combination of ORIGINAL_SUPP_TRANS_ID and AUDIT_HISTORY_NUMBER, which supports audited history across change revisions.

Identification and linkage: CI_ID, CI_TYPE_ID, and CI_IMPACT_ID tie the row to the control item, its change type, and its impact record.
Purchasing references: VENDOR_ID, PO_HEADER_ID, and PO_LINE_ID identify the supplier and the purchase order header and line affected by the change.
Financial impact: CHANGE_AMOUNT and CURRENCY_CODE capture the monetary effect; RAW_COST, BURDENED_COST, and ESTIMATED_COST reflect cost components.
Revenue and pricing: REVENUE_RATE, REVENUE_OVERRIDE_RATE, REVENUE, and TOTAL_REVENUE hold pricing and revenue effect data.
Negotiation and quoting: SUP_QUOTE_REF_NO, QUOTE_NEGOTIATION_REFERENCE, QUOTED_COST, NEGOTIATED_COST, FINAL_COST, and MARKUP_COST support supplier quote and negotiation tracking.
Audit and lifecycle: AUDIT_HISTORY_NUMBER, CURRENT_AUDIT_FLAG, and ORIGINAL_SUPP_TRANS_ID identify historical and current versions; STATUS reflects the record's processing state.
Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Project controls and procurement analysts use this table to report supplier cost impact from change orders, to compare estimated against negotiated and final supplier costs, and to trace which purchase order lines were affected by a given control item change.

Change order cost impact by supplier: sum CHANGE_AMOUNT grouped by VENDOR_ID.
PO line exposure reporting: join PO_HEADER_ID and PO_LINE_ID back to PO_HEADERS_ALL and PO_LINES_ALL to identify affected lines.
Current versus historical view: filter CURRENT_AUDIT_FLAG and order by AUDIT_HISTORY_NUMBER to isolate the active revision.
Negotiation variance analysis: compare ESTIMATED_COST against NEGOTIATED_COST and FINAL_COST.

A representative pattern joins the supplier detail to control items and impacts:

SELECT s.CI_TRANSACTION_ID, s.CI_ID, s.VENDOR_ID,
       s.PO_HEADER_ID, s.PO_LINE_ID, s.CHANGE_AMOUNT
FROM   PA.PA_CI_SUPPLIER_DETAILS s
WHERE  s.CURRENT_AUDIT_FLAG = 'Y'
AND    s.CI_ID = :control_item_id;

Related Objects

The foreign keys documented in the ETRM metadata establish the following dependencies, all joined on the columns shown:

PA_CI_TYPES_B via CI_TYPE_ID.
PA_CONTROL_ITEMS via CI_ID.
PA_CI_IMPACTS via CI_IMPACT_ID.
PO_VENDORS via VENDOR_ID.
PO_HEADERS_ALL via PO_HEADER_ID.
PO_LINES_ALL via PO_LINE_ID.

Collectively these relationships position PA_CI_SUPPLIER_DETAILS as the Projects-to-Purchasing bridge for change order supplier impact, supporting both transactional processing and cross-module reporting between the Projects and Purchasing applications.

Table: PA_CI_SUPPLIER_DETAILS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS, object_name:PA_CI_SUPPLIER_DETAILS, status:VALID, product: PA - Projects , description: A new entity PA_CI_SUPPLIER_DETAILS, which stores the details of impact of change orders on Suppliers and Purchase Orders. This entity contains the following attributes , implementation_dba_data: PA.PA_CI_SUPPLIER_DETAILS ,
Table: PA_CI_SUPPLIER_DETAILS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS, object_name:PA_CI_SUPPLIER_DETAILS, status:VALID, product: PA - Projects , description: A new entity PA_CI_SUPPLIER_DETAILS, which stores the details of impact of change orders on Suppliers and Purchase Orders. This entity contains the following attributes , implementation_dba_data: PA.PA_CI_SUPPLIER_DETAILS ,
View: PA_CI_SUPPLIER_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS_V, object_name:PA_CI_SUPPLIER_DETAILS_V, status:VALID, product: PA - Projects , description: Pa_ci_supplier_details_v is view used to desgin UI screen , implementation_dba_data: APPS.PA_CI_SUPPLIER_DETAILS_V ,
View: PA_CI_SUPPLIER_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS_V, object_name:PA_CI_SUPPLIER_DETAILS_V, status:VALID, product: PA - Projects , description: Pa_ci_supplier_details_v is view used to desgin UI screen , implementation_dba_data: APPS.PA_CI_SUPPLIER_DETAILS_V ,