VIEW: PA.PA_DEDUCTION_TRANSACTIONS_ALL#

Source

View Text - Preformatted

select DEDUCTION_REQ_ID DEDUCTION_REQ_ID, DEDUCTION_REQ_TRAN_ID DEDUCTION_REQ_TRAN_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, QUANTITY QUANTITY, OVERRIDE_QUANTITY OVERRIDE_QUANTITY, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, GL_DATE GL_DATE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, ORIG_PROJFUNC_AMOUNT ORIG_PROJFUNC_AMOUNT, OVERRIDE_PROJFUNC_AMOUNT OVERRIDE_PROJFUNC_AMOUNT, CONVERSION_RATETYPE CONVERSION_RATETYPE, CONVERSION_RATEDATE CONVERSION_RATEDATE, CONVERSION_RATE CONVERSION_RATE, AMOUNT AMOUNT, DESCRIPTION DESCRIPTION, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATION_DATE LAST_UPDATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY from "PA"."PA_DEDUCTION_TRANSACTIONS_ALL"

View Text - HTML Formatted

SELECT DEDUCTION_REQ_ID DEDUCTION_REQ_ID
, DEDUCTION_REQ_TRAN_ID DEDUCTION_REQ_TRAN_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, QUANTITY QUANTITY
, OVERRIDE_QUANTITY OVERRIDE_QUANTITY
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, GL_DATE GL_DATE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, ORIG_PROJFUNC_AMOUNT ORIG_PROJFUNC_AMOUNT
, OVERRIDE_PROJFUNC_AMOUNT OVERRIDE_PROJFUNC_AMOUNT
, CONVERSION_RATETYPE CONVERSION_RATETYPE
, CONVERSION_RATEDATE CONVERSION_RATEDATE
, CONVERSION_RATE CONVERSION_RATE
, AMOUNT AMOUNT
, DESCRIPTION DESCRIPTION
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATION_DATE LAST_UPDATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "PA"."PA_DEDUCTION_TRANSACTIONS_ALL"