View: PA_DRAFT_REVENUES_ALL_MRC_V2

Product:	PA - Projects
Description:	Multi-org, single currency view
Implementation/DBA Data:	APPS.PA_DRAFT_REVENUES_ALL_MRC_V2

View Text

SELECT MC.PROJECT_ID
, MC.DRAFT_REVENUE_NUM
, MC.TRANSFER_STATUS_CODE
, MC.REQUEST_ID
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, MC.TRANSFERRED_DATE
, MC.TRANSFER_REJECTION_REASON
, MC.UNBILLED_RECEIVABLE_DR
, MC.UNEARNED_REVENUE_CR
, MC.UNBILLED_BATCH_NAME
, MC.UNEARNED_BATCH_NAME
, MC.LAST_UPDATE_DATE
, MC.LAST_UPDATED_BY
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.AGREEMENT_ID
, PA.GENERATION_ERROR_FLAG
, PA.PA_DATE
, PA.RESOURCE_ACCUMULATED_FLAG
, PA.CUSTOMER_BILL_SPLIT
, PA.ACCRUE_THROUGH_DATE
, PA.RELEASED_DATE
, PA.UNBILLED_CODE_COMBINATION_ID
, PA.UNEARNED_CODE_COMBINATION_ID
, PA.GL_DATE
, PA.ACCUMULATED_FLAG
, PA.DRAFT_REVENUE_NUM_CREDITED
, MC.LAST_UPDATE_LOGIN
, PA.ORG_ID
, PA.GL_PERIOD_NAME
, PA.PA_PERIOD_NAME
, PA.ADJUSTING_REVENUE_FLAG
, PA.PJI_SUMMARIZED_FLAG
, PA.UBR_SUMMARY_ID
, PA.UER_SUMMARY_ID
, PA.UBR_UER_PROCESS_FLAG
, MC.REALIZED_GAINS_AMOUNT
, MC.REALIZED_LOSSES_AMOUNT
, PA.REALIZED_GAINS_CCID
, PA.REALIZED_LOSSES_CCID
, MC.REALIZED_GAINS_BATCH_NAME
, MC.REALIZED_LOSSES_BATCH_NAME
, PA.EVENT_ID
FROM PA_DRAFT_REVENUES_ALL PA
, PA_MC_DRAFT_REVS_ALL MC
WHERE MC.PROJECT_ID = PA.PROJECT_ID
AND MC.DRAFT_REVENUE_NUM = PA.DRAFT_REVENUE_NUM
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)

Columns