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

VIEW: PSP.PSP_REPORT_ERRORS#

Object Details
Object Name: PSP_REPORT_ERRORS#
Object Type: VIEW
Owner: PSP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ERROR_SEQUENCE_ID VARCHAR2 (240) Yes
REQUEST_ID NUMBER
Yes
MESSAGE_LEVEL VARCHAR2 (1) Yes
SOURCE_ID NUMBER (15)
ERROR_MESSAGE VARCHAR2 (2000) Yes
RETRY_REQUEST_ID NUMBER (15)
PDF_REQUEST_ID NUMBER (15)
SOURCE_NAME VARCHAR2 (1000)
PARENT_SOURCE_ID NUMBER (15)
PARENT_SOURCE_NAME VARCHAR2 (1000)
PAYROLL_ACTION_ID NUMBER

VALUE1 NUMBER

VALUE2 NUMBER

VALUE3 NUMBER

VALUE4 NUMBER

VALUE5 NUMBER

VALUE6 NUMBER

VALUE7 NUMBER

VALUE8 NUMBER

VALUE9 NUMBER

VALUE10 NUMBER

INFORMATION1 VARCHAR2 (1000)
INFORMATION2 VARCHAR2 (1000)
INFORMATION3 VARCHAR2 (1000)
INFORMATION4 VARCHAR2 (1000)
INFORMATION5 VARCHAR2 (1000)
INFORMATION6 VARCHAR2 (1000)
INFORMATION7 VARCHAR2 (1000)
INFORMATION8 VARCHAR2 (1000)
INFORMATION9 VARCHAR2 (1000)
INFORMATION10 VARCHAR2 (1000)
Query Text

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


SELECT ERROR_SEQUENCE_ID
,      REQUEST_ID
,      MESSAGE_LEVEL
,      SOURCE_ID
,      ERROR_MESSAGE
,      RETRY_REQUEST_ID
,      PDF_REQUEST_ID
,      SOURCE_NAME
,      PARENT_SOURCE_ID
,      PARENT_SOURCE_NAME
,      PAYROLL_ACTION_ID
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
FROM PSP.PSP_REPORT_ERRORS#;

Dependencies

[top of page]

PSP.PSP_REPORT_ERRORS# references the following:

SchemaPSP
TablePSP_REPORT_ERRORS
PSP.PSP_REPORT_ERRORS# is referenced by following:

SchemaAPPS
SynonymPSP_REPORT_ERRORS