VIEW: PA.PA_DEDUCTIONS_ALL#

Source

View Text - Preformatted

select DEDUCTION_REQ_ID DEDUCTION_REQ_ID, PROJECT_ID PROJECT_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CHANGE_DOC_NUM CHANGE_DOC_NUM, CHANGE_DOC_TYPE CHANGE_DOC_TYPE, CI_ID CI_ID, PO_HEADER_ID PO_HEADER_ID, PO_NUMBER PO_NUMBER, DEDUCTION_REQ_NUM DEDUCTION_REQ_NUM, DEBIT_MEMO_NUM DEBIT_MEMO_NUM, CURRENCY_CODE CURRENCY_CODE, CONVERSION_RATETYPE CONVERSION_RATETYPE, CONVERSION_RATEDATE CONVERSION_RATEDATE, CONVERSION_RATE CONVERSION_RATE, TOTAL_AMOUNT TOTAL_AMOUNT, TOTAL_PFC_AMOUNT TOTAL_PFC_AMOUNT, DEDUCTION_REQ_DATE DEDUCTION_REQ_DATE, DEBIT_MEMO_DATE DEBIT_MEMO_DATE, DESCRIPTION DESCRIPTION, STATUS STATUS, ORG_ID ORG_ID, DOCUMENT_TYPE DOCUMENT_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATION_DATE LAST_UPDATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY from "PA"."PA_DEDUCTIONS_ALL"

View Text - HTML Formatted

SELECT DEDUCTION_REQ_ID DEDUCTION_REQ_ID
, PROJECT_ID PROJECT_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CHANGE_DOC_NUM CHANGE_DOC_NUM
, CHANGE_DOC_TYPE CHANGE_DOC_TYPE
, CI_ID CI_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_NUMBER PO_NUMBER
, DEDUCTION_REQ_NUM DEDUCTION_REQ_NUM
, DEBIT_MEMO_NUM DEBIT_MEMO_NUM
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_RATETYPE CONVERSION_RATETYPE
, CONVERSION_RATEDATE CONVERSION_RATEDATE
, CONVERSION_RATE CONVERSION_RATE
, TOTAL_AMOUNT TOTAL_AMOUNT
, TOTAL_PFC_AMOUNT TOTAL_PFC_AMOUNT
, DEDUCTION_REQ_DATE DEDUCTION_REQ_DATE
, DEBIT_MEMO_DATE DEBIT_MEMO_DATE
, DESCRIPTION DESCRIPTION
, STATUS STATUS
, ORG_ID ORG_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATION_DATE LAST_UPDATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "PA"."PA_DEDUCTIONS_ALL"