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

VIEW: ICX.ICX_CAT_BATCH_JOBS_ALL#

Object Details
Object Name: ICX_CAT_BATCH_JOBS_ALL#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_NUMBER NUMBER
Yes
JOB_TYPE VARCHAR2 (40) Yes
JOB_STATUS VARCHAR2 (240) Yes
USER_FILE_NAME VARCHAR2 (500)
FILE_CONTENT BLOB (4000)
ROLE VARCHAR2 (10)
PO_HEADER_ID NUMBER

DOCUMENT_TYPE_CODE VARCHAR2 (25)
DOCUMENT_NUMBER VARCHAR2 (20)
ORG_ID NUMBER

INTERFACE_HEADER_ID NUMBER

LINES_PROCESSED NUMBER

LINES_FAILED NUMBER

FAILURE_MESSAGE VARCHAR2 (4000)
SYSTEM_FAILURE_MESSAGE VARCHAR2 (4000)
SUBMISSION_DATETIME DATE

START_DATETIME DATE

COMPLETION_DATETIME DATE

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
SESSION_ID NUMBER

Query Text

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


SELECT JOB_NUMBER
,      JOB_TYPE
,      JOB_STATUS
,      USER_FILE_NAME
,      FILE_CONTENT
,      ROLE
,      PO_HEADER_ID
,      DOCUMENT_TYPE_CODE
,      DOCUMENT_NUMBER
,      ORG_ID
,      INTERFACE_HEADER_ID
,      LINES_PROCESSED
,      LINES_FAILED
,      FAILURE_MESSAGE
,      SYSTEM_FAILURE_MESSAGE
,      SUBMISSION_DATETIME
,      START_DATETIME
,      COMPLETION_DATETIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SESSION_ID
FROM ICX.ICX_CAT_BATCH_JOBS_ALL#;

Dependencies

[top of page]

ICX.ICX_CAT_BATCH_JOBS_ALL# references the following:

SchemaICX
TableICX_CAT_BATCH_JOBS_ALL
ICX.ICX_CAT_BATCH_JOBS_ALL# is referenced by following:

SchemaAPPS
SynonymICX_CAT_BATCH_JOBS
SynonymICX_CAT_BATCH_JOBS_ALL