VIEW: PA.PA_MC_DRAFT_REVS_ALL#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PROJECT_ID PROJECT_ID, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TRANSFERRED_DATE TRANSFERRED_DATE, TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR, UNBILLED_BATCH_NAME UNBILLED_BATCH_NAME, UNEARNED_BATCH_NAME UNEARNED_BATCH_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REALIZED_GAINS_AMOUNT REALIZED_GAINS_AMOUNT, REALIZED_LOSSES_AMOUNT REALIZED_LOSSES_AMOUNT, REALIZED_GAINS_BATCH_NAME REALIZED_GAINS_BATCH_NAME, REALIZED_LOSSES_BATCH_NAME REALIZED_LOSSES_BATCH_NAME, XLA_MIGRATED_FLAG XLA_MIGRATED_FLAG from "PA"."PA_MC_DRAFT_REVS_ALL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PROJECT_ID PROJECT_ID
, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TRANSFERRED_DATE TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON
, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR
, UNBILLED_BATCH_NAME UNBILLED_BATCH_NAME
, UNEARNED_BATCH_NAME UNEARNED_BATCH_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REALIZED_GAINS_AMOUNT REALIZED_GAINS_AMOUNT
, REALIZED_LOSSES_AMOUNT REALIZED_LOSSES_AMOUNT
, REALIZED_GAINS_BATCH_NAME REALIZED_GAINS_BATCH_NAME
, REALIZED_LOSSES_BATCH_NAME REALIZED_LOSSES_BATCH_NAME
, XLA_MIGRATED_FLAG XLA_MIGRATED_FLAG
FROM "PA"."PA_MC_DRAFT_REVS_ALL"