DBA Data[Home] [Help]

VIEW: APPS.EGO_SBDH_BUYING_QTY_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 AGREED_MINIMUM_BUYING_QTY,N_EXT_ATTR2 AGREED_MAXIMUM_BUYING_QTY,D_EXT_ATTR3 START_DATE_MINIMUM_BUYING_QTY,D_EXT_ATTR4 END_DATE_MINIMUM_BUYING_QTY,D_EXT_ATTR5 START_DATE_MAXIMUM_BUYING_QTY,D_EXT_ATTR6 END_DATE_MAXIMUM_BUYING_QTY FROM EGO_MTL_SY_ITEMS_EXT_VL WHERE attr_group_id  = 82
View Text - HTML Formatted

SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, REVISION_ID
, N_EXT_ATTR1 AGREED_MINIMUM_BUYING_QTY
, N_EXT_ATTR2 AGREED_MAXIMUM_BUYING_QTY
, D_EXT_ATTR3 START_DATE_MINIMUM_BUYING_QTY
, D_EXT_ATTR4 END_DATE_MINIMUM_BUYING_QTY
, D_EXT_ATTR5 START_DATE_MAXIMUM_BUYING_QTY
, D_EXT_ATTR6 END_DATE_MAXIMUM_BUYING_QTY
FROM EGO_MTL_SY_ITEMS_EXT_VL
WHERE ATTR_GROUP_ID = 82