DBA Data[Home] [Help]

VIEW: APPS.EGO_SBDH_SIZE_INFO_AGV

Source

View Text - Preformatted

SELECT EXTENSION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, DATA_LEVEL_ID, PK1_VALUE, PK2_VALUE, REVISION_ID,C_EXT_ATTR1 SIZE_GROUP,C_EXT_ATTR2 SIZE_SYSTEM,C_EXT_ATTR3 SIZE_TYPE,TL_EXT_ATTR4 DESCRIPTIVE_SIZE_DIMENSION FROM EGO_MTL_SY_ITEMS_EXT_VL WHERE attr_group_id  = 99
View Text - HTML Formatted

SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, REVISION_ID
, C_EXT_ATTR1 SIZE_GROUP
, C_EXT_ATTR2 SIZE_SYSTEM
, C_EXT_ATTR3 SIZE_TYPE
, TL_EXT_ATTR4 DESCRIPTIVE_SIZE_DIMENSION
FROM EGO_MTL_SY_ITEMS_EXT_VL
WHERE ATTR_GROUP_ID = 99