1. Tables and Views for SCM
  2. EGP_STRUCTURE_TYPES_VL

EGP_STRUCTURE_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: VIEW

Columns

Name

ROW_ID

STRUCTURE_TYPE_ID

STRUCTURE_TYPE_NAME

LANGUAGE

SOURCE_LANG

DISPLAY_NAME

DESCRIPTION

EFFECTIVE_DATE

DISABLE_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

OBJECT_VERSION_NUMBER

APPLICATION_ID

DEF_WIP_SUP_FOR_COMP_FLAG

COMP_ITM_SEQ_INC

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

QUANTITY_MISMATCH

QUANTITY_RELATED

DUPLICATE_REF_DESIGNATORS

RD_RANGE_INDICATOR

Query

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.STRUCTURE_TYPE_ID,

B.STRUCTURE_TYPE_NAME,

TL.LANGUAGE,

TL.SOURCE_LANG,

TL.DISPLAY_NAME,

TL.DESCRIPTION,

B.EFFECTIVE_DATE,

B.DISABLE_DATE,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_LOGIN,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.ATTRIBUTE16,

B.ATTRIBUTE17,

B.ATTRIBUTE18,

B.ATTRIBUTE19,

B.ATTRIBUTE20,

B.ATTRIBUTE21,

B.ATTRIBUTE22,

B.ATTRIBUTE23,

B.ATTRIBUTE24,

B.ATTRIBUTE25,

B.ATTRIBUTE26,

B.ATTRIBUTE27,

B.ATTRIBUTE28,

B.ATTRIBUTE29,

B.ATTRIBUTE30,

B.OBJECT_VERSION_NUMBER,

B.APPLICATION_ID,

B.DEF_WIP_SUP_FOR_COMP_FLAG,

B.COMP_ITM_SEQ_INC,

B.ATTRIBUTE_NUMBER1 ,

B.ATTRIBUTE_NUMBER2 ,

B.ATTRIBUTE_NUMBER3 ,

B.ATTRIBUTE_NUMBER4 ,

B.ATTRIBUTE_NUMBER5 ,

B.ATTRIBUTE_NUMBER6 ,

B.ATTRIBUTE_NUMBER7 ,

B.ATTRIBUTE_NUMBER8 ,

B.ATTRIBUTE_NUMBER9 ,

B.ATTRIBUTE_NUMBER10 ,

B.ATTRIBUTE_DATE1 ,

B.ATTRIBUTE_DATE2 ,

B.ATTRIBUTE_DATE3 ,

B.ATTRIBUTE_DATE4 ,

B.ATTRIBUTE_DATE5 ,

B.ATTRIBUTE_TIMESTAMP1 ,

B.ATTRIBUTE_TIMESTAMP2 ,

B.ATTRIBUTE_TIMESTAMP3 ,

B.ATTRIBUTE_TIMESTAMP4 ,

B.ATTRIBUTE_TIMESTAMP5,

B.QUANTITY_MISMATCH,

B.QUANTITY_RELATED,

B.DUPLICATE_REF_DESIGNATORS,

B.RD_RANGE_INDICATOR

FROM

EGP_STRUCTURE_TYPES_TL TL,

EGP_STRUCTURE_TYPES_B B

WHERE

TL.LANGUAGE = USERENV('LANG') AND TL.STRUCTURE_TYPE_ID = B.STRUCTURE_TYPE_ID