View: PA_UBR_UER_ACCT_V

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

View Text

SELECT SU.UBR_UER_SUMMARY_ID
, SU.COST_CENTER_SEGMENT
, PA.SEGMENT1
, PA.NAME
, PA.PROJECT_ID
, PT.PROJECT_TYPE
, SU.UBR_UER_CODE
, GPS.PERIOD_NAME
, DECODE( (SELECT COUNT(*)
FROM PA_UBR_UER_SUMM_ACCT SU1
WHERE SU1.UBR_UER_SUMMARY_ID = SU.UBR_UER_SUMMARY_ID
AND SU1.GL_PERIOD_NAME = GPS.PERIOD_NAME)
, 0
, 0
, PA_CURRENCY.ROUND_CURRENCY_AMT(DECODE(SU.UBR_UER_CODE
, 'UBR_UER'
, (SU.UNBILLED_RECEIVABLE_DR -SU.UNEARNED_REVENUE_CR)
, 'UBR'
, (SU.UNBILLED_RECEIVABLE_DR)
, (SU.UNEARNED_REVENUE_CR)))) CUR_PER_AMOUNT
, SU.ACCOUNT_SEGMENT
, DECODE( (SELECT COUNT(*)
FROM PA_UBR_UER_SUMM_ACCT SU1
WHERE SU1.UBR_UER_SUMMARY_ID = SU.UBR_UER_SUMMARY_ID
AND SU1.GL_PERIOD_NAME = GPS.PERIOD_NAME)
, 0
, PA_CURRENCY.ROUND_CURRENCY_AMT(DECODE(SU.UBR_UER_CODE
, 'UBR_UER'
, ((SU.UBR_BAL_PREV_PERIOD_DR + SU.UNBILLED_RECEIVABLE_DR) -(SU.UER_BAL_PREV_PERIOD_CR + SU.UNEARNED_REVENUE_CR))
, 'UBR'
, (SU.UBR_BAL_PREV_PERIOD_DR + SU.UNBILLED_RECEIVABLE_DR)
, (SU.UER_BAL_PREV_PERIOD_CR + SU.UNEARNED_REVENUE_CR)))
, PA_CURRENCY.ROUND_CURRENCY_AMT(DECODE(SU.UBR_UER_CODE
, 'UBR_UER'
, (SU.UBR_BAL_PREV_PERIOD_DR -SU.UER_BAL_PREV_PERIOD_CR)
, 'UBR'
, (SU.UBR_BAL_PREV_PERIOD_DR)
, (SU.UER_BAL_PREV_PERIOD_CR)))) BAL_AS_OF_PREV_PERIOD
, PA_CURRENCY.ROUND_CURRENCY_AMT(DECODE(SU.UBR_UER_CODE
, 'UBR_UER'
, ((SU.UBR_BAL_PREV_PERIOD_DR + SU.UNBILLED_RECEIVABLE_DR) - (SU.UER_BAL_PREV_PERIOD_CR + SU.UNEARNED_REVENUE_CR))
, 'UBR'
, (SU.UBR_BAL_PREV_PERIOD_DR + SU.UNBILLED_RECEIVABLE_DR)
, (SU.UER_BAL_PREV_PERIOD_CR + SU.UNEARNED_REVENUE_CR))) BAL_AS_OF_CUR_PERIOD
, SU.ZERO_BALANCE_FLAG
, PIA.SET_OF_BOOKS_ID
, PIA.ORG_ID
FROM PA_UBR_UER_SUMM_ACCT SU
, PA_PROJECTS PA
, PA_PROJECT_TYPES_ALL PT
, PA_IMPLEMENTATIONS_ALL PIA
, GL_PERIOD_STATUSES GPS
WHERE 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 PIA.SET_OF_BOOKS_ID = GPS.SET_OF_BOOKS_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