[Home] [Help]
View: ASF_INVENTORY_LOV_V
Product: | ASF - Sales Online |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT ITEM.INVENTORY_ITEM_ID
, ITEM.CATEGORY_ID
, ITEM.ORGANIZATION_ID
, ITEM.INTEREST_TYPE_ID
, ITEM.PRIMARY_INTEREST_CODE_ID
, ITEM.SECONDARY_INTEREST_CODE_ID
, ITEM.ITEM_CONCAT_SEGS
, ITEM.ITEM_DESCRIPTION
, UOM.UOM_CODE
, UOM.UOM_DESCRIPTION
FROM AS_INV_ITEM_LOV_V ITEM
, AS_INV_UOM_V UOM
WHERE ITEM.INVENTORY_ITEM_ID = UOM.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = UOM.ORGANIZATION_ID
Columns
Name |
INVENTORY_ITEM_ID |
CATEGORY_ID |
ORGANIZATION_ID |
INTEREST_TYPE_ID |
PRIMARY_INTEREST_CODE_ID |
SECONDARY_INTEREST_CODE_ID |
ITEM_CONCAT_SEGS |
ITEM_DESCRIPTION |
UOM_CODE |
UOM_DESCRIPTION |