View: PA_EVENTS_MRC_V2

Product:	PA - Projects
Description:	Single currency view
Implementation/DBA Data:	APPS.PA_EVENTS_MRC_V2

View Text

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)

Columns