VIEW: APPS.PA_UBR_UER_DR_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, PA_UBR_UER_SUMM_PKG.get_gl_period_name(dr.org_id,dr.gl_date) Gl_Period, dr.request_id Request_Id, PA_CURRENCY.round_currency_amt((dr.unbilled_receivable_dr - dr.unearned_revenue_cr)) Revenue_Amount, PA_CURRENCY.round_currency_amt(dr.unbilled_receivable_dr) Unbilled_Receivables_Amount, PA_CURRENCY.round_currency_amt(dr.unearned_revenue_cr) Unearned_Revenue_Amount, dr.draft_revenue_num Draft_Revenue_Num, jel.je_header_id Gl_Header_Id, jel.je_line_num Gl_Line_Num FROM pa_projects_all pa,pa_project_types_all pt, pa_draft_revenues_all dr,gl_je_lines jel WHERE dr.project_id = pa.project_id AND dr.unbilled_batch_name = jel.reference_1(+) AND dr.unbilled_code_combination_id = jel.code_combination_id(+) AND jel.reference_3(+) = 'Revenue - UBR' AND pa.project_type = pt.project_type AND pa.org_id = pt.org_id

View Text - HTML Formatted

SELECT PA.SEGMENT1 PROJECT_NUMBER
, PA.NAME PROJECT_NAME
, PA.PROJECT_ID PROJECT_ID
, PT.PROJECT_TYPE PROJECT_TYPE
, PA_UBR_UER_SUMM_PKG.GET_GL_PERIOD_NAME(DR.ORG_ID
, DR.GL_DATE) GL_PERIOD
, DR.REQUEST_ID REQUEST_ID
, PA_CURRENCY.ROUND_CURRENCY_AMT((DR.UNBILLED_RECEIVABLE_DR - DR.UNEARNED_REVENUE_CR)) REVENUE_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT(DR.UNBILLED_RECEIVABLE_DR) UNBILLED_RECEIVABLES_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT(DR.UNEARNED_REVENUE_CR) UNEARNED_REVENUE_AMOUNT
, DR.DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, JEL.JE_HEADER_ID GL_HEADER_ID
, JEL.JE_LINE_NUM GL_LINE_NUM
FROM PA_PROJECTS_ALL PA
, PA_PROJECT_TYPES_ALL PT
, PA_DRAFT_REVENUES_ALL DR
, GL_JE_LINES JEL
WHERE DR.PROJECT_ID = PA.PROJECT_ID
AND DR.UNBILLED_BATCH_NAME = JEL.REFERENCE_1(+)
AND DR.UNBILLED_CODE_COMBINATION_ID = JEL.CODE_COMBINATION_ID(+)
AND JEL.REFERENCE_3(+) = 'REVENUE - UBR'
AND PA.PROJECT_TYPE = PT.PROJECT_TYPE
AND PA.ORG_ID = PT.ORG_ID