VIEW: APPS.PA_DRAFT_REVENUES_ALL_MRC_V2

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)