1. Tables and Views for Sales and Fusion Service
  2. ZCA_OML_JOBS_SEL_FIELDS_VL

ZCA_OML_JOBS_SEL_FIELDS_VL

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

JOB_ID

FIELD_NAME

USECASE_CODE

FIELD_DATA_TYPE

IS_FEATURE

ADDITIONAL_METADATA

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

FIELD_TITLE

Query

SQL_Statement

SELECT

ZCA_OML_JOBS_SEL_FIELDS.JOB_ID,

ZCA_OML_JOBS_SEL_FIELDS.FIELD_NAME,

ZCA_OML_JOBS_SEL_FIELDS.USECASE_CODE,

ZCA_OML_JOBS_SEL_FIELDS.FIELD_DATA_TYPE,

ZCA_OML_JOBS_SEL_FIELDS.IS_FEATURE,

ZCA_OML_JOBS_SEL_FIELDS.ADDITIONAL_METADATA,

ZCA_OML_JOBS_SEL_FIELDS.CREATED_BY,

ZCA_OML_JOBS_SEL_FIELDS.CREATION_DATE,

ZCA_OML_JOBS_SEL_FIELDS.LAST_UPDATED_BY,

ZCA_OML_JOBS_SEL_FIELDS.LAST_UPDATE_DATE,

ZCA_OML_JOBS_SEL_FIELDS.LAST_UPDATE_LOGIN,

ZCA_OML_JOBS_SEL_FIELDS.OBJECT_VERSION_NUMBER,

ZCA_OML_JOBS_SEL_FIELDS_TL.FIELD_TITLE

FROM

ZCA_OML_JOBS_SEL_FIELDS,

ZCA_OML_JOBS_SEL_FIELDS_TL

WHERE

ZCA_OML_JOBS_SEL_FIELDS.JOB_ID = ZCA_OML_JOBS_SEL_FIELDS_TL.JOB_ID and ZCA_OML_JOBS_SEL_FIELDS.FIELD_NAME = ZCA_OML_JOBS_SEL_FIELDS_TL.FIELD_NAME and ZCA_OML_JOBS_SEL_FIELDS.USECASE_CODE = ZCA_OML_JOBS_SEL_FIELDS_TL.USECASE_CODE and ZCA_OML_JOBS_SEL_FIELDS_TL.LANGUAGE = USERENV('LANG')