1. Tables and Views for SCM
  2. DOO_JEOPARDY_THRESHOLDS_VL

DOO_JEOPARDY_THRESHOLDS_VL

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

JEOPARDY_SCORE

DESCRIPTION

MINIMUM_DELAY_VALUE

MAXIMUM_DELAY_VALUE

JEOPARDY_HEADER_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

MAXIMUM_UOM

MINIMUM_UOM

JEOPARDY_THRESHOLD_ID

SEQUENCE_NUMBER

ORCHESTRATION_APPLICATION_ID

Query

SQL_Statement

SELECT

b.JEOPARDY_SCORE,

t.DESCRIPTION,

b.MINIMUM_DELAY_VALUE,

b.MAXIMUM_DELAY_VALUE,

b.JEOPARDY_HEADER_ID,

b.OBJECT_VERSION_NUMBER,

b.CREATED_BY,

b.CREATION_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.MAXIMUM_UOM,

b.MINIMUM_UOM,

b.JEOPARDY_THRESHOLD_ID,

b.SEQUENCE_NUMBER,

b.ORCHESTRATION_APPLICATION_ID

FROM

DOO_JEOPARDY_THRESHOLDS_B b,

DOO_JEOPARDY_THRESHOLDS_TL t

WHERE

b.JEOPARDY_THRESHOLD_ID = t.JEOPARDY_THRESHOLD_ID AND t.LANGUAGE = USERENV('LANG')