Product: | PA - Projects |
---|---|
Description: | Single currency view |
Implementation/DBA Data: | Not implemented in this database |
SELECT MC.SET_OF_BOOKS_ID
, MC.AGREEMENT_ID
, MC.PROJECT_ID
, MC.TASK_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.TOTAL_UNBASELINED_AMOUNT
, PA.TOTAL_BASELINED_AMOUNT
, PA.TOTAL_ACCRUED_AMOUNT
, PA.TOTAL_BILLED_AMOUNT
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, MC.REQUEST_ID
, PA.FUNDING_CURRENCY_CODE
, PA.PROJECT_CURRENCY_CODE
, PA.PROJECT_UNBASELINED_AMOUNT
, PA.PROJECT_BASELINED_AMOUNT
, PA.PROJECT_ACCRUED_AMOUNT
, PA.PROJECT_BILLED_AMOUNT
, MC.CURRENCY_CODE
, MC.TOTAL_UNBASELINED_AMOUNT
, MC.TOTAL_BASELINED_AMOUNT
, MC.TOTAL_ACCRUED_AMOUNT
, MC.TOTAL_BILLED_AMOUNT
, PA.INVPROC_CURRENCY_CODE
, PA.INVPROC_UNBASELINED_AMOUNT
, PA.INVPROC_BASELINED_AMOUNT
, PA.INVPROC_BILLED_AMOUNT
, PA.REVPROC_CURRENCY_CODE
, PA.REVPROC_UNBASELINED_AMOUNT
, PA.REVPROC_BASELINED_AMOUNT
, PA.REVPROC_ACCRUED_AMOUNT
, MC.REALIZED_GAINS_AMT
, /* ADDED 3 COLUMNS FRO FUNDING REVAL */ MC.REALIZED_LOSSES_AMT
, PA.REVAL_REJECTION_CODE
FROM PA_SUMMARY_PROJECT_FUNDINGS PA
, PA_MC_SUM_PROJ_FUNDINGS MC
WHERE MC.PROJECT_ID = PA.PROJECT_ID
AND MC.AGREEMENT_ID = PA.AGREEMENT_ID
AND NVL(MC.TASK_ID
, -99) = NVL(PA.TASK_ID
, -99)
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)