1. Tables and Views for SCM
  2. CZ_SS_ITEM_CLASSES_VL

CZ_SS_ITEM_CLASSES_VL

Details

  • Schema: FUSION

  • Object owner: CZ

  • Object type: VIEW

Columns

Name

ITEM_CLASS_ID

PRODUCTION_FLAG

ITEM_CLASS_CODE

PARENT_ITEM_CLASS_ID

DELETED_FLAG

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ITEM_CLASS_NAME

DESCRIPTION

Query

SQL_Statement

SELECT

B.ITEM_CLASS_ID,

B.PRODUCTION_FLAG,

B.ITEM_CLASS_CODE,

B.PARENT_ITEM_CLASS_ID,

B.DELETED_FLAG,

B.REQUEST_ID,

B.JOB_DEFINITION_NAME,

B.JOB_DEFINITION_PACKAGE,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

T.ITEM_CLASS_NAME,

T.DESCRIPTION

FROM CZ_SS_ITEM_CLASSES_B B, CZ_SS_ITEM_CLASSES_TL T

WHERE B.ITEM_CLASS_ID = T.ITEM_CLASS_ID

AND B.PRODUCTION_FLAG = T.PRODUCTION_FLAG

AND T.LANGUAGE = USERENV('LANG')