View: PA_UBR_UER_DR_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 revenues.
Implementation/DBA Data:	APPS.PA_UBR_UER_DR_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(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

Columns