VIEW: APPS.GMS_EVENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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