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_PROJ_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)