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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PSA.PSA_MF_RCT_REC_BUF#

Object Details

Object Name:	PSA_MF_RCT_REC_BUF#
Object Type:	VIEW
Owner:	PSA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RA_RECEIVABLE_APPLICATION_ID	NUMBER
USER_ID	NUMBER
STATUS	VARCHAR2	(240)
ACTUAL_FLAG	VARCHAR2	(240)
PST_CTRL_ID	NUMBER
SOB_ID	NUMBER
SOURCE	VARCHAR2	(240)
TRADE_CAT_NAME	VARCHAR2	(240)
CCURR_CAT_NAME	VARCHAR2	(240)
CMAPP_CAT_NAME	VARCHAR2	(240)
FUNC_CURR	VARCHAR2	(240)
PRE_TRADEAPP	VARCHAR2	(240)
APP_ONACC	VARCHAR2	(240)
APP_UNAPP	VARCHAR2	(240)
APP_UNID	VARCHAR2	(240)
APP_APPLIED	VARCHAR2	(240)
PRE_ERDISC	VARCHAR2	(240)
PRE_REC_ERDISC_NRTAX	VARCHAR2	(240)
PRE_UNDISC	VARCHAR2	(240)
PRE_REC_UNDISC_NRTAX	VARCHAR2	(240)
PRE_REC_GAIN	VARCHAR2	(240)
PRE_REC_LOSS	VARCHAR2	(240)
PRE_REC_CURR_ROUND	VARCHAR2	(240)
PRE_REC_TAX	VARCHAR2	(240)
PRE_REC_DEFTAX	VARCHAR2	(240)
CLASS_CB	VARCHAR2	(240)
CLASS_CM	VARCHAR2	(240)
CLASS_DEP	VARCHAR2	(240)
CLASS_DM	VARCHAR2	(240)
CLASS_GUAR	VARCHAR2	(240)
CLASS_INV	VARCHAR2	(240)
POST_GENERAL	VARCHAR2	(240)
PRE_CMAPP	VARCHAR2	(240)
PRE_CMGAIN	VARCHAR2	(240)
PRE_CMLOSS	VARCHAR2	(240)
BATCH_PREFIX	VARCHAR2	(240)
SUMMARY_FLAG	VARCHAR2	(240)
PRE_RECEIPT	VARCHAR2	(240)
POST_RECEIPT	VARCHAR2	(240)
NXTVAL_ID	NUMBER
START_DATE	DATE
POST_THRU_DATE	DATE
LAST_UPDATE_DATE	DATE		Yes

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PSA.PSA_MF_RCT_REC_BUF# references the following:

PSA: PSA_MF_RCT_REC_BUF

PSA.PSA_MF_RCT_REC_BUF# is referenced by following:

APPS: PSA_MF_RCT_REC_BUF