DBA Data[Home] [Help]

VIEW: APPS.EGO_SBDH_TRADE_ITEM_INFO_AGV

Source

View Text - Preformatted

SELECT EXTENSION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, DATA_LEVEL_ID, PK1_VALUE, PK2_VALUE, REVISION_ID,N_EXT_ATTR1 TRADE_ITEM_COMPOSTN_WIDTH,C_EXT_ATTR2 TRADE_ITEM_MARKETING_MESSAGE,N_EXT_ATTR3 PEG_HOLE_NUMBER,TL_EXT_ATTR4 ALLOWANCE_CHARGE_DESCR,C_EXT_ATTR6 LINK_TO_EXTERNAL_DESCRIPTION FROM EGO_MTL_SY_ITEMS_EXT_VL WHERE attr_group_id  = 42
View Text - HTML Formatted

SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, REVISION_ID
, N_EXT_ATTR1 TRADE_ITEM_COMPOSTN_WIDTH
, C_EXT_ATTR2 TRADE_ITEM_MARKETING_MESSAGE
, N_EXT_ATTR3 PEG_HOLE_NUMBER
, TL_EXT_ATTR4 ALLOWANCE_CHARGE_DESCR
, C_EXT_ATTR6 LINK_TO_EXTERNAL_DESCRIPTION
FROM EGO_MTL_SY_ITEMS_EXT_VL
WHERE ATTR_GROUP_ID = 42