View: PA_UBR_UER_PROJ_V

Product:	PA - Projects
Description:	This view is being used for reporting purpose in UBR and UER.This is UBR UER Project summary view
Implementation/DBA Data:	APPS.PA_UBR_UER_PROJ_V

View Text

SELECT PA.SEGMENT1 PROJECT_NUMBER
, PA.NAME PROJECT_NAME
, PA.PROJECT_ID PROJECT_ID
, PT.PROJECT_TYPE PROJECT_TYPE
, SU.UBR_UER_SUMMARY_ID UBR_UER_SUMMARY_ID
, SU.COST_CENTER_SEGMENT COST_CENTER
, GPS.PERIOD_NAME GL_PERIOD
, SU.GL_PERIOD_NAME SU_GL_PERIOD
, PA_CURRENCY.ROUND_CURRENCY_AMT((SU.UBR_BAL_PREV_PERIOD_DR + SU.UNBILLED_RECEIVABLE_DR)) UBR_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT((SU.UER_BAL_PREV_PERIOD_CR + SU.UNEARNED_REVENUE_CR)) UER_AMOUNT
, SU.ZERO_BALANCE_FLAG ZERO_BALANCE_FLAG
, SU.ACCOUNT_SEGMENT ACCOUNT
, SU.UBR_UER_CODE UBR_UER_CODE
, GPS.START_DATE GL_PERIOD_START_DATE
, SU.GL_PERIOD_START_DATE SU_GL_PERIOD_START_DATE
, SU.PROCESS_FLAG PROCESS_FLAG
, SU.REQUEST_ID REQUEST_ID
, SU.MULTI_COST_CENTER_FLAG MULTI_COST_CENTER_FLAG
, PIA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PIA.ORG_ID ORG_ID
FROM PA_UBR_UER_SUMM_ACCT SU
, PA_PROJECTS PA
, PA_PROJECT_TYPES_ALL PT
, GL_PERIOD_STATUSES GPS
, PA_IMPLEMENTATIONS_ALL PIA
WHERE PIA.SET_OF_BOOKS_ID = GPS.SET_OF_BOOKS_ID
AND PIA.ORG_ID = PT.ORG_ID
AND PT.PROJECT_TYPE = PA.PROJECT_TYPE
AND PT.ORG_ID = PA.ORG_ID
AND PA.PROJECT_ID = SU.PROJECT_ID
AND SU.GL_PERIOD_START_DATE <= GPS.START_DATE
AND GPS.APPLICATION_ID = 101
AND NOT EXISTS ( SELECT PROJECT_ID
FROM PA_UBR_UER_SUMM_ACCT SU1
WHERE SU1.GL_PERIOD_START_DATE <= GPS.START_DATE
AND SU1.GL_PERIOD_START_DATE > SU.GL_PERIOD_START_DATE
AND SU1.PROJECT_ID = SU.PROJECT_ID
AND SU1.COST_CENTER_SEGMENT = SU.COST_CENTER_SEGMENT
AND SU1.ACCOUNT_SEGMENT = SU.ACCOUNT_SEGMENT)

Columns