Product: | PA - Projects |
---|---|
Description: | Single currency view |
Implementation/DBA Data: | Not implemented in this database |
SELECT MC.SET_OF_BOOKS_ID
, MC.PROJECT_FUNDING_ID
, PAPF.LAST_UPDATE_DATE
, PAPF.LAST_UPDATED_BY
, PAPF.CREATION_DATE
, PAPF.CREATED_BY
, PAPF.LAST_UPDATE_LOGIN
, PAPF.AGREEMENT_ID
, PAPF.PROJECT_ID
, PAPF.TASK_ID
, PAPF.BUDGET_TYPE_CODE
, PAPF.ALLOCATED_AMOUNT
, PAPF.DATE_ALLOCATED
, PAPF.ATTRIBUTE_CATEGORY
, PAPF.ATTRIBUTE1
, PAPF.ATTRIBUTE2
, PAPF.ATTRIBUTE3
, PAPF.ATTRIBUTE4
, PAPF.ATTRIBUTE5
, PAPF.ATTRIBUTE6
, PAPF.ATTRIBUTE7
, PAPF.ATTRIBUTE8
, PAPF.ATTRIBUTE9
, PAPF.ATTRIBUTE10
, PAPF.PA_PROJECT_FUNDINGS_PROJECT_ID
, PAPF.PM_FUNDING_REFERENCE
, PAPF.PM_PRODUCT_CODE
, PAPF.FUNDING_CURRENCY_CODE
, PAPF.PROJECT_CURRENCY_CODE
, PAPF.PROJECT_RATE_TYPE
, PAPF.PROJECT_RATE_DATE
, PAPF.PROJECT_EXCHANGE_RATE
, PAPF.PROJECT_ALLOCATED_AMOUNT
, MC.CURRENCY_CODE
, MC.RATE_TYPE
, MC.CONVERSION_DATE
, MC.EXCHANGE_RATE
, MC.ALLOCATED_AMOUNT
, PAPF.INVPROC_CURRENCY_CODE
, PAPF.INVPROC_RATE_TYPE
, PAPF.INVPROC_RATE_DATE
, PAPF.INVPROC_EXCHANGE_RATE
, PAPF.INVPROC_ALLOCATED_AMOUNT
, PAPF.REVPROC_CURRENCY_CODE
, PAPF.REVPROC_RATE_TYPE
, PAPF.REVPROC_RATE_DATE
, PAPF.REVPROC_EXCHANGE_RATE
, PAPF.REVPROC_ALLOCATED_AMOUNT
, PAPF.FUNDING_CATEGORY
, PAPF.PJI_SUMMARIZED_FLAG
, MC.REQUEST_ID
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, PAPF.REVALUATION_THROUGH_DATE
, /* ADDED 22 COLUMN FOR FUNDING REVAL */ PAPF.REVALUATION_RATE_DATE
, PAPF.REVALUATION_PROJFUNC_RATE_TYPE
, PAPF.REVALUATION_INVPROC_RATE_TYPE
, PAPF.REVALUATION_PROJFUNC_RATE
, PAPF.REVALUATION_INVPROC_RATE
, PAPF.FUNDING_INV_APPLIED_AMOUNT
, PAPF.FUNDING_INV_DUE_AMOUNT
, PAPF.FUNDING_BACKLOG_AMOUNT
, MC.REALIZED_GAINS_AMT
, MC.REALIZED_LOSSES_AMT
, MC.INV_APPLIED_AMOUNT
, MC.INV_DUE_AMOUNT
, MC.BACKLOG_AMOUNT
, MC.REVAL_AMOUNT
, MC.REVALUED_AMOUNT
, PAPF.NON_UPDATEABLE_FLAG
, PAPF.INVPROC_BACKLOG_AMOUNT
, PAPF.FUNDING_REVAL_AMOUNT
, PAPF.INVPROC_REVAL_AMOUNT
, PAPF.INVPROC_REVALUED_AMOUNT
, PAPF.FUNDING_REVALUATION_FACTOR
, PAPF.CI_ID
FROM PA_PROJECT_FUNDINGS PAPF
, PA_MC_PROJECT_FUNDINGS MC
WHERE MC.PROJECT_FUNDING_ID = PAPF.PROJECT_FUNDING_ID
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)