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

VIEW: PSA.PSA_XLA_ACCOUNTING_ERRORS#

Object Details
Object Name: PSA_XLA_ACCOUNTING_ERRORS#
Object Type: VIEW
Owner: PSA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCOUNTING_ERROR_ID NUMBER (15) Yes
APPLICATION_ID NUMBER (15)
LEDGER_ID NUMBER (15)
ENTITY_CODE VARCHAR2 (30)
ENTITY_ID NUMBER (15)
EVENT_DATE DATE

EVENT_ID NUMBER (15)
TRANSACTION_NUMBER VARCHAR2 (240)
AE_HEADER_ID NUMBER (15)
AE_LINE_NUM NUMBER (15)
SOURCE_ID_INT_1 NUMBER (15)
SOURCE_ID_INT_2 NUMBER (15)
SOURCE_ID_INT_3 NUMBER (15)
SOURCE_ID_INT_4 NUMBER (15)
SOURCE_ID_CHAR_1 VARCHAR2 (240)
SOURCE_ID_CHAR_2 VARCHAR2 (240)
SOURCE_ID_CHAR_3 VARCHAR2 (240)
SOURCE_ID_CHAR_4 VARCHAR2 (240)
MESSAGE_CODE VARCHAR2 (240)
MESSAGE_NUM NUMBER (15)
ENCODED_MSG VARCHAR2 (2000)
AUDSID NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
Query Text

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


SELECT ACCOUNTING_ERROR_ID
,      APPLICATION_ID
,      LEDGER_ID
,      ENTITY_CODE
,      ENTITY_ID
,      EVENT_DATE
,      EVENT_ID
,      TRANSACTION_NUMBER
,      AE_HEADER_ID
,      AE_LINE_NUM
,      SOURCE_ID_INT_1
,      SOURCE_ID_INT_2
,      SOURCE_ID_INT_3
,      SOURCE_ID_INT_4
,      SOURCE_ID_CHAR_1
,      SOURCE_ID_CHAR_2
,      SOURCE_ID_CHAR_3
,      SOURCE_ID_CHAR_4
,      MESSAGE_CODE
,      MESSAGE_NUM
,      ENCODED_MSG
,      AUDSID
,      CREATION_DATE
,      CREATED_BY
FROM PSA.PSA_XLA_ACCOUNTING_ERRORS#;

Dependencies

[top of page]

PSA.PSA_XLA_ACCOUNTING_ERRORS# references the following:

SchemaPSA
TablePSA_XLA_ACCOUNTING_ERRORS
PSA.PSA_XLA_ACCOUNTING_ERRORS# is referenced by following:

SchemaAPPS
SynonymPSA_XLA_ACCOUNTING_ERRORS