[Home] [Help]
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
Name |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_ID |
PROJECT_TYPE |
GL_PERIOD |
REQUEST_ID |
REVENUE_AMOUNT |
UNBILLED_RECEIVABLES_AMOUNT |
UNEARNED_REVENUE_AMOUNT |
DRAFT_REVENUE_NUM |
GL_HEADER_ID |
GL_LINE_NUM |