DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_CI_SUPPLIER_DETAILS

Object Details
Object Name: PA_CI_SUPPLIER_DETAILS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_CI_SUPPLIER_DETAILS
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_CI_SUPPLIER_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCI_TRANSACTION_ID
PA_CI_SUPPLIER_DETAILS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIGINAL_SUPP_TRANS_ID
ColumnAUDIT_HISTORY_NUMBER
PA_CI_SUPPLIER_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCI_ID
ColumnCHANGE_TYPE
PA_CI_SUPPLIER_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnPO_HEADER_ID
ColumnPO_LINE_ID
PA_CI_SUPPLIER_DETAILS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTED_CI_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
CI_TRANSACTION_ID NUMBER (15) Yes Unique Identifier for the transaction (Primary Key)
CI_ID NUMBER (15)
Identifier for the control item such as change order, memo, change request.
CI_TYPE_ID NUMBER (15)
Identifier for the info item type
CI_IMPACT_ID NUMBER (15)
Identifier for the impact
VENDOR_ID NUMBER (15)
Identifier for the supplier
PO_HEADER_ID NUMBER (15)
Identifier for the Purchase Order details
PO_LINE_ID NUMBER (15)
Identifier for the Purchase Order Line details
CHANGE_AMOUNT NUMBER

Purchase Order Amount
CURRENCY_CODE VARCHAR2 (15)
Currency details for the Purchase Order amount
ADJUSTED_CI_TRANSACTION_ID NUMBER (15)
Identifies the adjusted transactions. It stores the value of ci_transaction_id for merged suppliers
CHANGE_DESCRIPTION VARCHAR2 (2000)
Impact description for supplier
CHANGE_TYPE VARCHAR2 (100)
Describes the Impact on supplier to raise PO i.e. Create New, Update Existing
CREATED_BY NUMBER
Yes Standard WHO columns
CREATION_DATE DATE
Yes Standard WHO columns
LAST_UPDATED_BY NUMBER
Yes Standard WHO columns
LAST_UPDATE_DATE DATE
Yes Standard WHO columns
LAST_UPDATE_LOGIN NUMBER

Standard WHO columns
CHANGE_APPROVER VARCHAR2 (50)
This column stores the name of the customer who can approve the change request.
AUDIT_HISTORY_NUMBER NUMBER

This column stores the audit history number of the supplier cost details.
CURRENT_AUDIT_FLAG VARCHAR2 (1)
The value in this column indicates whether the supplier cost details are current. A value of Y indicates current details.
ORIGINAL_SUPP_TRANS_ID NUMBER

This column stores the ID of the original supplier transaction from which the transaction is created.
SOURCE_SUPP_TRANS_ID NUMBER

This column stores the ID of the supplier transaction from which the transaction is created.
FROM_CHANGE_DATE DATE

This column stores the date from which the changes due to the impact are effective.
TO_CHANGE_DATE DATE

This column stores the date till which the changes due to the impact are effective.
RAW_COST NUMBER

This column stores the raw cost in projects functional currency.
BURDENED_COST NUMBER

This column stores the burden cost in projects functional currency.
REVENUE_RATE NUMBER

This column stores the existing revenue rate.
REVENUE_OVERRIDE_RATE NUMBER

This column stores the revenue override rate.
REVENUE NUMBER

This column stores the revenue in transactional currency.
TOTAL_REVENUE NUMBER

This column stores the total revenue in projects functional currency.
SUP_QUOTE_REF_NO NUMBER

This column stores the reference number of the supplier quotation.
TASK_ID NUMBER (15)
Task for which purchase order raised on given supplier.
RESOURCE_LIST_MEMBER_ID NUMBER (15)
The planning resource for the supplier cost.
EXPENDITURE_TYPE_ID NUMBER (15)
Type of expenditure for requested change.
ESTIMATED_COST NUMBER

Estimated cost of requested change.
QUOTED_COST NUMBER

Cost quoted by supplier for change.
NEGOTIATED_COST NUMBER

Negotiated estimated cost of change.
FINAL_COST NUMBER

Final actual cost of change.
MARKUP_COST NUMBER

Markup cost of change.
STATUS VARCHAR2 (15)
Status of supplier cost.
EXPENDITURE_ORG_ID NUMBER (15)
Identifier of the expenditure organization affected by the change document.
CHANGE_REASON_CODE VARCHAR2 (30)
Specifies the reason for the change document
QUOTE_NEGOTIATION_REFERENCE VARCHAR2 (150)
Reference to the supplier quotation used in negotiation.
NEED_BY_DATE DATE

Displays the need-by-date specified on the purchase order line being changed.
EXPENDITURE_TYPE VARCHAR2 (30)
Type of expenditure for requested change
RESOURCE_ASSIGNMENT_ID NUMBER

Identifier of the resource assigment
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CI_TRANSACTION_ID
,      CI_ID
,      CI_TYPE_ID
,      CI_IMPACT_ID
,      VENDOR_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      CHANGE_AMOUNT
,      CURRENCY_CODE
,      ADJUSTED_CI_TRANSACTION_ID
,      CHANGE_DESCRIPTION
,      CHANGE_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CHANGE_APPROVER
,      AUDIT_HISTORY_NUMBER
,      CURRENT_AUDIT_FLAG
,      ORIGINAL_SUPP_TRANS_ID
,      SOURCE_SUPP_TRANS_ID
,      FROM_CHANGE_DATE
,      TO_CHANGE_DATE
,      RAW_COST
,      BURDENED_COST
,      REVENUE_RATE
,      REVENUE_OVERRIDE_RATE
,      REVENUE
,      TOTAL_REVENUE
,      SUP_QUOTE_REF_NO
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      EXPENDITURE_TYPE_ID
,      ESTIMATED_COST
,      QUOTED_COST
,      NEGOTIATED_COST
,      FINAL_COST
,      MARKUP_COST
,      STATUS
,      EXPENDITURE_ORG_ID
,      CHANGE_REASON_CODE
,      QUOTE_NEGOTIATION_REFERENCE
,      NEED_BY_DATE
,      EXPENDITURE_TYPE
,      RESOURCE_ASSIGNMENT_ID
FROM PA.PA_CI_SUPPLIER_DETAILS;

Dependencies

[top of page]

PA.PA_CI_SUPPLIER_DETAILS does not reference any database object

PA.PA_CI_SUPPLIER_DETAILS is referenced by following:

SchemaPA
ViewPA_CI_SUPPLIER_DETAILS#