ZCA_OML_JOBS_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
JOB_ID USECASE_CODE STATUS SCHEDULE ADDITIONAL_METADATA CRITERIA_FILTER_EXPR STORE_PREDICTION STORE_PRED_VALUE_COL_NAME STORE_PRED_PROB_COL_NAME STORE_PRED_SCHEDULE STORE_PRED_CRITERIA_FILTER DEBUG_MESSAGE_DATA CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER JOB_NAME JOB_DESCRIPTION

Query

SQL_Statement

SELECT ZCA_OML_JOBS.JOB_ID, ZCA_OML_JOBS.USECASE_CODE, ZCA_OML_JOBS.STATUS, ZCA_OML_JOBS.SCHEDULE, ZCA_OML_JOBS.ADDITIONAL_METADATA, ZCA_OML_JOBS.CRITERIA_FILTER_EXPR, ZCA_OML_JOBS.STORE_PREDICTION, ZCA_OML_JOBS.STORE_PRED_VALUE_COL_NAME, ZCA_OML_JOBS.STORE_PRED_PROB_COL_NAME, ZCA_OML_JOBS.STORE_PRED_SCHEDULE, ZCA_OML_JOBS.STORE_PRED_CRITERIA_FILTER, ZCA_OML_JOBS.DEBUG_MESSAGE_DATA, ZCA_OML_JOBS.CREATED_BY, ZCA_OML_JOBS.CREATION_DATE, ZCA_OML_JOBS.LAST_UPDATED_BY, ZCA_OML_JOBS.LAST_UPDATE_DATE, ZCA_OML_JOBS.LAST_UPDATE_LOGIN, ZCA_OML_JOBS.OBJECT_VERSION_NUMBER, ZCA_OML_JOBS_TL.JOB_NAME, ZCA_OML_JOBS_TL.JOB_DESCRIPTION FROM ZCA_OML_JOBS, ZCA_OML_JOBS_TL WHERE ZCA_OML_JOBS.JOB_ID = ZCA_OML_JOBS_TL.JOB_ID and ZCA_OML_JOBS_TL.LANGUAGE = USERENV('LANG')