eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_MC_DRAFT_REVS_AR#

Source

View Text - Preformatted


select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, 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 from "PA"."PA_MC_DRAFT_REVS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, 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
FROM "PA"."PA_MC_DRAFT_REVS_AR"