VIEW: APPS.PA_EVENTS_MRC_V

Source

View Text - Preformatted

SELECT mc.SET_OF_BOOKS_ID , mc.EVENT_ID , mc.PROJECT_ID , mc.TASK_ID , mc.EVENT_NUM , ev.REVENUE_AMOUNT , ev.BILL_AMOUNT , ev.LAST_UPDATE_DATE , ev.LAST_UPDATED_BY , ev.CREATION_DATE , ev.CREATED_BY , ev.LAST_UPDATE_LOGIN , ev.EVENT_TYPE , NVL(substr(mc.DESCRIPTION,1,240), substr(ev.description,1,240)) , ev.REVENUE_DISTRIBUTED_FLAG , ev.BILL_HOLD_FLAG , ev.COMPLETION_DATE , ev.REV_DIST_REJECTION_CODE , ev.REQUEST_ID , ev.PROGRAM_APPLICATION_ID , ev.PROGRAM_ID , ev.PROGRAM_UPDATE_DATE , ev.ATTRIBUTE_CATEGORY , ev.ATTRIBUTE1 , ev.ATTRIBUTE2 , ev.ATTRIBUTE3 , ev.ATTRIBUTE4 , ev.ATTRIBUTE5 , ev.ATTRIBUTE6 , ev.ATTRIBUTE7 , ev.ATTRIBUTE8 , ev.ATTRIBUTE9 , ev.ATTRIBUTE10 , ev.ORGANIZATION_ID , ev.BILLING_ASSIGNMENT_ID , ev.EVENT_NUM_REVERSED , ev.CALLING_PLACE , ev.CALLING_PROCESS , ev.AUDIT_COST_BUDGET_TYPE_CODE , ev.AUDIT_REV_BUDGET_TYPE_CODE , ev.AUDIT_AMOUNT1 , ev.AUDIT_AMOUNT2 , ev.AUDIT_AMOUNT3 , ev.AUDIT_AMOUNT4 , ev.AUDIT_AMOUNT5 , ev.AUDIT_AMOUNT6 , ev.AUDIT_AMOUNT7 , ev.AUDIT_AMOUNT8 , ev.AUDIT_AMOUNT9 , ev.AUDIT_AMOUNT10 , ev.INVENTORY_ORG_ID , ev.INVENTORY_ITEM_ID , ev.QUANTITY_BILLED , ev.UOM_CODE , ev.UNIT_PRICE , ev.REFERENCE1 , ev.REFERENCE2 , ev.REFERENCE3 , ev.REFERENCE4 , ev.REFERENCE5 , ev.REFERENCE6 , ev.REFERENCE7 , ev.REFERENCE8 , ev.REFERENCE9 , ev.REFERENCE10 , ev.BILL_TRANS_CURRENCY_CODE , ev.BILL_TRANS_BILL_AMOUNT , ev.BILL_TRANS_REV_AMOUNT , mc.CURRENCY_CODE , mc.RATE_TYPE , ev.PROJFUNC_RATE_DATE , ev.PROJFUNC_EXCHANGE_RATE , mc.CONVERSION_DATE , mc.EXCHANGE_RATE , mc.REVENUE_AMOUNT , mc.PROJFUNC_INV_RATE_DATE , mc.PROJFUNC_INV_EXCHANGE_RATE , mc.BILL_AMOUNT , ev.PROJECT_CURRENCY_CODE , ev.PROJECT_RATE_TYPE , ev.PROJECT_RATE_DATE , ev.PROJECT_EXCHANGE_RATE , ev.PROJECT_REV_RATE_DATE , ev.PROJECT_REV_EXCHANGE_RATE , ev.PROJECT_REVENUE_AMOUNT , ev.PROJECT_INV_RATE_DATE , ev.PROJECT_INV_EXCHANGE_RATE , ev.PROJECT_BILL_AMOUNT , ev.FUNDING_RATE_TYPE , ev.FUNDING_RATE_DATE , ev.FUNDING_EXCHANGE_RATE , ev.REVPROC_CURRENCY_CODE , ev.REVPROC_RATE_TYPE , ev.REVPROC_RATE_DATE , ev.REVPROC_EXCHANGE_RATE , ev.INVPROC_CURRENCY_CODE , ev.INVPROC_RATE_TYPE , ev.INVPROC_RATE_DATE , ev.INVPROC_EXCHANGE_RATE , ev.INV_GEN_REJECTION_CODE , ev.BILLED_FLAG , ev.ADJUSTING_REVENUE_FLAG ,ev.zero_revenue_amount_flag ,ev.project_funding_id ,ev.revenue_hold_flag ,ev.non_updateable_flag ,ev.audit_cost_plan_type_id ,ev.audit_rev_plan_type_id ,ev.pm_product_code ,ev.pm_event_reference ,ev.deliverable_id ,ev.action_id ,ev.record_version_number FROM PA_EVENTS ev, PA_MC_EVENTS mc WHERE mc.event_id = ev.event_id AND mc.prc_assignment_id = -99 AND mc.set_of_books_id = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10) ),-99)

View Text - HTML Formatted

SELECT MC.SET_OF_BOOKS_ID
, MC.EVENT_ID
, MC.PROJECT_ID
, MC.TASK_ID
, MC.EVENT_NUM
, EV.REVENUE_AMOUNT
, EV.BILL_AMOUNT
, EV.LAST_UPDATE_DATE
, EV.LAST_UPDATED_BY
, EV.CREATION_DATE
, EV.CREATED_BY
, EV.LAST_UPDATE_LOGIN
, EV.EVENT_TYPE
, NVL(SUBSTR(MC.DESCRIPTION
, 1
, 240)
, SUBSTR(EV.DESCRIPTION
, 1
, 240))
, EV.REVENUE_DISTRIBUTED_FLAG
, EV.BILL_HOLD_FLAG
, EV.COMPLETION_DATE
, EV.REV_DIST_REJECTION_CODE
, EV.REQUEST_ID
, EV.PROGRAM_APPLICATION_ID
, EV.PROGRAM_ID
, EV.PROGRAM_UPDATE_DATE
, EV.ATTRIBUTE_CATEGORY
, EV.ATTRIBUTE1
, EV.ATTRIBUTE2
, EV.ATTRIBUTE3
, EV.ATTRIBUTE4
, EV.ATTRIBUTE5
, EV.ATTRIBUTE6
, EV.ATTRIBUTE7
, EV.ATTRIBUTE8
, EV.ATTRIBUTE9
, EV.ATTRIBUTE10
, EV.ORGANIZATION_ID
, EV.BILLING_ASSIGNMENT_ID
, EV.EVENT_NUM_REVERSED
, EV.CALLING_PLACE
, EV.CALLING_PROCESS
, EV.AUDIT_COST_BUDGET_TYPE_CODE
, EV.AUDIT_REV_BUDGET_TYPE_CODE
, EV.AUDIT_AMOUNT1
, EV.AUDIT_AMOUNT2
, EV.AUDIT_AMOUNT3
, EV.AUDIT_AMOUNT4
, EV.AUDIT_AMOUNT5
, EV.AUDIT_AMOUNT6
, EV.AUDIT_AMOUNT7
, EV.AUDIT_AMOUNT8
, EV.AUDIT_AMOUNT9
, EV.AUDIT_AMOUNT10
, EV.INVENTORY_ORG_ID
, EV.INVENTORY_ITEM_ID
, EV.QUANTITY_BILLED
, EV.UOM_CODE
, EV.UNIT_PRICE
, EV.REFERENCE1
, EV.REFERENCE2
, EV.REFERENCE3
, EV.REFERENCE4
, EV.REFERENCE5
, EV.REFERENCE6
, EV.REFERENCE7
, EV.REFERENCE8
, EV.REFERENCE9
, EV.REFERENCE10
, EV.BILL_TRANS_CURRENCY_CODE
, EV.BILL_TRANS_BILL_AMOUNT
, EV.BILL_TRANS_REV_AMOUNT
, MC.CURRENCY_CODE
, MC.RATE_TYPE
, EV.PROJFUNC_RATE_DATE
, EV.PROJFUNC_EXCHANGE_RATE
, MC.CONVERSION_DATE
, MC.EXCHANGE_RATE
, MC.REVENUE_AMOUNT
, MC.PROJFUNC_INV_RATE_DATE
, MC.PROJFUNC_INV_EXCHANGE_RATE
, MC.BILL_AMOUNT
, EV.PROJECT_CURRENCY_CODE
, EV.PROJECT_RATE_TYPE
, EV.PROJECT_RATE_DATE
, EV.PROJECT_EXCHANGE_RATE
, EV.PROJECT_REV_RATE_DATE
, EV.PROJECT_REV_EXCHANGE_RATE
, EV.PROJECT_REVENUE_AMOUNT
, EV.PROJECT_INV_RATE_DATE
, EV.PROJECT_INV_EXCHANGE_RATE
, EV.PROJECT_BILL_AMOUNT
, EV.FUNDING_RATE_TYPE
, EV.FUNDING_RATE_DATE
, EV.FUNDING_EXCHANGE_RATE
, EV.REVPROC_CURRENCY_CODE
, EV.REVPROC_RATE_TYPE
, EV.REVPROC_RATE_DATE
, EV.REVPROC_EXCHANGE_RATE
, EV.INVPROC_CURRENCY_CODE
, EV.INVPROC_RATE_TYPE
, EV.INVPROC_RATE_DATE
, EV.INVPROC_EXCHANGE_RATE
, EV.INV_GEN_REJECTION_CODE
, EV.BILLED_FLAG
, EV.ADJUSTING_REVENUE_FLAG
, EV.ZERO_REVENUE_AMOUNT_FLAG
, EV.PROJECT_FUNDING_ID
, EV.REVENUE_HOLD_FLAG
, EV.NON_UPDATEABLE_FLAG
, EV.AUDIT_COST_PLAN_TYPE_ID
, EV.AUDIT_REV_PLAN_TYPE_ID
, EV.PM_PRODUCT_CODE
, EV.PM_EVENT_REFERENCE
, EV.DELIVERABLE_ID
, EV.ACTION_ID
, EV.RECORD_VERSION_NUMBER
FROM PA_EVENTS EV
, PA_MC_EVENTS MC
WHERE MC.EVENT_ID = EV.EVENT_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)