VIEW: PA.PA_CI_SUPPLIER_DETAILS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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