APPS.PA_EVENTS_AMG_V
[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | This view is based on pa_events table, and stores events assigned to a task that generate revenue and/or billing activities that are not directly associated to the cost and revenue generated by expenditure items. |
| Implementation/DBA Data: |
APPS.PA_EVENTS_AMG_V
|
SELECT TASK_ID
, EVENT_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, EVENT_TYPE
, DESCRIPTION
, BILL_AMOUNT
, REVENUE_AMOUNT
, REVENUE_DISTRIBUTED_FLAG
, BILL_HOLD_FLAG
, COMPLETION_DATE
, REV_DIST_REJECTION_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, PROJECT_ID
, ORGANIZATION_ID
, BILLING_ASSIGNMENT_ID
, EVENT_NUM_REVERSED
, CALLING_PLACE
, CALLING_PROCESS
, AUDIT_COST_BUDGET_TYPE_CODE
, AUDIT_REV_BUDGET_TYPE_CODE
, AUDIT_AMOUNT1
, AUDIT_AMOUNT2
, AUDIT_AMOUNT3
, AUDIT_AMOUNT4
, AUDIT_AMOUNT5
, AUDIT_AMOUNT6
, AUDIT_AMOUNT7
, AUDIT_AMOUNT8
, AUDIT_AMOUNT9
, AUDIT_AMOUNT10
, EVENT_ID
, INVENTORY_ORG_ID
, INVENTORY_ITEM_ID
, QUANTITY_BILLED
, UOM_CODE
, UNIT_PRICE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, BILLED_FLAG
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT
, BILL_TRANS_REV_AMOUNT
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE
, PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE
, PROJECT_REVENUE_AMOUNT
, PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE
, PROJECT_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE
, PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_REVENUE_AMOUNT
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_BILL_AMOUNT
, FUNDING_RATE_TYPE
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, INV_GEN_REJECTION_CODE
, ADJUSTING_REVENUE_FLAG
, ZERO_REVENUE_AMOUNT_FLAG
, NON_UPDATEABLE_FLAG
, PROJECT_FUNDING_ID
, REVENUE_HOLD_FLAG
, AUDIT_COST_PLAN_TYPE_ID
, AUDIT_REV_PLAN_TYPE_ID
, PM_PRODUCT_CODE
, PM_EVENT_REFERENCE
, DELIVERABLE_ID
, ACTION_ID
, RECORD_VERSION_NUMBER
FROM PA_EVENTS