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: PSA.PSA_MF_RCT_REC_BUF#

Source

View Text - Preformatted


select RA_RECEIVABLE_APPLICATION_ID RA_RECEIVABLE_APPLICATION_ID, USER_ID USER_ID, STATUS STATUS, ACTUAL_FLAG ACTUAL_FLAG, PST_CTRL_ID PST_CTRL_ID, SOB_ID SOB_ID, SOURCE SOURCE, TRADE_CAT_NAME TRADE_CAT_NAME, CCURR_CAT_NAME CCURR_CAT_NAME, CMAPP_CAT_NAME CMAPP_CAT_NAME, FUNC_CURR FUNC_CURR, PRE_TRADEAPP PRE_TRADEAPP, APP_ONACC APP_ONACC, APP_UNAPP APP_UNAPP, APP_UNID APP_UNID, APP_APPLIED APP_APPLIED, PRE_ERDISC PRE_ERDISC, PRE_REC_ERDISC_NRTAX PRE_REC_ERDISC_NRTAX, PRE_UNDISC PRE_UNDISC, PRE_REC_UNDISC_NRTAX PRE_REC_UNDISC_NRTAX, PRE_REC_GAIN PRE_REC_GAIN, PRE_REC_LOSS PRE_REC_LOSS, PRE_REC_CURR_ROUND PRE_REC_CURR_ROUND, PRE_REC_TAX PRE_REC_TAX, PRE_REC_DEFTAX PRE_REC_DEFTAX, CLASS_CB CLASS_CB, CLASS_CM CLASS_CM, CLASS_DEP CLASS_DEP, CLASS_DM CLASS_DM, CLASS_GUAR CLASS_GUAR, CLASS_INV CLASS_INV, POST_GENERAL POST_GENERAL, PRE_CMAPP PRE_CMAPP, PRE_CMGAIN PRE_CMGAIN, PRE_CMLOSS PRE_CMLOSS, BATCH_PREFIX BATCH_PREFIX, SUMMARY_FLAG SUMMARY_FLAG, PRE_RECEIPT PRE_RECEIPT, POST_RECEIPT POST_RECEIPT, NXTVAL_ID NXTVAL_ID, START_DATE START_DATE, POST_THRU_DATE POST_THRU_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "PSA"."PSA_MF_RCT_REC_BUF"

View Text - HTML Formatted

SELECT RA_RECEIVABLE_APPLICATION_ID RA_RECEIVABLE_APPLICATION_ID
, USER_ID USER_ID
, STATUS STATUS
, ACTUAL_FLAG ACTUAL_FLAG
, PST_CTRL_ID PST_CTRL_ID
, SOB_ID SOB_ID
, SOURCE SOURCE
, TRADE_CAT_NAME TRADE_CAT_NAME
, CCURR_CAT_NAME CCURR_CAT_NAME
, CMAPP_CAT_NAME CMAPP_CAT_NAME
, FUNC_CURR FUNC_CURR
, PRE_TRADEAPP PRE_TRADEAPP
, APP_ONACC APP_ONACC
, APP_UNAPP APP_UNAPP
, APP_UNID APP_UNID
, APP_APPLIED APP_APPLIED
, PRE_ERDISC PRE_ERDISC
, PRE_REC_ERDISC_NRTAX PRE_REC_ERDISC_NRTAX
, PRE_UNDISC PRE_UNDISC
, PRE_REC_UNDISC_NRTAX PRE_REC_UNDISC_NRTAX
, PRE_REC_GAIN PRE_REC_GAIN
, PRE_REC_LOSS PRE_REC_LOSS
, PRE_REC_CURR_ROUND PRE_REC_CURR_ROUND
, PRE_REC_TAX PRE_REC_TAX
, PRE_REC_DEFTAX PRE_REC_DEFTAX
, CLASS_CB CLASS_CB
, CLASS_CM CLASS_CM
, CLASS_DEP CLASS_DEP
, CLASS_DM CLASS_DM
, CLASS_GUAR CLASS_GUAR
, CLASS_INV CLASS_INV
, POST_GENERAL POST_GENERAL
, PRE_CMAPP PRE_CMAPP
, PRE_CMGAIN PRE_CMGAIN
, PRE_CMLOSS PRE_CMLOSS
, BATCH_PREFIX BATCH_PREFIX
, SUMMARY_FLAG SUMMARY_FLAG
, PRE_RECEIPT PRE_RECEIPT
, POST_RECEIPT POST_RECEIPT
, NXTVAL_ID NXTVAL_ID
, START_DATE START_DATE
, POST_THRU_DATE POST_THRU_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "PSA"."PSA_MF_RCT_REC_BUF"