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

TABLE: PSA.PSA_XLA_UNDO_ACCT_AUDIT

Object Details
Object Name: PSA_XLA_UNDO_ACCT_AUDIT
Object Type: TABLE
Owner: PSA
Subobject Name:
Status: VALID


Table to store audit details of SLA undo accounting


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AUDIT_ID NUMBER (15) Yes Audit Sequence Identifier
USER_ID NUMBER (15)
User Identifier
RESP_ID NUMBER (15)
Responsibility Identifier
LOGIN_ID NUMBER (15)
Login Identifier
REQUEST_ID NUMBER (15)
Request Identifier
START_DATE DATE

Start Date
END_DATE DATE

End Date
APPLICATION_ID NUMBER (15)
Application Identifier
ENTITY_CODE VARCHAR2 (30)
SLA Entity Code
DOCUMENT_NUM VARCHAR2 (240)
Document Number
GL_DATE DATE

General Ledger Date
PROGRAM_STATUS VARCHAR2 (10)
Program Status
PROGRAM_MESG VARCHAR2 (2000)
Program Message
SOURCE_ID_INT_1 NUMBER

Source ID INT 1
SOURCE_ID_INT_2 NUMBER

Source ID INT 2
SOURCE_ID_INT_3 NUMBER

Source ID INT 3
SOURCE_ID_INT_4 NUMBER

Source ID INT 4
SOURCE_ID_CHAR_1 VARCHAR2 (30)
Source ID Char 1
SOURCE_ID_CHAR_2 VARCHAR2 (30)
Source ID Char 2
SOURCE_ID_CHAR_3 VARCHAR2 (30)
Source ID Char 3
SOURCE_ID_CHAR_4 VARCHAR2 (30)
Source ID Char 4
TAR_NUMBER VARCHAR2 (100)
Service Request Number
BUG_NUMBER VARCHAR2 (100)
Bug Number
PROGRAM_MODE VARCHAR2 (15)
Program Mode
Query Text

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


SELECT AUDIT_ID
,      USER_ID
,      RESP_ID
,      LOGIN_ID
,      REQUEST_ID
,      START_DATE
,      END_DATE
,      APPLICATION_ID
,      ENTITY_CODE
,      DOCUMENT_NUM
,      GL_DATE
,      PROGRAM_STATUS
,      PROGRAM_MESG
,      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
,      TAR_NUMBER
,      BUG_NUMBER
,      PROGRAM_MODE
FROM PSA.PSA_XLA_UNDO_ACCT_AUDIT;

Dependencies

[top of page]

PSA.PSA_XLA_UNDO_ACCT_AUDIT does not reference any database object

PSA.PSA_XLA_UNDO_ACCT_AUDIT is referenced by following:

SchemaPSA
ViewPSA_XLA_UNDO_ACCT_AUDIT#