VIEW: APPS.PA_EVENTS_AMG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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