VIEW: APPS.PA_EVENTS_MRC_V2

Source

View Text - Preformatted

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