SELECT EXTENSION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, DATA_LEVEL_ID, PK1_VALUE, PK2_VALUE, REVISION_ID,D_EXT_ATTR1 DEPOSIT_VALUE_EFFECTIVE_DATE,D_EXT_ATTR2 DEPOSIT_VALUE_END_DATE FROM EGO_MTL_SY_ITEMS_EXT_VL WHERE attr_group_id = 80
SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, REVISION_ID
, D_EXT_ATTR1 DEPOSIT_VALUE_EFFECTIVE_DATE
, D_EXT_ATTR2 DEPOSIT_VALUE_END_DATE
FROM EGO_MTL_SY_ITEMS_EXT_VL
WHERE ATTR_GROUP_ID = 80
|
|
|