DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.EGO_MTL_SY_ITEMS_EXT_VL

Object Details
Object Name: EGO_MTL_SY_ITEMS_EXT_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_MTL_SY_ITEMS_EXT_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER
Yes Unique identifier for the rows in Item and Item Revision Extension Table
ORGANIZATION_ID NUMBER
Yes Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
REVISION_ID NUMBER

Item Revision Id.Foreign key to MTL_ITEM_REVISIONS_B
ITEM_CATALOG_GROUP_ID NUMBER
Yes Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B
ATTR_GROUP_ID NUMBER
Yes Custom Attribute Group Identifier
DATA_LEVEL_ID NUMBER
Yes Foreign Key referencing EGO_DATA_LEVEL_B.data_level_id
PK1_VALUE NUMBER

Primary Key 1 value corresponding to Data Level
PK2_VALUE NUMBER

Primary Key 1 value corresponding to Data Level
PK3_VALUE NUMBER

Primary Key 1 value corresponding to Data Level
PK4_VALUE NUMBER

Primary Key 1 value corresponding to Data Level
PK5_VALUE NUMBER

Primary Key 1 value corresponding to Data Level
CREATED_BY NUMBER
Yes One of the five standard "WHO" columns
CREATION_DATE DATE
Yes One of the five standard "WHO" columns
LAST_UPDATED_BY NUMBER
Yes One of the five standard "WHO" columns
LAST_UPDATE_DATE DATE
Yes One of the five standard "WHO" columns
LAST_UPDATE_LOGIN NUMBER

One of the five standard "WHO" columns
SOURCE_LANG VARCHAR2 (4) Yes Language in which the row was initially created
LANGUAGE VARCHAR2 (4) Yes Language in which the row data is currently stored
C_EXT_ATTR1 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR2 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR3 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR4 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR5 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR6 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR7 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR8 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR9 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR10 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR11 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR12 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR13 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR14 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR15 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR16 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR17 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR18 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR19 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR20 VARCHAR2 (150)
Attribute to store character values
N_EXT_ATTR1 NUMBER

Attribute to store numbers
UOM_EXT_ATTR1 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR2 NUMBER

Attribute to store numbers
UOM_EXT_ATTR2 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR3 NUMBER

Attribute to store numbers
UOM_EXT_ATTR3 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR4 NUMBER

Attribute to store numbers
UOM_EXT_ATTR4 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR5 NUMBER

Attribute to store numbers
UOM_EXT_ATTR5 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR6 NUMBER

Attribute to store numbers
UOM_EXT_ATTR6 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR7 NUMBER

Attribute to store numbers
UOM_EXT_ATTR7 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR8 NUMBER

Attribute to store numbers
UOM_EXT_ATTR8 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR9 NUMBER

Attribute to store numbers
UOM_EXT_ATTR9 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR10 NUMBER

Attribute to store numbers
UOM_EXT_ATTR10 VARCHAR2 (3)
Attribute to store unit of measure
D_EXT_ATTR1 DATE

Attribute to store date
D_EXT_ATTR2 DATE

Attribute to store date
D_EXT_ATTR3 DATE

Attribute to store date
D_EXT_ATTR4 DATE

Attribute to store date
D_EXT_ATTR5 DATE

Attribute to store date
C_EXT_ATTR21 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR22 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR23 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR24 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR25 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR26 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR27 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR28 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR29 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR30 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR31 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR32 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR33 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR34 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR35 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR36 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR37 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR38 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR39 VARCHAR2 (150)
Attribute to store character values
C_EXT_ATTR40 VARCHAR2 (150)
Attribute to store character values
N_EXT_ATTR11 NUMBER

Attribute to store numbers
UOM_EXT_ATTR11 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR12 NUMBER

Attribute to store numbers
UOM_EXT_ATTR12 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR13 NUMBER

Attribute to store numbers
UOM_EXT_ATTR13 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR14 NUMBER

Attribute to store numbers
UOM_EXT_ATTR14 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR15 NUMBER

Attribute to store numbers
UOM_EXT_ATTR15 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR16 NUMBER

Attribute to store numbers
UOM_EXT_ATTR16 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR17 NUMBER

Attribute to store numbers
UOM_EXT_ATTR17 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR18 NUMBER

Attribute to store numbers
UOM_EXT_ATTR18 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR19 NUMBER

Attribute to store numbers
UOM_EXT_ATTR19 VARCHAR2 (3)
Attribute to store unit of measure
N_EXT_ATTR20 NUMBER

Attribute to store numbers
UOM_EXT_ATTR20 VARCHAR2 (3)
Attribute to store unit of measure
D_EXT_ATTR6 DATE

Attribute to store date
D_EXT_ATTR7 DATE

Attribute to store date
D_EXT_ATTR8 DATE

Attribute to store date
D_EXT_ATTR9 DATE

Attribute to store date
D_EXT_ATTR10 DATE

Attribute to store date
TL_EXT_ATTR1 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR2 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR3 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR4 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR5 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR6 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR7 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR8 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR9 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR10 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR11 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR12 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR13 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR14 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR15 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR16 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR17 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR18 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR19 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR20 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR21 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR22 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR23 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR24 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR25 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR26 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR27 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR28 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR29 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR30 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR31 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR32 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR33 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR34 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR35 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR36 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR37 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR38 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR39 VARCHAR2 (1000)
Attribute to store language-specific character values
TL_EXT_ATTR40 VARCHAR2 (1000)
Attribute to store language-specific character values
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXTENSION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION_ID
,      ITEM_CATALOG_GROUP_ID
,      ATTR_GROUP_ID
,      DATA_LEVEL_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SOURCE_LANG
,      LANGUAGE
,      C_EXT_ATTR1
,      C_EXT_ATTR2
,      C_EXT_ATTR3
,      C_EXT_ATTR4
,      C_EXT_ATTR5
,      C_EXT_ATTR6
,      C_EXT_ATTR7
,      C_EXT_ATTR8
,      C_EXT_ATTR9
,      C_EXT_ATTR10
,      C_EXT_ATTR11
,      C_EXT_ATTR12
,      C_EXT_ATTR13
,      C_EXT_ATTR14
,      C_EXT_ATTR15
,      C_EXT_ATTR16
,      C_EXT_ATTR17
,      C_EXT_ATTR18
,      C_EXT_ATTR19
,      C_EXT_ATTR20
,      N_EXT_ATTR1
,      UOM_EXT_ATTR1
,      N_EXT_ATTR2
,      UOM_EXT_ATTR2
,      N_EXT_ATTR3
,      UOM_EXT_ATTR3
,      N_EXT_ATTR4
,      UOM_EXT_ATTR4
,      N_EXT_ATTR5
,      UOM_EXT_ATTR5
,      N_EXT_ATTR6
,      UOM_EXT_ATTR6
,      N_EXT_ATTR7
,      UOM_EXT_ATTR7
,      N_EXT_ATTR8
,      UOM_EXT_ATTR8
,      N_EXT_ATTR9
,      UOM_EXT_ATTR9
,      N_EXT_ATTR10
,      UOM_EXT_ATTR10
,      D_EXT_ATTR1
,      D_EXT_ATTR2
,      D_EXT_ATTR3
,      D_EXT_ATTR4
,      D_EXT_ATTR5
,      C_EXT_ATTR21
,      C_EXT_ATTR22
,      C_EXT_ATTR23
,      C_EXT_ATTR24
,      C_EXT_ATTR25
,      C_EXT_ATTR26
,      C_EXT_ATTR27
,      C_EXT_ATTR28
,      C_EXT_ATTR29
,      C_EXT_ATTR30
,      C_EXT_ATTR31
,      C_EXT_ATTR32
,      C_EXT_ATTR33
,      C_EXT_ATTR34
,      C_EXT_ATTR35
,      C_EXT_ATTR36
,      C_EXT_ATTR37
,      C_EXT_ATTR38
,      C_EXT_ATTR39
,      C_EXT_ATTR40
,      N_EXT_ATTR11
,      UOM_EXT_ATTR11
,      N_EXT_ATTR12
,      UOM_EXT_ATTR12
,      N_EXT_ATTR13
,      UOM_EXT_ATTR13
,      N_EXT_ATTR14
,      UOM_EXT_ATTR14
,      N_EXT_ATTR15
,      UOM_EXT_ATTR15
,      N_EXT_ATTR16
,      UOM_EXT_ATTR16
,      N_EXT_ATTR17
,      UOM_EXT_ATTR17
,      N_EXT_ATTR18
,      UOM_EXT_ATTR18
,      N_EXT_ATTR19
,      UOM_EXT_ATTR19
,      N_EXT_ATTR20
,      UOM_EXT_ATTR20
,      D_EXT_ATTR6
,      D_EXT_ATTR7
,      D_EXT_ATTR8
,      D_EXT_ATTR9
,      D_EXT_ATTR10
,      TL_EXT_ATTR1
,      TL_EXT_ATTR2
,      TL_EXT_ATTR3
,      TL_EXT_ATTR4
,      TL_EXT_ATTR5
,      TL_EXT_ATTR6
,      TL_EXT_ATTR7
,      TL_EXT_ATTR8
,      TL_EXT_ATTR9
,      TL_EXT_ATTR10
,      TL_EXT_ATTR11
,      TL_EXT_ATTR12
,      TL_EXT_ATTR13
,      TL_EXT_ATTR14
,      TL_EXT_ATTR15
,      TL_EXT_ATTR16
,      TL_EXT_ATTR17
,      TL_EXT_ATTR18
,      TL_EXT_ATTR19
,      TL_EXT_ATTR20
,      TL_EXT_ATTR21
,      TL_EXT_ATTR22
,      TL_EXT_ATTR23
,      TL_EXT_ATTR24
,      TL_EXT_ATTR25
,      TL_EXT_ATTR26
,      TL_EXT_ATTR27
,      TL_EXT_ATTR28
,      TL_EXT_ATTR29
,      TL_EXT_ATTR30
,      TL_EXT_ATTR31
,      TL_EXT_ATTR32
,      TL_EXT_ATTR33
,      TL_EXT_ATTR34
,      TL_EXT_ATTR35
,      TL_EXT_ATTR36
,      TL_EXT_ATTR37
,      TL_EXT_ATTR38
,      TL_EXT_ATTR39
,      TL_EXT_ATTR40
FROM APPS.EGO_MTL_SY_ITEMS_EXT_VL;

Dependencies

[top of page]

APPS.EGO_MTL_SY_ITEMS_EXT_VL references the following:

SchemaAPPS
SynonymEGO_MTL_SY_ITEMS_EXT_B
SynonymEGO_MTL_SY_ITEMS_EXT_TL
APPS.EGO_MTL_SY_ITEMS_EXT_VL is referenced by following:

SchemaAPPS
ViewCZ_EXV_ITEM_APC_PROP_VALUES
ViewEGO_SBDH_BUYING_QTY_INFO_AGV
ViewEGO_SBDH_CAMPAIGN_INFO_AGV
ViewEGO_SBDH_CLASS_COMPLIANCE_AGV
ViewEGO_SBDH_COUNTRY_OF_ASSY_AGV
ViewEGO_SBDH_DEP_VAL_DATE_INFO_AGV
ViewEGO_SBDH_ITEM_FEATURE_BNFT_AGV
ViewEGO_SBDH_MATERIAL_INFO_AGV
ViewEGO_SBDH_ORDERING_INFO_AGV
ViewEGO_SBDH_PAYMENT_METHOD_AGV
ViewEGO_SBDH_PRC_CMPRSN_CONTNT_AGV
ViewEGO_SBDH_PRC_CMPRSN_MSRMT_AGV
ViewEGO_SBDH_PRICE_INFO_AGV
ViewEGO_SBDH_RETURNS_AGV
ViewEGO_SBDH_SEASON_AGV
ViewEGO_SBDH_SEASON_AVL_DATE_AGV
ViewEGO_SBDH_SHIP_EXCL_DATES_AGV
ViewEGO_SBDH_SIZE_INFO_AGV
ViewEGO_SBDH_SPECIAL_ITEM_AGV
ViewEGO_SBDH_STRG_HNDLG_HMDTY_AGV
ViewEGO_SBDH_TARGET_CONSUMER_AGV
ViewEGO_SBDH_TRADE_ITEM_INFO_AGV
ViewEGO_SBDH_TRD_ITM_LIFESPAN_AGV
ViewEGO_SBDH_VAR_TRD_ITEM_TYPE_AGV
Package BodyEGO_UI_ITEM_PUB - show dependent code
Package BodyENG_CHANGE_IMPORT_UTIL - show dependent code
Package BodyINV_EBI_ITEM_HELPER - show dependent code