Product: | PA - Projects |
---|---|
Description: | Single currency view |
Implementation/DBA Data: | APPS.PA_EVENTS_MRC_V |
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)