VIEW: ICX.ICX_CAT_R12_UPGRADE_JOBS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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