VIEW: APPS.PA_UBR_UER_INV_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(di.org_id,di.gl_date) Gl_Period, di.request_id Request_Id, PA_CURRENCY.round_currency_amt((di.unearned_revenue_cr - di.unbilled_receivable_dr)) Invoice_Amount, PA_CURRENCY.round_currency_amt(di.unbilled_receivable_dr) Unbilled_Receivables_Amount, PA_CURRENCY.round_currency_amt(di.unearned_revenue_cr) Unearned_Revenue_Amount, di.draft_invoice_num Draft_Invoice_Num FROM pa_projects_all pa,pa_project_types_all pt, pa_draft_invoices_all di WHERE di.project_id = pa.project_id 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(DI.ORG_ID
, DI.GL_DATE) GL_PERIOD
, DI.REQUEST_ID REQUEST_ID
, PA_CURRENCY.ROUND_CURRENCY_AMT((DI.UNEARNED_REVENUE_CR - DI.UNBILLED_RECEIVABLE_DR)) INVOICE_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT(DI.UNBILLED_RECEIVABLE_DR) UNBILLED_RECEIVABLES_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT(DI.UNEARNED_REVENUE_CR) UNEARNED_REVENUE_AMOUNT
, DI.DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
FROM PA_PROJECTS_ALL PA
, PA_PROJECT_TYPES_ALL PT
, PA_DRAFT_INVOICES_ALL DI
WHERE DI.PROJECT_ID = PA.PROJECT_ID
AND PA.PROJECT_TYPE = PT.PROJECT_TYPE
AND PA.ORG_ID = PT.ORG_ID