View: PA_UBR_UER_INV_PRJ_V

Product:	PA - Projects
Description:	This view is being used for reporting purpose in UBR and UER.This lists the Unearned Revenue and Unbilled Receivable for draft Invoices.
Implementation/DBA Data:	APPS.PA_UBR_UER_INV_PRJ_V

View Text

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

Columns