VIEW: APPS.PA_UBR_UER_SUMM_PRJ_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.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

View Text - HTML Formatted

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