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_ADJ_REC_BUF#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ADJUSTMENT_ID	NUMBER
USER_ID	NUMBER
STATUS	VARCHAR2	(240)
ACTUAL_FLAG	VARCHAR2	(240)
PST_CTRL_ID	NUMBER
SOB_ID	NUMBER
SOURCE	VARCHAR2	(240)
ADJ_CAT_NAME	VARCHAR2	(240)
BATCH_PREFIX	VARCHAR2	(240)
SUMMARY_FLAG	VARCHAR2	(240)
PRE_ADJCR_AR	VARCHAR2	(240)
PRE_ADJDR_AR	VARCHAR2	(240)
PRE_ADJDR_ADJ	VARCHAR2	(240)
PRE_ADJCR_ADJ	VARCHAR2	(240)
PRE_ADJDR	VARCHAR2	(240)
PRE_ADJCR	VARCHAR2	(240)
PRE_ADJ_NRTAX	VARCHAR2	(240)
PRE_ADJ_FINCHRG	VARCHAR2	(240)
PRE_ADJ_FINCHRG_NRTAX	VARCHAR2	(240)
PRE_ADJ_TAX	VARCHAR2	(240)
PRE_ADJ_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)
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 ADJUSTMENT_ID
,      USER_ID
,      STATUS
,      ACTUAL_FLAG
,      PST_CTRL_ID
,      SOB_ID
,      SOURCE
,      ADJ_CAT_NAME
,      BATCH_PREFIX
,      SUMMARY_FLAG
,      PRE_ADJCR_AR
,      PRE_ADJDR_AR
,      PRE_ADJDR_ADJ
,      PRE_ADJCR_ADJ
,      PRE_ADJDR
,      PRE_ADJCR
,      PRE_ADJ_NRTAX
,      PRE_ADJ_FINCHRG
,      PRE_ADJ_FINCHRG_NRTAX
,      PRE_ADJ_TAX
,      PRE_ADJ_DEFTAX
,      CLASS_CB
,      CLASS_CM
,      CLASS_DEP
,      CLASS_DM
,      CLASS_GUAR
,      CLASS_INV
,      POST_GENERAL
,      NXTVAL_ID
,      START_DATE
,      POST_THRU_DATE
,      LAST_UPDATE_DATE
FROM PSA.PSA_MF_ADJ_REC_BUF#;

Dependencies

[top of page]

PSA.PSA_MF_ADJ_REC_BUF# references the following:

PSA: PSA_MF_ADJ_REC_BUF

PSA.PSA_MF_ADJ_REC_BUF# is referenced by following:

APPS: PSA_MF_ADJ_REC_BUF