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 Comments
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:

SchemaPSA
TablePSA_MF_ADJ_REC_BUF
PSA.PSA_MF_ADJ_REC_BUF# is referenced by following:

SchemaAPPS
SynonymPSA_MF_ADJ_REC_BUF