VIEW: PA.PA_PROJECT_RETENTIONS#

Source

View Text - Preformatted

select PROJECT_RETENTION_ID PROJECT_RETENTION_ID, RETENTION_RULE_ID RETENTION_RULE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, AGREEMENT_ID AGREEMENT_ID, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, TOTAL_RETAINED TOTAL_RETAINED, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_TOTAL_RETAINED PROJFUNC_TOTAL_RETAINED, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_TOTAL_RETAINED PROJECT_TOTAL_RETAINED, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE, FUNDING_TOTAL_RETAINED FUNDING_TOTAL_RETAINED, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_PROJECT_RETENTIONS"

View Text - HTML Formatted

SELECT PROJECT_RETENTION_ID PROJECT_RETENTION_ID
, RETENTION_RULE_ID RETENTION_RULE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, AGREEMENT_ID AGREEMENT_ID
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, TOTAL_RETAINED TOTAL_RETAINED
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_TOTAL_RETAINED PROJFUNC_TOTAL_RETAINED
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_TOTAL_RETAINED PROJECT_TOTAL_RETAINED
, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE
, FUNDING_TOTAL_RETAINED FUNDING_TOTAL_RETAINED
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_PROJECT_RETENTIONS"