1. Tables and Views for SCM
  2. DOO_HOLD_CODES_VL

DOO_HOLD_CODES_VL

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

HOLD_CODE_ID

OBJECT_VERSION_NUMBER

HOLD_CODE

HOLD_NAME

HOLD_DESCRIPTION

SET_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

GENERAL_HOLD_FLAG

SYSTEM_FLAG

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ORCHESTRATION_APPLICATION_ID

APPLY_HOLD_ROLE_ELIGIBILITY

RELEASE_HOLD_ROLE_ELIGIBILITY

Query

SQL_Statement

SELECT

b.HOLD_CODE_ID,

b.OBJECT_VERSION_NUMBER,

b.HOLD_CODE,

t.HOLD_NAME,

t.HOLD_DESCRIPTION,

b.SET_ID,

b.EFFECTIVE_START_DATE,

b.EFFECTIVE_END_DATE,

b.GENERAL_HOLD_FLAG,

b.SYSTEM_FLAG,

b.CREATION_DATE,

b.CREATED_BY,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.ORCHESTRATION_APPLICATION_ID,

b.APPLY_HOLD_ROLE_ELIGIBILITY,

b.RELEASE_HOLD_ROLE_ELIGIBILITY

FROM

DOO_HOLD_CODES_B b,

DOO_HOLD_CODES_TL t

WHERE

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