VIEW: PA.PA_EVENTS#

Source

View Text - Preformatted

select TASK_ID TASK_ID, EVENT_NUM EVENT_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EVENT_TYPE EVENT_TYPE, DESCRIPTION DESCRIPTION, BILL_AMOUNT BILL_AMOUNT, REVENUE_AMOUNT REVENUE_AMOUNT, REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG, BILL_HOLD_FLAG BILL_HOLD_FLAG, COMPLETION_DATE COMPLETION_DATE, REV_DIST_REJECTION_CODE REV_DIST_REJECTION_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, PROJECT_ID PROJECT_ID, ORGANIZATION_ID ORGANIZATION_ID, BILLING_ASSIGNMENT_ID BILLING_ASSIGNMENT_ID, EVENT_NUM_REVERSED EVENT_NUM_REVERSED, CALLING_PLACE CALLING_PLACE, CALLING_PROCESS CALLING_PROCESS, AUDIT_COST_BUDGET_TYPE_CODE AUDIT_COST_BUDGET_TYPE_CODE, AUDIT_REV_BUDGET_TYPE_CODE AUDIT_REV_BUDGET_TYPE_CODE, AUDIT_AMOUNT1 AUDIT_AMOUNT1, AUDIT_AMOUNT2 AUDIT_AMOUNT2, AUDIT_AMOUNT3 AUDIT_AMOUNT3, AUDIT_AMOUNT4 AUDIT_AMOUNT4, AUDIT_AMOUNT5 AUDIT_AMOUNT5, AUDIT_AMOUNT6 AUDIT_AMOUNT6, AUDIT_AMOUNT7 AUDIT_AMOUNT7, AUDIT_AMOUNT8 AUDIT_AMOUNT8, AUDIT_AMOUNT9 AUDIT_AMOUNT9, AUDIT_AMOUNT10 AUDIT_AMOUNT10, EVENT_ID EVENT_ID, INVENTORY_ORG_ID INVENTORY_ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, QUANTITY_BILLED QUANTITY_BILLED, UOM_CODE UOM_CODE, UNIT_PRICE UNIT_PRICE, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, REFERENCE6 REFERENCE6, REFERENCE7 REFERENCE7, REFERENCE8 REFERENCE8, REFERENCE9 REFERENCE9, REFERENCE10 REFERENCE10, BILLED_FLAG BILLED_FLAG, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT, BILL_TRANS_REV_AMOUNT BILL_TRANS_REV_AMOUNT, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE, PROJECT_REVENUE_AMOUNT PROJECT_REVENUE_AMOUNT, PROJECT_INV_RATE_DATE PROJECT_INV_RATE_DATE, PROJECT_INV_EXCHANGE_RATE PROJECT_INV_EXCHANGE_RATE, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_RATE_TYPE PROJFUNC_RATE_TYPE, PROJFUNC_RATE_DATE PROJFUNC_RATE_DATE, PROJFUNC_EXCHANGE_RATE PROJFUNC_EXCHANGE_RATE, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE, PROJFUNC_REVENUE_AMOUNT PROJFUNC_REVENUE_AMOUNT, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT, FUNDING_RATE_TYPE FUNDING_RATE_TYPE, FUNDING_RATE_DATE FUNDING_RATE_DATE, FUNDING_EXCHANGE_RATE FUNDING_EXCHANGE_RATE, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, REVPROC_RATE_TYPE REVPROC_RATE_TYPE, REVPROC_RATE_DATE REVPROC_RATE_DATE, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, INVPROC_RATE_TYPE INVPROC_RATE_TYPE, INVPROC_RATE_DATE INVPROC_RATE_DATE, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE, INV_GEN_REJECTION_CODE INV_GEN_REJECTION_CODE, ADJUSTING_REVENUE_FLAG ADJUSTING_REVENUE_FLAG, ZERO_REVENUE_AMOUNT_FLAG ZERO_REVENUE_AMOUNT_FLAG, NON_UPDATEABLE_FLAG NON_UPDATEABLE_FLAG, PROJECT_FUNDING_ID PROJECT_FUNDING_ID, REVENUE_HOLD_FLAG REVENUE_HOLD_FLAG, AUDIT_COST_PLAN_TYPE_ID AUDIT_COST_PLAN_TYPE_ID, AUDIT_REV_PLAN_TYPE_ID AUDIT_REV_PLAN_TYPE_ID, PM_PRODUCT_CODE PM_PRODUCT_CODE, PM_EVENT_REFERENCE PM_EVENT_REFERENCE, DELIVERABLE_ID DELIVERABLE_ID, ACTION_ID ACTION_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, AGREEMENT_ID AGREEMENT_ID from "PA"."PA_EVENTS"

View Text - HTML Formatted

SELECT TASK_ID TASK_ID
, EVENT_NUM EVENT_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EVENT_TYPE EVENT_TYPE
, DESCRIPTION DESCRIPTION
, BILL_AMOUNT BILL_AMOUNT
, REVENUE_AMOUNT REVENUE_AMOUNT
, REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG
, BILL_HOLD_FLAG BILL_HOLD_FLAG
, COMPLETION_DATE COMPLETION_DATE
, REV_DIST_REJECTION_CODE REV_DIST_REJECTION_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, PROJECT_ID PROJECT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, BILLING_ASSIGNMENT_ID BILLING_ASSIGNMENT_ID
, EVENT_NUM_REVERSED EVENT_NUM_REVERSED
, CALLING_PLACE CALLING_PLACE
, CALLING_PROCESS CALLING_PROCESS
, AUDIT_COST_BUDGET_TYPE_CODE AUDIT_COST_BUDGET_TYPE_CODE
, AUDIT_REV_BUDGET_TYPE_CODE AUDIT_REV_BUDGET_TYPE_CODE
, AUDIT_AMOUNT1 AUDIT_AMOUNT1
, AUDIT_AMOUNT2 AUDIT_AMOUNT2
, AUDIT_AMOUNT3 AUDIT_AMOUNT3
, AUDIT_AMOUNT4 AUDIT_AMOUNT4
, AUDIT_AMOUNT5 AUDIT_AMOUNT5
, AUDIT_AMOUNT6 AUDIT_AMOUNT6
, AUDIT_AMOUNT7 AUDIT_AMOUNT7
, AUDIT_AMOUNT8 AUDIT_AMOUNT8
, AUDIT_AMOUNT9 AUDIT_AMOUNT9
, AUDIT_AMOUNT10 AUDIT_AMOUNT10
, EVENT_ID EVENT_ID
, INVENTORY_ORG_ID INVENTORY_ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QUANTITY_BILLED QUANTITY_BILLED
, UOM_CODE UOM_CODE
, UNIT_PRICE UNIT_PRICE
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, REFERENCE6 REFERENCE6
, REFERENCE7 REFERENCE7
, REFERENCE8 REFERENCE8
, REFERENCE9 REFERENCE9
, REFERENCE10 REFERENCE10
, BILLED_FLAG BILLED_FLAG
, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT
, BILL_TRANS_REV_AMOUNT BILL_TRANS_REV_AMOUNT
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE
, PROJECT_REVENUE_AMOUNT PROJECT_REVENUE_AMOUNT
, PROJECT_INV_RATE_DATE PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE PROJECT_INV_EXCHANGE_RATE
, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE PROJFUNC_EXCHANGE_RATE
, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_REVENUE_AMOUNT PROJFUNC_REVENUE_AMOUNT
, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT
, FUNDING_RATE_TYPE FUNDING_RATE_TYPE
, FUNDING_RATE_DATE FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE FUNDING_EXCHANGE_RATE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE REVPROC_RATE_TYPE
, REVPROC_RATE_DATE REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE INVPROC_RATE_TYPE
, INVPROC_RATE_DATE INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE
, INV_GEN_REJECTION_CODE INV_GEN_REJECTION_CODE
, ADJUSTING_REVENUE_FLAG ADJUSTING_REVENUE_FLAG
, ZERO_REVENUE_AMOUNT_FLAG ZERO_REVENUE_AMOUNT_FLAG
, NON_UPDATEABLE_FLAG NON_UPDATEABLE_FLAG
, PROJECT_FUNDING_ID PROJECT_FUNDING_ID
, REVENUE_HOLD_FLAG REVENUE_HOLD_FLAG
, AUDIT_COST_PLAN_TYPE_ID AUDIT_COST_PLAN_TYPE_ID
, AUDIT_REV_PLAN_TYPE_ID AUDIT_REV_PLAN_TYPE_ID
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, PM_EVENT_REFERENCE PM_EVENT_REFERENCE
, DELIVERABLE_ID DELIVERABLE_ID
, ACTION_ID ACTION_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, AGREEMENT_ID AGREEMENT_ID
FROM "PA"."PA_EVENTS"