eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_UBR_UER_ACCT_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)