Skip to content

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

VIEW: PA.PA_CI_SUPPLIER_DETAILS#

Object Details
Object Name: PA_CI_SUPPLIER_DETAILS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CI_TRANSACTION_ID NUMBER (15) Yes
CI_ID NUMBER (15)
CI_TYPE_ID NUMBER (15)
CI_IMPACT_ID NUMBER (15)
VENDOR_ID NUMBER (15)
PO_HEADER_ID NUMBER (15)
PO_LINE_ID NUMBER (15)
CHANGE_AMOUNT NUMBER

CURRENCY_CODE VARCHAR2 (15)
ADJUSTED_CI_TRANSACTION_ID NUMBER (15)
CHANGE_DESCRIPTION VARCHAR2 (2000)
CHANGE_TYPE VARCHAR2 (100)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

CHANGE_APPROVER VARCHAR2 (50)
AUDIT_HISTORY_NUMBER NUMBER

CURRENT_AUDIT_FLAG VARCHAR2 (1)
ORIGINAL_SUPP_TRANS_ID NUMBER

SOURCE_SUPP_TRANS_ID NUMBER

FROM_CHANGE_DATE DATE

TO_CHANGE_DATE DATE

RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE_RATE NUMBER

REVENUE_OVERRIDE_RATE NUMBER

REVENUE NUMBER

TOTAL_REVENUE NUMBER

SUP_QUOTE_REF_NO NUMBER

TASK_ID NUMBER (15)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
EXPENDITURE_TYPE_ID NUMBER (15)
ESTIMATED_COST NUMBER

QUOTED_COST NUMBER

NEGOTIATED_COST NUMBER

FINAL_COST NUMBER

MARKUP_COST NUMBER

STATUS VARCHAR2 (15)
EXPENDITURE_ORG_ID NUMBER (15)
CHANGE_REASON_CODE VARCHAR2 (30)
QUOTE_NEGOTIATION_REFERENCE VARCHAR2 (150)
NEED_BY_DATE DATE

EXPENDITURE_TYPE VARCHAR2 (30)
RESOURCE_ASSIGNMENT_ID NUMBER

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# references the following:

SchemaPA
TablePA_CI_SUPPLIER_DETAILS
PA.PA_CI_SUPPLIER_DETAILS# is referenced by following:

SchemaAPPS
SynonymPA_CI_SUPPLIER_DETAILS