VIEW: PA.PA_DRAFT_REV_ITEMS_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, PROJECT_ID PROJECT_ID, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM, LINE_NUM LINE_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, TASK_ID TASK_ID, AMOUNT AMOUNT, REVENUE_SOURCE REVENUE_SOURCE, REVENUE_CATEGORY_CODE REVENUE_CATEGORY_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_REVENUE_AMOUNT PROJFUNC_REVENUE_AMOUNT, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_REVENUE_AMOUNT PROJECT_REVENUE_AMOUNT, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE, FUNDING_REVENUE_AMOUNT FUNDING_REVENUE_AMOUNT from "PA"."PA_DRAFT_REV_ITEMS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PROJECT_ID PROJECT_ID
, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, LINE_NUM LINE_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, TASK_ID TASK_ID
, AMOUNT AMOUNT
, REVENUE_SOURCE REVENUE_SOURCE
, REVENUE_CATEGORY_CODE REVENUE_CATEGORY_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_REVENUE_AMOUNT PROJFUNC_REVENUE_AMOUNT
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_REVENUE_AMOUNT PROJECT_REVENUE_AMOUNT
, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE
, FUNDING_REVENUE_AMOUNT FUNDING_REVENUE_AMOUNT
FROM "PA"."PA_DRAFT_REV_ITEMS_AR"