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

VIEW: ICX.ICX_CAT_R12_UPGRADE_JOBS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_TYPE VARCHAR2 (20) Yes
JOB_NUMBER NUMBER
Yes
STATUS VARCHAR2 (1)
RUN_DATE DATE

AUDSID NUMBER

PREUPG_COMPLETE_DATE DATE

PREUPG_PDOI_UPDATE_DATE DATE

PREUPG_PDOI_COMPLETE_DATE DATE

PREUPG_BPA_COMPLETE_DATE DATE

PREUPG_QUOTE_COMPLETE_DATE DATE

PREUPG_REQTMPLT_COMPLETE_DATE DATE

PREUPG_MI_COMPLETE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
REQUEST_ID NUMBER

INTERNAL_REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

PDOI_BATCH_ID NUMBER

AUDSID2 NUMBER

Query Text

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


SELECT JOB_TYPE
,      JOB_NUMBER
,      STATUS
,      RUN_DATE
,      AUDSID
,      PREUPG_COMPLETE_DATE
,      PREUPG_PDOI_UPDATE_DATE
,      PREUPG_PDOI_COMPLETE_DATE
,      PREUPG_BPA_COMPLETE_DATE
,      PREUPG_QUOTE_COMPLETE_DATE
,      PREUPG_REQTMPLT_COMPLETE_DATE
,      PREUPG_MI_COMPLETE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      INTERNAL_REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PDOI_BATCH_ID
,      AUDSID2
FROM ICX.ICX_CAT_R12_UPGRADE_JOBS#;

Dependencies

[top of page]

ICX.ICX_CAT_R12_UPGRADE_JOBS# references the following:

SchemaICX
TableICX_CAT_R12_UPGRADE_JOBS
ICX.ICX_CAT_R12_UPGRADE_JOBS# is referenced by following:

SchemaAPPS
SynonymICX_CAT_R12_UPGRADE_JOBS