Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_EVENTS_V |
SELECT PE.TASK_ID
, PE.EVENT_NUM
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.EVENT_TYPE
, PE.DESCRIPTION
, PE.BILL_AMOUNT
, PE.REVENUE_AMOUNT
, PE.REVENUE_DISTRIBUTED_FLAG
, PE.BILL_HOLD_FLAG
, PE.COMPLETION_DATE
, PE.REV_DIST_REJECTION_CODE
, PE.REQUEST_ID
, PE.PROGRAM_APPLICATION_ID
, PE.PROGRAM_ID
, PE.PROGRAM_UPDATE_DATE
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.PROJECT_ID
, PE.ORGANIZATION_ID
, PE.BILLING_ASSIGNMENT_ID
, PE.EVENT_NUM_REVERSED
, PE.CALLING_PLACE
, PE.CALLING_PROCESS
, PE.AUDIT_COST_BUDGET_TYPE_CODE
, PE.AUDIT_REV_BUDGET_TYPE_CODE
, PE.AUDIT_AMOUNT1
, PE.AUDIT_AMOUNT2
, PE.AUDIT_AMOUNT3
, PE.AUDIT_AMOUNT4
, PE.AUDIT_AMOUNT5
, PE.AUDIT_AMOUNT6
, PE.AUDIT_AMOUNT7
, PE.AUDIT_AMOUNT8
, PE.AUDIT_AMOUNT9
, PE.AUDIT_AMOUNT10
, PE.EVENT_ID
, GEA.INSTALLMENT_ID
, GEA.ACTUAL_PROJECT_ID
, GEA.ACTUAL_TASK_ID
, GEA.BURDEN_COST_CODE
, GEA.EXPENDITURE_ORG_ID
, GEA.BILL_AMOUNT
, GEA.REVENUE_AMOUNT
, GEA.WRITE_OFF_AMOUNT
, GEA.REVENUE_ACCUMULATED
, GEA.RESOURCE_LIST_MEMBER_ID
, GEA.REQUEST_ID
, GEA.EXPENDITURE_TYPE
, GEA.EVENT_CALLING_PROCESS
FROM PA_EVENTS PE
, GMS_EVENT_ATTRIBUTE GEA
WHERE PE.PROJECT_ID=GEA.PROJECT_ID
AND PE.EVENT_NUM=GEA.EVENT_NUM