View: PA_UBR_UER_SUMM_PRJ_V

Product:	PA - Projects
Description:	This view is being used for reporting purpose in UBR and UER. This lists the Unbilled Receivable and Unearned Revenue balances by gl period for all projects.
Implementation/DBA Data:	APPS.PA_UBR_UER_SUMM_PRJ_V

View Text

SELECT PA.SEGMENT1 PROJECT_NUMBER
, PA.NAME PROJECT_NAME
, PA.PROJECT_ID PROJECT_ID
, PT.PROJECT_TYPE PROJECT_TYPE
, SU.REQUEST_ID REQUEST_ID
, SU.GL_PERIOD_NAME GL_PERIOD_NAME
, PA_CURRENCY.ROUND_CURRENCY_AMT(SUM(SU.UNBILLED_RECEIVABLE_DR)) UNBILLED_RECEIVABLES_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT(SUM(SU.UNEARNED_REVENUE_CR))UNEARNED_REVENUE_AMOUNT
, SU.GL_PERIOD_START_DATE
FROM PA_UBR_UER_SUMM_ACCT SU
, PA_PROJECTS_ALL PA
, PA_PROJECT_TYPES_ALL PT
WHERE SU.PROJECT_ID = PA.PROJECT_ID
AND PA.PROJECT_TYPE = PT.PROJECT_TYPE
AND PA.ORG_ID = PT.ORG_ID GROUP BY PA.SEGMENT1
, PA.NAME
, PA.PROJECT_ID
, PT.PROJECT_TYPE
, SU.REQUEST_ID
, SU.GL_PERIOD_NAME
, SU.GL_PERIOD_START_DATE

Columns